INFS5710 Create An Entity-Relationship (ER) Model Using Crow’s Foot Notation Assignment

Deliverable

1. Create an Entity-Relationship (ER) model using Crow’s foot notation to model the scenario below. An Excel spreadsheet consisting of a few entities (not in Crow’s foot notation) is used to give you a starting point for your model.
2. You have to justify your modelling. You have to justify the creation of key entities and how they are related to other entities. The justifications for creating the model are limited to one page.
3. You are allowed to make reasonable assumptions to justify your model, but you must include these assumptions in your submission. Use your Entity-relationship modelling knowledge and technique to complete this assessment. The list of assumptions should not exceed one A4 page (using 12-point font).
4. Submit your ER diagram using a copy of the Word document template posted on Moodle. A tip here is to draw on a landscape page.
5. Your ER model should be clear, and the text can be read.

Scenario

In the Matthews Food Court, a small takeaway restaurant called Laksa Delight (Laksa Delight | Estate Management - UNSW Sydney). Laksa Delight sells Laksa, noodle soup, hot meal deals and drinks. One day, the owner of the restaurant decided to create a new delivery business in addition to its takeaway business.

Here are some of the business rules for creating a delivery business:

1. All the ingredients and beverages are ordered from different suppliers.
2. Each chef creates a few signature dishes on the menu. Each signature dish has its recipe.
3. A dish is created from several ingredients. Ingredients here can be referred to as fresh products like vegetables, meat, fish, salt, curry powder, noodles, rice, and so on.
4. All the beverages and dishes on the menu are priced by the owner of the restaurant.
5. Only delivery companies registered with Laksa Delight can deliver the orders.
6. Before a customer order any food to be delivered, the customer must create an account. The customer must enter an address and mobile number for the delivery company.
7. A customer can choose from a menu to order several dishes and drinks. The customer has to choose a delivery company and time of delivery. The customers must pay for their orders.
8. For simplicity,

• You do not need to worry about generating invoices and receipts. You just have to model the order entities correctly.
• You do not need to model the payment of the order/invoice.
• You do not have to worry about different pricing of the dishes between takeaway and delivery services.
• You do not have to worry about the purchase price of the goods from the suppliers.
• You can do research on restaurants with the delivery of food. However, you do not have to go into the depth of the delivery process.
• The few entities in the Excel spreadsheet are to give you a starting point for your model.

You must model all the entities using Crow’s foot notation. Only Primary Keys (PKs) are shown on these entities. You are expected to add and modify the entities as necessary.

Remember: you are allowed to make reasonable assumptions when designing your model. You must submit your assumptions along with your ERD.

Drawing Tools

You can use one of the following tools:

• draw.io (draw.io (drawio.com)),
• Lucidchat (Intelligent Diagramming | Lucidchart), or
• Draw option in Microsoft Excel.

Are you struggling to keep up with the demands of your academic journey? Don't worry, we've got your back! Exam Question Bank is your trusted partner in achieving academic excellence for all kind of technical and non-technical subjects.

Our comprehensive range of academic services is designed to cater to students at every level. Whether you're a high school student, a college undergraduate, or pursuing advanced studies, we have the expertise and resources to support you.

To connect with expert and ask your query click here Exam Question Bank