fundamental of data base assignment 2
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:
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
