Create an entity relationship model based on the following information: (6 marks) UCSICafe is a cafeteria...

 

Transcribed Image Text:

Create an entity relationship model based on the following information: (6 marks) UCSICafe is a cafeteria which set up in many countries such as Malaysia, Singapore and Australia. UCSICafe has many employees, and these employees work for one department. All employees are at the payroll of one country only. For example, James is a finance manager in Finance department located in Melbourne, Australia. Important Note for Question 4: You are required to: 1. use crow-foot notation in drawing entity relationship diagram; 2. include constraints and descriptions/assumption in your answer Create an entity relationship model based on the following information: (6 marks) UCSICafe is a cafeteria which set up in many countries such as Malaysia, Singapore and Australia. UCSICafe has many employees, and these employees work for one department. All employees are at the payroll of one country only. For example, James is a finance manager in Finance department located in Melbourne, Australia. Important Note for Question 4: You are required to: 1. use crow-foot notation in drawing entity relationship diagram; 2. include constraints and descriptions/assumption in your answer

Answer rating: 100% (QA)

Based on the given information we can create an Entity Relationship Model as follows Entities 1 Coun... View the full answer