Question: Create an entity relationship model based on the following information: (6 marks) UCSICafe is a cafeteria which set up in many countries such as

Create an entity relationship model based on the following information: (6 marks) 

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!