Ask a question from expert

Ask now

H16W 35 Relational Database Management Systems

16 Pages1641 Words138 Views
   

Added on  2021-09-27

H16W 35 Relational Database Management Systems

   Added on 2021-09-27

BookmarkShareRelated Documents
Assessment Title Database Application for FastBurgers
Qualification Module Code and title
HND in Computer Science H16W 35
Relational Database Management Systems
Student ID and Name Assessor’s Name
S VIJEPRATHAP
01000152
Kanchana Senadheera
Cohort Date Issued Submitted on
30-09-2019
No. Learning Outcome Task no
2 Design an RDBMS from a given scenario.
3 Map the design model to the physical model.
4 Create 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
H16W 35 Relational Database Management Systems_1
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
Attribute Datatype
OrderId INT (10)
CustomerId INT (10)
PaymentMethod VARCHAR (50)
MemberId INT (10)
Date DATE
Entity Name: Customer
Attribute Datatype
CustomerId INT (10)
LastName VARCHAR (50)
FirstName VARCHAR (50)
Telephone VARCHAR (10)
Email VARCHAR (50)
H16W 35 Relational Database Management Systems_2
Entity Name: Staff
Attribute Datatype
StaffId INT (10)
FirstName VARCHAR (50)
LastName VARCHAR (50)
Role VARCHAR (50)
Entity Name: Menu
Attribute Datatype
MenuId INT (10)
Entity Name: Shift
Attribute Datatype
StaffMemberId INT (10)
StartShift DATETIME
EndShift DATETIME
Entity Name: FoodItem
Attribute Datatype
FoodId INT (10)
Description VARCHAR (50)
Name VARCHAR (50)
Price DECIMAL (10,2)
Entity Name: RegularMenu
Attribute Datatype
MenuId INT (10)
IsBreakFast BIT
H16W 35 Relational Database Management Systems_3
Entity Name: SaversMenu
Attribute Datatype
MenuId INT (10)
StartDate DATETIME
EndDate DATETIME
Entity Name: Stock
Attribute Datatype
StockId INT (10)
Name VARCHAR (50)
Unit VARCHAR (50)
Quantity INT (10)
H16W 35 Relational Database Management Systems_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Management System
|25
|1773
|306

ITECH 1006 - Database Management Systems
|14
|4017
|282

Desklib - Online Library for Study Material with Solved Assignments, Essays, Dissertations
|10
|1328
|366

Entity Relationship Diagram docx
|14
|2468
|15

ITECH 1006 Database Management Report Assignment
|8
|1051
|179

ITECH 1006 - Database Management Systems FUA
|7
|741
|205