[SOLVED] Dbs211 lab 05 – ddl

The purpose of this lab is to introduce you to the DDL set of statements in SQL.  By writing SQL to create tables, constraints, and views, you will have the tools needed to implement database designs that you will create later in the course.  By finishing this lab, the student will be able to:Your submission will be a single WORD file with the solutions provided.Your submission needs to include a comment header block and be commented to include the question and the solutions. Make sure every SQL statement terminates with a semicolon.Add
SET AUTOCOMMIT ON;
under the comment header and execute itConsider the following table specifications:MOVIES (movieid:int, title:varchar(35), releaseYear:int, director:int,score:decimal(3,2))    ACTORS (actorid:int, firstname:varchar(20), lastname:varchar(30)) CASTINGS (movieid:int, actorid:int) DIRECTORS(directorid:int, firstname:varchar(20), lastname:varchar(30))  Director   Movies Part B (More DML):From Lab 03-PART2– SQL – Single Table Queries will be implemented in this lab