Education > EXAM > WGU C170 Data Management – Applications (MySQL) Project 2022 (All)

Also available in bundle ( Click Here )

WGU C170 Data Management – Applications (MySQL) Project 2022

Document Content and Description Below

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 Now

Instant download

We Accept: