WGU - D427 Data Management - Applications ZyBooks Labs 7 and 8

Western Governors University D 322


WGU - D427 Data Management - Applications ZyBooks
Labs 7 and 8



Students also studied




C




Terms in this set (27)



7.1 LAB - Alter Movie table ALTER TABLE Movie
ADD Producer VARCHAR(50);
The Movie table has the following
columns: ALTER TABLE Movie
ID - positive integer DROP Genre;
Title - variable-length string
Genre - variable-length string
RatingCode - variable-length string
Year - integer
Write ALTER statements to make the
following modifications to the Movie table:
1. Add a Producer column with
VARCHAR data type (max 50 chars).
2.Remove the Genre column.
3.Change the Year column's name to ALTER TABLE Movie
ReleaseYear, and change the data type to CHANGE Year ReleaseYear
SMALLINT;
SMALLINT.

, 7.2 LAB - Insert rows into Horse table INSERT INTO Horse (RegisteredName, Breed, Height,
BirthDate)
The Horse table has the following columns: VALUES ('Babe', 'Quarter Horse', 15.3, '2015-02-10');
ID - integer, auto increment, primary key
RegisteredName - variable-length string INSERT INTO Horse (RegisteredName, Breed, Height,
Breed - variable-length string, must be one BirthDate)
of the following: Egyptian Arab, Holsteiner, VALUES ('Independence', 'Holsteiner', 16.0, '2017-03-13');
Quarter Horse, Paint, Saddlebred
Height - decimal number, must be between INSERT INTO Horse (RegisteredName, Breed, Height,
10.0 and 20.0 BirthDate)
BirthDate - date, must be on or after Jan 1, VALUES ('Ellie', 'Saddlebred', 15.0, '2016-12-22');
2015
INSERT INTO Horse (Breed, Height, BirthDate) VALUES
Insert the following data into the Horse ('Egyptian Arab', 14.9, '2019-10-12');
table:
RegisteredName Breed Height



7.3 LAB - Update rows in Horse table UPDATE Horse
SET Height = 15.6
The Horse table has the following columns: WHERE ID = 2;
ID - integer, auto increment, primary key
RegisteredName - variable-length string UPDATE Horse
Breed - variable-length string, must be one SET RegisteredName = 'Lady Luck',
of the following: Egyptian Arab, Holsteiner, BirthDate = '2015-05-01'
Quarter Horse, Paint, Saddlebred WHERE ID = 4;
Height - decimal number, must be ≥ 10.0 and
≤ 20.0 UPDATE Horse
BirthDate - date, must be ≥ Jan 1, 2015 SET Breed = NULL
WHERE BirthDate >= '2016-12-22';
Make the following updates:
1.- Change the height to 15.6 for horse with
ID 2.
2.- Change the registered name to Lady



7.4 LAB - Delete rows from Horse table DELETE FROM Horse
WHERE ID = 5;
The Horse table has the following columns:
ID - integer, auto increment, primary key DELETE FROM Horse
RegisteredName - variable-length string WHERE Breed IN ('Holsteiner' , 'Paint');
Breed - variable-length string
Height - decimal number DELETE FROM Horse
BirthDate - date WHERE BirthDate < '2013-03-13';


Delete the following rows:
1.- Horse with ID 5.
2.- All horses with breed Holsteiner or
Paint. 3.- All horses born before March
13, 2013.