## Submission Instructions1. **Include your table creation SQL statements** - You can copy and paste your code here.2. **Include the screenshots** - Take a screenshot of your tables in your database (DB). **Transcription for Educational Website****Objective: Create Tables from Given Data****Tables Overview:**1. **Customer Table** | CID | CNAME | CITY | |-----|-------|--------| | C1 | Smith | London | | C2 | Jones | Paris | | C4 | Clark | London | | C5 | Adams | Athens |2. **Rent Table** | CID | FID | RDATE | |-----|-----|------------| | C5 | F2 | 02-OCT-14 | | C5 | F3 | 04-SEP-14 | | C5 | F5 | 16-APR-17 | | C1 | F5 | 16-APR-17 | | C1 | F2 | 02-OCT-14 | | C1 | F3 | 04-SEP-14 | | C2 | F2 | 01-APR-14 | | C4 | F2 | 01-JAN-14 |3. **Film Table** | FID | FNAME | PRICE | TYPE | |-----|------------|-------|--------| | F2 | The Others | 1.44 | HORROR | | F3 | Senseless | 5.99 | COMEDY | | F4 | Dragon Heart | 6 | DRAMA | | F5 | 007 | 5 | ACTION | | F7 | Sweetheart | 5 | COMEDY |**Steps:**1. **Create three tables:** - Customer - Rent - Film2. **Define appropriate data type and data size.**3. **Define column constraints.**4. **Specify Integrity/Domain/Primary Key/Referential Integrity Constraints:** - **Primary Key** - **Foreign Key** - Example: `CONSTRAINT rent_fk_c FOREIGN KEY cid REFERENCES customer ON DELETE CASCADE` - **Constraints:** - The price of a film ranges from 0.50 to 19.99. - A film can only have the type

Customer Table:The "Customer" table represents information about customers who rent films. It includes the customer's unique identifier (CID), their name (CNAME), and the city (CITY) they are located in. The CID is the primary key, ensuring that each customer has a unique identifier. The CNAME column stores customer names, and the CITY column holds their respective cities.Rent Table:The "Rent" table is used to track rental transactions. It records which customer (CID) rented which film (FID) on a specific date (RDATE). The primary key for this table consists of the combination of CID, FID, and RDATE, ensuring each rental record is unique. Two foreign key constraints (rent_fk_cid and rent_fk_fid) link this table to the Customer and Film tables, respectively. These constraints enforce referential integrity and allow cascading deletes when customer or film records are removed.Film Table:The "Film" table contains information about available films for rent. It includes the film's unique identifier (FID), title (FNAME), price (PRICE), and genre type (TYPE). The FID is the primary key, ensuring each film has a unique identifier. The PRICE column uses a check constraint to limit the film price to the range between 0.50 and 19.99. The TYPE column also employs a check constraint to restrict film genres to 'Action', 'Horror', 'Comedy', 'Drama', and 'Education'.These tables and constraints provide a structured and organized way to manage customer information, rental transactions, and film details while maintaining data integrity and enforcing certain constraints.Here are the SQL CREATE TABLE statements for the three tables (Customer, Rent, and Film) with appropriate data types, data sizes, and constraints:a. Customer table:1CREATE TABLE Customer ( 2 CID CHAR(2) PRIMARY KEY, 3 CNAME VARCHAR(50) NOT NULL, 4 CITY VARCHAR(50) 5);In this table:CID is the primary key with a data type of CHAR(2).CNAME is a VARCHAR(50) column, which is not nullable.CITY is a VARCHAR(50) column. b. Rent table:1CREATE TABLE Rent ( 2 CID CHAR(2), 3 FID CHAR(2), 4 RDATE DATE, 5 CONSTRAINT rent_pk PRIMARY KEY (CID, FID, RDATE), 6 CONSTRAINT rent_fk_cid FOREIGN KEY (CID) REFERENCES Customer (CID) ON DELETE CASCADE, 7 CONSTRAINT rent_fk_fid FOREIGN KEY (FID) REFERENCES Film (FID) ON DELETE CASCADE 8);In this table:CID and FID together form the primary key.RDATE is a DATE column.There are two foreign key constraints:rent_fk_cid references the CID column of the Customer table with ON DELETE CASCADE.rent_fk_fid references the FID column of the Film table with ON DELETE CASCADE.c. Film table:1CREATE TABLE Film ( 2 FID CHAR(2) PRIMARY KEY, 3 FNAME VARCHAR(50) NOT NULL, 4 PRICE DECIMAL(5, 2) CHECK (PRICE BETWEEN 0.50 AND 19.99), 5 TYPE VARCHAR(50) CHECK (TYPE IN ('Action', 'Horror', 'Comedy', 'Drama', 'Education')) 6);In this table:FID is the primary key with a data type of CHAR(2).FNAME is a VARCHAR(50) column, which is not nullable.PRICE is a DECIMAL(5, 2) column with a check constraint to ensure it falls within the specified range (0.50 to 19.99).TYPE is a VARCHAR(50) column with a check constraint to restrict values to only 'Action', 'Horror', 'Comedy', 'Drama', and 'Education'.These SQL statements written in the steps above define the tables and constraints as per the requirements of the question. Kindly refer to the steps above.

Engineering

Data Structures and Algorithms

1. Create three tables a. Customer b. Rent c. Film 2. Define appropriate data type and data size 3. Define column constraints 4. Specify Integrity/Domain/Primary Key/Referential Integrity constraints a. Primary key b. Foreign key E.g.) CONSTRAINT rent_fk_c FOREIGN KEY cid REFERENCES customer ON DELETE CASCADE The price of a film ranges from 0 F0 to 10.00

1. Create three tables a. Customer b. Rent c. Film 2. Define appropriate data type and data size 3. Define column constraints 4. Specify Integrity/Domain/Primary Key/Referential Integrity constraints a. Primary key b. Foreign key E.g.) CONSTRAINT rent_fk_c FOREIGN KEY cid REFERENCES customer ON DELETE CASCADE The price of a film ranges from 0 F0 to 10.00