Assessment TitleDatabase Application for FastBurgers QualificationModule Code and title HND in Computer ScienceH16W 35 Relational Database Management Systems Student ID and NameAssessor’s Name S VIJEPRATHAP 01000152 Kanchana Senadheera CohortDate IssuedSubmitted on 30-09-2019 No.Learning OutcomeTask no 2Design an RDBMS from a given scenario. 3Map the design model to the physical model. 4Create and run SQL statements/queries on a RDBMS. I certify that the work submitted for this Assessment is my own and research sources are fully acknowledged. S Vijeprathap. Student Signature:....................................Date: 30-09-2019
Database Solution for FastBurgers Inc. S VIJE PRATHAP 01000152 30th September 2019 Abstract “FastBurgers” is a fast food franchise with over 100 outlets in the UK. We are requested by the company to create a database solution according to the company’s business rules. This report includes with Entity Relational Diagram, Entity and Attribute dictionary, Normalization schema and the Source code of the program. This report will be the blue print of the program and it included the assumptions which are taken by me and the business rules of the company create the database solution. Entities and Attributes Entity Name: Order AttributeDatatype OrderIdINT (10) CustomerIdINT (10) PaymentMethodVARCHAR (50) MemberIdINT (10) DateDATE Entity Name: Customer AttributeDatatype CustomerIdINT (10) LastNameVARCHAR (50) FirstNameVARCHAR (50) TelephoneVARCHAR (10) EmailVARCHAR (50)