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

 

Transcribed Image Text:

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) 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)