CIS39 Database Design
Question #1: Match the term with the definition:
Term |
Definition |
||
1. |
Database design |
a. |
Represents database visually |
2. |
Record |
b. |
Program(s) used to interact with a database |
3. |
DBMS |
c. |
Duplication of data by storing it on more than one table |
4. |
Relationship |
d. |
Rule that the data in a database must adhere to |
5. |
Redundancy |
e. |
Characteristic or property of an entity |
6. |
Attribute |
f. |
Structure to store information about various types of entities, their attributes and the relationship among them |
7. |
E-R diagram |
g. |
Association between entities |
8. |
Data independence |
h. |
Contains information about a single entity in a table |
9. |
Database |
i. |
Determine the structure of the tables in the database |
10. |
Integrity constraint |
j. |
Allows changes in database structure without having to modify programs |
Question #2: If I store your address on multiple tables in a database, explain the problems that can occur if you change your address (I want both a textbook answer and a practical explanation). What is the name given to this problem?
Question #3: Lets assume you manage an academic library. You want to set up a table that will contain information about journal articles. Do some research and tell me what fields or attributes you would have on the table. An interesting related tutorial is http://dotatmac.mcmaster.ca/db_basics/db_01_home.htm