WGU C170 Data Management – Applications (MySQL) Project
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:
Written for
- Institution
- WGU C170
- Course
- WGU C170
Document information
- Uploaded on
- February 18, 2023
- Number of pages
- 9
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
wgu c170 data management – applications mysql project
Also available in package deal