19 lines
950 B
Markdown
19 lines
950 B
Markdown
# Case Study 6
|
||
|
||
## Instructions
|
||
- Answer questions A through E of the Morgan Importing Project found on page 321.
|
||
- Create and set up the MI_CH02 database with the given SQL files.
|
||
- Deliver a single document.
|
||
- These questions require answering the Morgan Importing Project questions at the end of Chapter 5.
|
||
|
||
## Questions MI.A - MI.E
|
||
A.) Convert this data model to a database design. Specify tables, primary keys, and foreign keys. Using Figure 6-43 as a guide, specify column properties.
|
||
|
||
B.) Describe how you have represented weak entities, if any exist.
|
||
|
||
C.) Describe how you have represented supertype and subtype entities, if any exist.
|
||
|
||
D.) Create a visual representation of your database design as a Crow’s Foot E-R diagram similar to the one in Figure 6-39.
|
||
|
||
E.) Document your minimum cardinality enforcement using referential integrity actions for required parents, if any, and the form in Figure 6-29(b) for required children, if any.
|