IT 403 SEU Data Model for A Business Application Questions
Description
Having Trouble Meeting Your Deadline?
Get your assignment on IT 403 SEU Data Model for A Business Application Questions completed on time. avoid delay and – ORDER NOW
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:
