Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
19 Cards in this Set
- Front
- Back
|
Client Module
|
Programs that access to database and provides GUIs
|
|
|
Server module
|
handles data storage, access, search and other functions of a DBMS
|
|
|
Data model
|
collection of concepts that can be used to describe the structure of a database
|
|
|
Entity
|
represents a real world object or concept that is described in the database
|
|
|
Relationship
|
Represents an association among entities
|
|
|
Entity-Relationship Model
|
a popular high-level conceptual data model
|
|
|
Database Schema
|
Description of the database (Table names and fields)
|
|
|
Schema Construct
|
Each object in the schema (a table name)
|
|
|
Populate
|
When the state of the database is updated with new information
|
|
|
Three Schema Architectures
|
1.)Internal Level
2.) Conceptual Level 3.) External Level |
|
|
Schema Level: Internal
|
Has internal schema which describes the physical storage structures of the database
|
|
|
Schema Level: Conceptual
|
Describes the structure of the whole database for a community of users. Describes entities, data types, relationships, user operations and constraints.
|
|
|
Schema Level: External
|
Includes a number of external schemas or users views; Shows different views to different user groups
|
|
|
Data definition Languae (DDL)
|
Used by DBA and database designers used to specify conceptual and internal schemas
|
|
|
Storage Definition Language (SDL)
|
used to specify the internal schema.
|
|
|
View Definition Language (VDL)
|
specify user views and their mappings to the conceptual schema
|
|
|
Data manipulation language (DML)
|
set of operations or language to populate the data
|
|
|
Query Language
|
A high level DML used in a standalone interactive manner
|
|
|
Open Database Connectivity (ODBC)
|
provides an API which allows client side programs to call the DBMS
|
