Timothy Clark C170: Data Management – Applications (MySQL) 1A) 1NF RAW MySQL: CREATE TABLE Orders_1NF ( OrderID INT NOT NULL AUTO_INCREMENT, DonutID INT NOT NULL, DonutName CHAR(75) NOT NULL ... , Description CHAR(255) NULL, UnitPrice DECIMAL(2,2) NULL, Quantity INT NOT NULL, OrderDate DATE NOT NULL, SpecialHandlingNotes CHAR(255) NULL, CustomerID INT NULL, CustomerFirstName CHAR(50) NULL, CustomerLastName CHAR(50) NULL, CustomerStreetAddress1 CHAR(50) NULL, CustomerStreetAddress2 CHAR(50) NULL, CustomerCity CHAR(50) NULL, CustomerState CHAR(2) NULL, CustomerZip CHAR(6) NULL, CustomerHomePhone CHAR(10) NULL, CustomerMobilePhone CHAR(10) NULL, CustomerOtherPhone CHAR(10) NULL, CONSTRAINT PK_Orders_1NF PRIMARY KEY (OrderID, DonutID) ); Explanation: The above code was reached after the following considerations. Firstly, I reviewed the Sales Order Form which was provided with this assignment. After reviewing the Order Form, I broke down the sections into individual elements which I then converted into SQL table columns. This will allow orders to populate as Rows into the Orders_1NF table. The primary key selected is derived from OrderID and DonutID creating a composite key with the two data points which enforces complete uniqueness. [Show More]
Last updated: 3 years ago
Preview 1 out of 9 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
WGU c170 TESTS COMPILATION BUNDLE
By Crum 3 years ago
$15.5
13
Can't find what you want? Try our AI powered Search
Connected school, study & course
About the document
Uploaded On
Oct 21, 2022
Number of pages
9
Written in
All
This document has been written for:
Uploaded
Oct 21, 2022
Downloads
0
Views
161
Scholarfriends.com Online Platform by Browsegrades Inc. 651N South Broad St, Middletown DE. United States.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Scholarfriends · High quality services·