COMP3278程序辅导、Database程序写作、辅导SQL

” COMP3278程序辅导、Database程序写作、辅导SQLCOMP3278 Introduction to Database Management SystemsAssignment 1 (10%)Requirement Analysis, Conceptual Design (ER Modelling) Logical Design (ER-Table Conversion)Due Date: 2020 Oct 2 (Fri.) 6:30pmQuestion SpecificationYour company wants to develop a mobile application for an online food delivery platform. Being a DatabaseArchitect, you are asked to perform ER Modelling and then convert the ER model to Relational Table Schema for thefollowing user requirements and Activities: Target domain is an online food delivery platform. Target users are restaurants, customers, and riders. Different users should register the correspondingrestaurant/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 itemson the menu include drinks, food, and sets. The restaurant is required to add one or multiple allergeninformation in a drop-down menu for each item. If the items do not contain allergens, the restaurant usershould select: This item contains no known allergens. The customer users must register with their phone number. They could save one or multiple locations intheir address list. The rider users need to register with their phone number and drivers license number. The customer users can add multiple of the same item in one single order, but they could only pick theitems from one restaurant. However, the customer could place multiple orders from one or morerestaurants, 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 mentionedexplicitly, so you need to analyze the above user requirements and activities to come up with an appropriate datamodel. In real practice, often users are not able to clearly specify all the requirements and also you may not befamiliar with the target domain soYou may not fully understand the user requirements or you may have questionson that. So, please feel free to post your questions on Moodle forum for clarification of user requirements andactivities.COMP3278作业辅导、Database作业写作COMP3278 Introduction to Database Management Systems Assignment 1Assignment Requirements1. Construct an appropriate ER Diagram (50%) Your ER diagram must show all necessary entities, attributes, relationships, participation andcardinality constraints, also identifiers/identifying attributes as necessary, weak entities and multivaluedattributes if any. You should use Appropriate naming for entities, attributes, and relationships. You may also add notesto your Diagram to state your representation clearly. For any information not listed in the specification, please ask for clarifications on Moodle forum andstate clearly the clarifications with your ER model, or make a reasonable assumption and state clearlythe assumptions that you have made. You are strongly encouraged to draw the ER diagram using any kinds of editors (for example onlineER 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 notneed 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 orredundant entities, attributes and relationships May result in lower marks.SubmissionPlease submit your answer in One PDF file to Moodle on or before 2020 Oct 2 (Fri.) 6:30pm and pleasemake sure all contents are readable.if you encounter any difficulty in this assignment. We would be very happy to help.如有需要，请加QQ：99515681 或邮箱：99515681@qq.com

“