Database Design Assignment
Database Design Assignment
You are a database designer assigned to design a database for a video rental store. Please list 5 relevant entities to be used in your design. For each of the 5 entities please list at least 5 attributes. For each of the 5 entities please list the primary key. For each of the 5 entities create a table with attributes as its columns. Create 3 records (rows) with data items in the attribute columns.
This is an exercise in how well you can do research and grasp new concepts. Please use the course materials and internet to do research on these database terms and concepts in order to complete the assignment.
Example:
Entity X
Attributes: Number, Name, Color, Count, Month
Primary Key: Number
Number |
Name |
Color |
Count |
Month |
1 |
A |
Green |
3 |
January |
2 |
B |
Red |
2 |
March |
3 |
C |
Blue |
4 |
August |
Save your work in a word document named db_design_<firstname_lastname>.doc (ie. db_design_christine_lin.doc) and post in the assignments area.