Business Use Case

You have been hired to design a database for a movie rental system. The system needs to

keep track of its customers, the movies available for rent, and the rental transactions.

Your task is to create a minimum of three tables based on this use case. The focus of this

lab is to ensure the correct data types are used, columns are properly defined as nullable

or not nullable, foreign keys are set up correctly, and each table should have at least two

lines of dummy data.

Instructions

$1.$ Database Name : Create the database with the name Lab$3\_$YourName $($replace

YourName with your actual name$).$

$2.$ Define the tables: You need to create three tables: Customer, Movie, and Rental.

$3.$ Choose the right data types: Ensure that you select appropriate data types for

each column.

$4.$ Set NULL or NOT NULL constraints: Determine which columns can be null and

which cannot.

$5.$ Establish relationships: Set up foreign key relationships between the tables.

$6.$ Insert dummy data: Populate each table with at least two rows of data.