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