Wgu - D427 Data Management - Applications Zybooks Labs 7 And 8 Study Guide Rated A+

8.7 Practice Lab 7 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 The YearStats table has the following columns: Year—integer TotalGross—bigint unsigned Releases—integer Write a SQL statement to designate the Year column in the Movie table as a foreign key to the Year column in the YearStats table. {Ans: ALTER TABLE Movie ADD CONSTRAINT Year FOREIGN KEY (Year) REFERENCES YearStats (Year) ;}8.6 Practice Lab 6 The Movie table has the following columns: ID—integer Title—variable-length string Genre—variable-length string RatingCode—variable-length string Year—integer Write a SQL statement to modify the Movie table to make the ID column the primary key. {Ans: ALTER TABLE Movie ADD PRIMARY KEY (ID) ;}8.11 Practice Lab 11 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 Write a SQL statement to update the Year value to be 2022 for all movies with a Year value of 2020. {Ans: UPDATE Movie SET Year = 2022 WHERE Year = 2020 ;}7.4 LAB - Delete rows from Horse table The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string