WGUC170

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...

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? Correct Answer: Many-to-many Which two examples are attributes? Correct Answer: An employee number A meeting code Which delete rule sets column values in a child table to a missing value when the matching data is deleted from the parent table? Correct Answer: Set-to-Null member_id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRI...

WGU c170 PROJECT WITH COMPLETE SOLUTION

What type of relationship exists between this pair of related entities? BOOK and BOOK COPY (books have copies) Correct Answer: one-to-many Storing the same data in more than one place is called ____. Correct Answer: redundancy Customers, cars, and parts are examples of: Correct Answer: entities An association between entities is known as a ____. Correct Answer: relationship A visual way to represent a database is with a ____. Correct Answer: entry-relationship diagram Pop...

WGU c170 PRE-ASSESSMENT: DATA MANAGEMENT - APPLICATIONS (FJO1) PFJO WITH COMPLETE SOLUTION

WGU C170 / WGUC170 - Objective Assessment

WGU C170 / WGUC170 - Performance Assessment