Data Management Foundations D426 - Lab Answers
Data Management Foundations (Western Governors University)
Studocu is not sponsored or endorsed by any college or university
Downloaded by john gatheca ()
, lOMoARcPSD|28964921
2.13
CREATE TABLE Movie (
ID SMALLINT UNSIGNED,
Title VARCHAR(50),
Ra琀椀ng CHAR(4),
ReleaseDate DATE,
Budget DECIMAL(8,2)
);
2.14
ALTER TABLE Movie
Add Producer VARCHAR(50),
DROP Genre,
CHANGE Year ReleaseYear SMALLINT;
2.15
SELECT RegisteredName,Height,BirthDate
FROM Horse
WHERE Height>='15.0' AND Height<='16.0' OR
BirthDate>='2020-01-01';
2.16
INSERT INTO Horse (RegisteredName,Breed,Height,BirthDate) VALUES
('Babe','Quarter Horse','15.3','2015-02-10'),
('Independence','Holsteiner','16.0','2017-03-13'),
('Ellie','Saddlebred','15.0','2016-12-22'),
(NULL,'Egyp琀椀an Arab','14.9','2019-10-12');
Downloaded by john gatheca ()