DBS211_Lab03_DDL_W24

DBS211 – Introduction to Database Systems Winter 2024 Part A (DDL) 1. Create the following tables and their given constraints: L5_MOVIES Column Name Column DataType PK Not Null Unique FK Default Value Validation m_id int ✓ title varchar(35) ✓ release_year int ✓ director int ✓ score decimal(3,2 ) < 5 and > 0 L5_ACTORS Column Name Column DataType PK Not Null Unique FK Default Value Validation a_id int ✓ first_name varchar(20) ✓ last_name Varchar(30) ✓ L5_CASTINGS Column Name Column DataType PK Not Null Unique FK Default Value Validation movie_id int ✓ ✓ (L5_MOVIES) actor_id int ✓ ✓ (L5_ACTORS) L5_DIRECTORS Column Name Column DataType PK Not Null Unique FK Default Value Validation director_i d int ✓ first_name varchar(20) ✓ last_name varchar(30) ✓ 2. Modify the L5_MOVIES table to create a foreign key constraint that refers to table L5_DIRECTORS . 3. Modify the L5_MOVIES table to create a new constraint so the uniqueness of the movie title is guaranteed.