COMP3278 Introduction to Database Management Systems
Assignment 1 (10%)
Requirement Analysis, Conceptual Design (ER Modelling) &
Logical Design (ER-Table Conversion)
Due Date: 2020 Oct 2 (Fri.) 6:30pm
Question Specification
Your company wants to develop a mobile application for an online food delivery platform. Being a Database
Architect, you are asked to perform ER Modelling and then convert the ER model to Relational Table Schema for the
following user requirements and activities: Target domain is an online food delivery platform. Target users are restaurants, customers, and riders. Different users should register the corresponding
restaurant/customer/rider account on this platform. For the convince of the customers, the restaurant users should provide information including contact,
location, and rating on the platform. The restaurant users release their menus on the platform. The items
on the menu include drinks, food, and sets. The restaurant is required to add one or multiple allergen
information in a drop-down menu for each item. If the items do not contain allergens, the restaurant user
should select: 'This item contains no known allergens'. The customer users must register with their phone number. They could save one or multiple locations in
their address list. The rider users need to register with their phone number and driver’s license number. The customer users can add multiple of the same item in one single order, but they could only pick the
items from one restaurant. However, the customer could place multiple orders from one or more
restaurants, active at the same time. Every order will be allocated to a nearby rider to deliver.
Please note that the attributes of the possible entities, relationships, and constraints have not been mentioned
explicitly, so you need to analyze the above user requirements and activities to come up with an appropriate data
model. In real practice, often users are not able to clearly specify all the requirements and also you may not be
familiar with the target domain so you may not fully understand the user requirements or you may have questions
on that. So, please feel free to post your questions on Moodle forum for clarification of user requirements and
activities.
2
COMP3278 Introduction to Database Management Systems Assignment 1
Assignment Requirements
1. Construct an appropriate ER Diagram (50%) Your ER diagram must show all necessary entities, attributes, relationships, participation and
cardinality constraints, also identifiers/identifying attributes as necessary, weak entities and multivalued
attributes if any. You should use appropriate naming for entities, attributes, and relationships. You may also add notes
to your diagram to state your representation clearly. For any information not listed in the specification, please ask for clarifications on Moodle forum and
state clearly the clarifications with your ER model, or make a reasonable assumption and state clearly
the assumptions that you have made. You are strongly encouraged to draw the ER diagram using any kinds of editors (for example online
ER diagram tool Creately), this can help you to standardize and understand your data model. If you choose to draw the ER diagram by pen/pencil, please scan your work and submit a PDF file.
We may ask you to re-submit a clearer version in case we cannot read the handwriting.
2. Convert your ER diagram to Relational Table Schema (50%) You only need to give the table schema in text form. You d o not need to draw the schema, and d o not
need to provide the data type/SQL to create the tables. For each relation, underline the primary key, and specify all the foreign keys, if any.
3. You need to carefully design the data model and convert the data model to tables, storing unnecessary or
redundant entities, attributes and relationships may result in lower marks.
Submission
Please submit your answer in one PDF file to Moodle on or before 2020 Oct 2 (Fri.) 6:30pm and please
make sure all contents are readable.
if you encounter any difficulty in this assignment. We would be very happy to help.