Question: 1. Create a complete ER diagram based on the following information. You are required to use crow-foot notation in drawing ER diagram. You are

1. Create a complete ER diagram based on the following information. You are required to use crow-foot 

1. Create a complete ER diagram based on the following information. You are required to use crow-foot notation in drawing ER diagram. You are required to include constraints, description, or assumption in your answer. SeaCafe is a cafeteria which set up in many countries such as Malaysia and Singapore. The main menu of the shop consists of food and beverages such as chicken rice, curry rice, green tea and black coffee. SeaCafe has many employees, and these employees work for a department (headquarter or branches) which located in a country. For example, Aisha works as a finance manager in finance department which is located in Johor, Malaysia (10 Marks) 2. Create an ER diagram for a library management system. The system should be able to handle multiple libraries, each with its own collection of books, patrons, and employees. The data model should include entities for books, authors, publishers, patrons, employees, libraries, borrowing transactions, and overdue fines. Additionally, discuss any potential constraints or assumptions that might arise in implementing this data model in practice. (10 marks) 3. Create an ER diagram for a retail store inventory management system. The system should be able to handle multiple stores, each with its own inventory of products, suppliers, and employees. The data model should include entities for products, categories, suppliers, employees, stores, purchases, sales, and returns. Additionally, discuss any potential constraints or assumptions that might arise in implementing this data model in practice. (10 marks)

Step by Step Solution

3.43 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Databases Questions!