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;
16 Cards in this Set
- Front
- Back
Characteristic or property of an entity.
|
Attribute, Field, or a column
|
|
Represents a database visually by using a rectangle for each entity that includes the entity's name above the rectangle and the entity's columns inside the rectangle, using a line to connect two entities that have relationship, and placing a dot at the end of a line to indicate the "many" part of a one-to-many relationship.
|
Entity-relationship (E-R diagram
|
|
File that is used to store data.
|
Data File
|
|
A property that lets you change the structure of a database without requiring you to change the programs that access the database.
|
Data Independence
|
|
A structure that can store information about multiple types of entities, the attributes of those entities, and the relationships between the entities.
|
Database
|
|
Group or person that is in charge of the database, especially if the database will serve many users.
|
Database Administration (DBA) or Database Administrator
|
|
Screen objects used to maintain, view, and print data from a database.
|
Forms
|
|
Process of determining the structure of the required database.
|
Database design
|
|
A program, or a collection of programs, through which users interact with a database. DBMSs let you create forms and reports quickly and easily, as well as obtain answers to questions and the data stored in a database.
|
Database Management System (DBMS)
|
|
A person, place, object, event, or idea for which you want to store and process data.
|
Entity
|
|
Where one entity is related to multiple entities.
|
One-to-many relationship
|
|
The duplication of data or the storing of the same data in more than one place.
|
Redundancy
|
|
An association between entities.
|
Relationship
|
|
Prevention of unauthorized access to the database.
|
Security
|
|
When database data satifies all established integrity constraints.
|
Integrity
|
|
A rule that data must follow in the database.
|
Integrity Constraint
|