[ sliede-5.png ] Q1. Please write SQL codes to create below dvd database table based on the previous slide (slide 15) Video E-R Modling Diagram child table parent table RENTAL DVD 1. The rental table...

[ sliede-5.png ]

Q1. Please write SQL codes to create below dvd database table based on the previous slide (slide 15) Video E-R Modling Diagram

child table                                                   parent table

1. The rental table is a child table, and the dvd table is a parent table.

2. We need to create dvd parent table first before creating rental child table.

3. The dvd_ID column is the primary key column, and rest columns are NOT NULL constraints.

DESC dvd

Extracted text: RENTAL МЕMBER DVD Each rental must be related to one and only one member. Each member may have one or many rentals. Each rental must be related to one and only one dvd. w Each dvd may be related to one or many rentals.