Question: In this task, you will work individually to draw a Crows Foot Notation Entity Relation Diagram (ERD), which demonstrate your understanding of Topics we learned

In this task, you will work individually to draw a Crows Foot Notation Entity Relation Diagram (ERD), which demonstrate your understanding of Topics we learned in the first 4 sessions. Students are required to use free online tool, www.diagram.net to draw the Crows Foot Notation ERD, based on business rules and data information of a business or an organization, the Institute Registrars Office as follow: Unit MBIS4002 Database Management Systems Assessment Type Individual In-Class Practical Exam Assessment Number A2 Due Date Session 6 Weighting 20% Alignment with Unit and Course Unit Learning Outcome Graduate Attributes Assessed ULO 1: Demonstrate comprehension of how a Relational Database Management Sys., tools and techniques are used to enhance productivity and effectiveness of Database solutions for a business. GA4: Critical thinking & problem solving GA6 Flexibility 6. Departments, including department number, department name; Business rules (i.e., relationships) The Restaurant entity represents a restaurant in the system. It is uniquely identified by the Restaurant ID attribute. The entity also includes attributes such as Restaurant Name, Address, and Phone Number. The Manager entity represents the managers associated with each restaurant. It is uniquely identified by the Manager ID attribute. The entity includes attributes like First Name, Last Name, Email, and Phone Number. Each restaurant can have one or more managers. The Employee entity represents the employees working at the restaurant. It is uniquely identified by the Employee ID attribute. The entity includes attributes such as First Name, Last Name, Position, and Phone Number. Each restaurant can have multiple employees. The Order entity represents customer orders placed at the restaurant. It is uniquely identified by the Order ID attribute. The entity includes attributes such as Customer Name, Table Number, Order Date, and Total Amount. Each restaurant can have multiple orders. The Customer entity represents the customers who visit the restaurant. It is uniquely identified by the Customer ID attribute. The entity includes attributes such as First Name, and Last Name. Restaurant can have multiple customers, and each customer can visit multiple restaurants. Regarding Cardinality Relationships, you are required to document all assumptions, things that are accepted as true or as certain to happen, without proof. Detailed Submission Requirements Submission Requirements of A2 (To draw Crows Foot Notation ERD) are as follows: 1. It is required students must attend class to conduct the test. 2. It is required students must follow the rules of Crow's Foot Notation; 3. It is required students must use Online Tool, https://www.diagrams.net/ to draw the Crow's Foot Notation ERD; 4. It is required students must submit an editable file, such as editable bitmap image (.png) by using https://www.diagram.net, otherwise 0 marks will be given; 5. The name of your submission file should be A2_YourSID.png 6. For any late submissions without support evidence, there will be 20% of total marks reduction. 7. For any Academic Misconducts, 0 marks will be given and it will be reported as Academic Misconducts. e.g. If a student would share solution with other students, these students would receive 0 marks. 8. In order to prevent from Academic Misconducts, any photos t

Step by Step Solution

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 General Management Questions!