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;
11 Cards in this Set
- Front
- Back
Composite primary key
|
the primary key fields from two intersecting relations.
|
|
Database
|
a collection of information that you organize and access according to the logical structure of that information.
|
|
Database management system (DBMS)
|
helps you specify the logical organization for a database and access and use the information within the database.
|
|
Entity class
|
a concept-typically people, places, or things about which you wish to store information and that you can identify with a unique key (called the primary key).
|
|
Entity-relationship (E-R) diagram
|
a graphic method of representing entity classes and their relationships.
|
|
Foreign key
|
a primary key of one file (relation) that appears in another file (relation).
|
|
Instance
|
an occurrence of an entity class that can be uniquely described.
|
|
Intersection relation
|
a relation you create to eliminate a many-to-many relationship.
|
|
Normalization
|
a process of assuring that a relational database structure can be implemented as a series of two-dimensional relations.
|
|
Primary key
|
a field (or group of fields in some cases) that uniquely describes each record.
|
|
Relational database
|
uses a series of logically related two-dimensional tables or files to store information in the form of a database.
|