H16W 35 Relational Database Management Systems

Added on - 27 Sep 2021

  • 16

    Pages

  • 1641

    Words

  • 24

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 4 of 16 pages
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
30thSeptember 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)
Entity Name: Staff
AttributeDatatype
StaffIdINT (10)
FirstNameVARCHAR (50)
LastNameVARCHAR (50)
RoleVARCHAR (50)
Entity Name: Menu
AttributeDatatype
MenuIdINT (10)
Entity Name: Shift
AttributeDatatype
StaffMemberIdINT (10)
StartShiftDATETIME
EndShiftDATETIME
Entity Name: FoodItem
AttributeDatatype
FoodIdINT (10)
DescriptionVARCHAR (50)
NameVARCHAR (50)
PriceDECIMAL (10,2)
Entity Name: RegularMenu
AttributeDatatype
MenuIdINT (10)
IsBreakFastBIT
Entity Name: SaversMenu
AttributeDatatype
MenuIdINT (10)
StartDateDATETIME
EndDateDATETIME
Entity Name: Stock
AttributeDatatype
StockIdINT (10)
NameVARCHAR (50)
UnitVARCHAR (50)
QuantityINT (10)
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document