WGU D427 Data Management – Applications ZyBooks Labs
https://www.stuvia.com/user/stuviaun
8 _ Complete SQL 1https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
Lab Solutions _ Study Guide _ OA Prephttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
WGU D427 Data Management – Applications ZyBooks Labs 8 | Complete
SQL Lab Solutions | Study Guide | OA Prep
https://www.stuvia.com/user/stuviaun
WGU
https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
D427 Data Management – Applications ZyBooks Labs https://www.stuvia.com/user/stuviaun
8 _ Complete SQL Lab Solutions _ Study Guide _ OA Prephttps://www.stuvia.com/user/stuviaun
, WGU - D427 Data Management - Applications ZyBooks Labs
https://www.stuvia.com/user/stuviaun
8https://www.stuvia.com/user/stuviaun
2https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
WGU - D427 Data Management - Applications ZyBooks Labs 8
Study online at https://quizlet.com/_fiob6x
1. 8.1 Practice Lab 1 CREATE TABLE Member (
ID INT UNSIGNED,
The Member table will have the following columns: FirstName VAR-
ID—positive integer CHAR(100),
FirstName—variable-length string with up to 100 char- MiddleInitial CHAR(1),
acters LastName VAR-
MiddleInitial—fixed-length string with 1 character CHAR(100),
LastName—variable-length string with up to 100 char- DateOfBirth DATE,
acters AnnualPledge DECI-
DateOfBirth—date MAL(8,2) UNSIGNED
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
2. 8.2 Practice Lab 2 CREATE TABLE Movie (
Title VARCHAR(30),
The Rating table has the following columns: RatingCode VARCHAR(5),
RatingCode—variable-length string, primary key FOREIGN KEY (Rating-
RatingDescription—variable-length string Code) REFERENCES Rat-
ing(RatingCode)
The Movie table should have the following columns:
);
Title—variable-length string, maximum 30 characters
RatingCode—variable-length string, maximum 5 char-
acters
Write a SQL statement to create the Movie table. Des-
ignate the RatingCode column in the Movie table as
a foreign key to the RatingCodecolumn in the Rating
table.
1/7
https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
WGUhttps://www.stuvia.com/user/stuviaun
- D427 Data Management - Applications ZyBooks Labs 8https://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
8 _ Complete SQL 1https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
Lab Solutions _ Study Guide _ OA Prephttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
WGU D427 Data Management – Applications ZyBooks Labs 8 | Complete
SQL Lab Solutions | Study Guide | OA Prep
https://www.stuvia.com/user/stuviaun
WGU
https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
D427 Data Management – Applications ZyBooks Labs https://www.stuvia.com/user/stuviaun
8 _ Complete SQL Lab Solutions _ Study Guide _ OA Prephttps://www.stuvia.com/user/stuviaun
, WGU - D427 Data Management - Applications ZyBooks Labs
https://www.stuvia.com/user/stuviaun
8https://www.stuvia.com/user/stuviaun
2https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
WGU - D427 Data Management - Applications ZyBooks Labs 8
Study online at https://quizlet.com/_fiob6x
1. 8.1 Practice Lab 1 CREATE TABLE Member (
ID INT UNSIGNED,
The Member table will have the following columns: FirstName VAR-
ID—positive integer CHAR(100),
FirstName—variable-length string with up to 100 char- MiddleInitial CHAR(1),
acters LastName VAR-
MiddleInitial—fixed-length string with 1 character CHAR(100),
LastName—variable-length string with up to 100 char- DateOfBirth DATE,
acters AnnualPledge DECI-
DateOfBirth—date MAL(8,2) UNSIGNED
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
2. 8.2 Practice Lab 2 CREATE TABLE Movie (
Title VARCHAR(30),
The Rating table has the following columns: RatingCode VARCHAR(5),
RatingCode—variable-length string, primary key FOREIGN KEY (Rating-
RatingDescription—variable-length string Code) REFERENCES Rat-
ing(RatingCode)
The Movie table should have the following columns:
);
Title—variable-length string, maximum 30 characters
RatingCode—variable-length string, maximum 5 char-
acters
Write a SQL statement to create the Movie table. Des-
ignate the RatingCode column in the Movie table as
a foreign key to the RatingCodecolumn in the Rating
table.
1/7
https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
WGUhttps://www.stuvia.com/user/stuviaun
- D427 Data Management - Applications ZyBooks Labs 8https://www.stuvia.com/user/stuviaun
