WGU - D427 Data Management - Applications ZyBooks Labs 7 and 8 (Latest 2026 / 2027 Update) Questions & Answers {Grade A} 100% Correct

WGU - D427 Data Management -
Applications ZyBooks Labs 7 and 8 (Latest
Update) Questions & Answers
{Grade A} 100% Correct
8.1 Practice Lab 1




The Member table will have the following columns:


ID—positive integer


FirstName—variable-length string with up to 100 characters


MiddleInitial—fixed-length string with 1 character


LastName—variable-length string with up to 100 characters


DateOfBirth—date


AnnualPledge—positive decimal value representing a cost of up to $999,999, with 2


digits for cents




Write a SQL statement to create the Member table.




Do not add any additional constraints to any column beyond wha - Correct answer

CREATE TABLE Member (

,ID INT UNSIGNED,


FirstName VARCHAR(100),


MiddleInitial CHAR(1),


LastName VARCHAR(100),


DateOfBirth DATE,


AnnualPledge DECIMAL(8,2) UNSIGNED


);




8.2 Practice Lab 2




The Rating table has the following columns:


RatingCode—variable-length string, primary key


RatingDescription—variable-length string




The Movie table should have the following columns:


Title—variable-length string, maximum 30 characters


RatingCode—variable-length string, maximum 5 characters

, Write a SQL statement to create the Movie table. Designate the RatingCode column in


the Movie table as a foreign key to the RatingCodecolumn in the Rating table. - Correct


answer CREATE TABLE Movie (


Title VARCHAR(30),


RatingCode VARCHAR(5),


FOREIGN KEY (RatingCode) REFERENCES Rating(RatingCode)


);




8.3 Practice Lab 3




The Movie table has the following columns:


ID—integer, primary key


Title—variable-length string

Genre—variable-length string


RatingCode—variable-length string


Year—integer




A new column must be added to the Movie table: