联系方式

  • QQ:99515681
  • 邮箱:99515681@qq.com
  • 工作时间:8:00-23:00
  • 微信:codinghelp2

您当前位置:首页 >> Database作业Database作业

日期:2020-09-27 10:37

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.


版权所有:编程辅导网 2018 All Rights Reserved 联系方式:QQ:99515681 电子信箱:99515681@qq.com
免责声明:本站部分内容从网络整理而来,只供参考!如有版权问题可联系本站删除。