[ slide-15 .png ] Q1. Please write SQL codes to create below member database table based on the previous slide (slide 15) Video E-R Modeling Diagram. child table parent table RENTAL MEMBER 1. The...

[   slide-15 .png  ]

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

          child table                                                         parent table

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

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

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

DESC MEMBER

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.