Homework 4: ER-Relational Schema Mapping

Download Solution: Click to Download Solution
Solution File Name: RelationalMapping_123AAA12B.doc
Unzip Password: prestobear.com

Question 1 (50 pts)
Map the swimmer ERD in last homework into a relational schema, please use the answer key given by the instructor for the mapping if your design is flawed.
o write out the relational schema based on your mapping result and specify the pks and the referential integrity constraints.
o Introduce surrogate keys for tables with composite keys (note this is a requirement that’s different from the previous question) and specify the referential integrity constraints.

Question 2 (50 pts)
map the CD ERD in last homework into a relational schema. please use the answer key given by the instructor for the mapping if your design is flawed.
o write out the relational schema based on your mapping result and specify the pks and the referential integrity constraints.
o Introduce surrogate keys for tables with composite keys and specify the pks and the referential integrity constraints.

Question 3:
o Please tell me honestly how you feel about using the tool for ER-relational mapping (do you feel it helps you understand the mapping or it actually hinders your understanding and furthermore did it help you understand ER modeling?)
 if it helps you, please tell me in what way
 if it confuses you, please also tell me in what way

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.