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;
10 Cards in this Set
- Front
- Back
|
Redundancy |
Duplication of data or storing the same data in more than one place. (Wastes space, can lead to inconsistencies) |
|
|
Entity |
A person, place, object, event or idea for which you want to store and process data. (Sales Reps, Customers, Orders, and Parts) |
|
|
Attribute |
A characteristic or property of an entity. (Customer Name, Street and City) Also called a Field or Column |
|
|
Relationship |
An association between entities. (A rep is related to all of his customers and a customer is related to it's rep). AKA: "One-to-Many relationship because each rep is associated with many customers. |
|
|
Database |
Spreadsheets, documents, web pages and other information sources stored in files. More than a file, a database stores information about multiple entities and their relationships. |
|
|
Table |
How a database manages entities, attributes of entities and relationships between entities. |
|
|
Columns |
A list of attributes of an entity within a table. Reps might have a column for a Rep number, last name, territory and so on. |
|
|
Row |
AKA: Record. Each rep is represented by a row of data. |
|
|
E-R Diagram (Entity-Relationship Diagram) |
A visual way to represent a database. Rectangles represent entities, lines represent relationships. AKA: ERDs |
|
|
Database Management System (DBMS) |
A program, or collection of programs, through which users interact with a database. The actual manipulation of the underlying database is handled by the DBMS. (Access, Oracle, DB2, MySQL, SQL Server) |
