Essay
Unit 18 - Assignment 1 - P1, M1, D1
- Course
- Institution
Unit 18 Database Design. Introduction to relational Databases. All criteria achieved, P1, M1 and D1.
[Show more]
Seller
Follow
leoJBlack
Reviews received
Content preview
EDEXCEL BTEC LEVEL 3 90 CREDIT DIPLOMA IN INFORMATION TECHNOLOGYAssignment 2
Designing a Relational Database
Joel
16/06/2017
, Task 1:
Normalisation:
1NF:
Order Number
Date of Order
Customer ID
Customer Name
Customer Address
Customer Postcode
Customer Contact
Number
Delivery Address
Delivery Postcode
Delivery Date
Delivery Time
Sandwich Code
Sandwich Description
Sandwich Price
Sandwich Quantity
Line Total
Total Price
Order Paid (Tick box)
Shop ID
Shop Location
Staff ID
Staff Name
2NF:
To get to 2NF the headings need to be split up into several tables.
Customer Customer Customer Customer Customer Delivery Delivery Deliver Deliver
ID Name Address Postcode Contact Address Postcode y Date y Time
Number
Sandwich Code Sandwich Description Sandwich Price
Staff ID Shop ID Shop Location
Order Date of Sandwich Line Total Total Price Order Paid
Number Order Quantity (Tick box)
3NF:
To get to 3NF the tables need to be split up to ensure there aren’t any headings that are in a table if
they aren’t dependent on that tables primary key. To do this another table for deliveries needs to be
created.
Joel Page 1
, Customer ID Customer Name Customer Address Customer Postcode Customer Contact
Number
Delivery ID Delivery Address Delivery Postcode Delivery Date Delivery Time
The other tables stay the same since they are already at 3NF. These two tables have now also been
put into 3NF since now everything in the table is dependent on its primary key.
Entity Relationship Diagram:
Data Dictionary:
Customer Table
Field Name Data Type Size Notes
Customer ID AutoNumbe
r
Surname Text 20
Name Text 20
Address Text 50
Postcode Text 10 >LL00\ 0LL;0;_
Contact Number Text 20 \(9999") "0009009;0;_
Delivery Table
Field Name Data Type Size Notes
Delivery ID AutoNumbe
Joel Page 2
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller leoJBlack. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $5.82. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
66579 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now