please see the attached file and answer the questions.
|
1.5 Marks |
|
Learning Outcome(s): Develop a data model for a business application (CLO4)
|
Question One
Create an ER diagram to model the following specification:
Answer:
|
1 Mark |
|
Learning Outcome(s): Describe fundamental data and database concepts (CLO1) |
Question Two
Explain the purpose of the foreign key and give an example.
Answer:
|
1.5 Marks |
|
Learning Outcome(s): Design a database for a business application (CLO5) |
Question Three
Reduce the following ER Diagram to a relational schema.
Answer:
|
1 Mark |
|
Learning Outcome(s): Develop a data model for a business application (CLO4) |
Question Four
Represent the following entity using Chen Notation.
Answer:
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
