QUESTION:

1. Write the relational schema and draw its dependency diagram. Identify all dependencies, including all transitive dependencies.

2. Write the relational schema and draw the dependency diagram to meet the 3NF requirements to the greatest practical extent possible. NORMALIZE IT TO 3NF

TABLE NAME ATTRIBUTE NAME CONTENTS unique customer ID member or not membership number date of membership First name of customer Last name of customer Customer's address FORMAT REQUIRED PK VARCHAR(2) membership_number date became member customer first name customer last name VARCHAR(32 XXXXXXXXXXXxxXXXXXXX VARCHAR(32) XXXXXxxXXXXxXxXXXxxx VARCHAR(128) customer's email VARCHAR(128)XXXXXXXXXXXXXXXXXXXX Cutomer's birth date Customer Rentals 195 FK FK rental status code rental date out rental date returned rental amount_due transaction id rental status code rental date out rental date returned rental amount due Financial Transactions FK previous transaction ID transaction type code FK transaction date transaction amount transaction amount transaction comment VARCHAR(512XXXxxxxxxXxxxxxxXxxx FK unique customer ID payment method code payment_method_code account name VARCHAR(32 XXXXXxxxXxxxxxXXxxxx VARCHAR(512) XXXxxxxXxxxxxxxxxxxx Payment_Methodspayment method code payment method_descirption payment method description VARCHAR(32)XXXxXXXxxxxXXxxxxXXX transaction type descriptiontransction type description VARCHAR(32)Xxxxxxxxxxxxx Rental_Status Codes rental status _code rental _status_ description rental staus description VARCHAR(32) xXXX actor first_name First name of actor Last name of actor other actor details movie identity VARCHAR(32) XXxxxxxXXxxxxxXxxxxx VARCHAR(32) other actor details VARCHAR(512)XXxxxxxxxxxxxxxxXxxx actor description format type code format type description VARCHAR(32) XXXxxxxxxXXxXxxXXXXx Format Types format type_description condition_description condition description ARCHAR(32) Video Stores store name store email other store details xXXX store email other store details VARCHAR(512XXxxxxxxxxxxxxxxxxx TABLE NAME ATTRIBUTE NAME CONTENTS unique customer ID member or not membership number date of membership First name of customer Last name of customer Customer's address FORMAT REQUIRED PK VARCHAR(2) membership_number date became member customer first name customer last name VARCHAR(32 XXXXXXXXXXXxxXXXXXXX VARCHAR(32) XXXXXxxXXXXxXxXXXxxx VARCHAR(128) customer's email VARCHAR(128)XXXXXXXXXXXXXXXXXXXX Cutomer's birth date Customer Rentals 195 FK FK rental status code rental date out rental date returned rental amount_due transaction id rental status code rental date out rental date returned rental amount due Financial Transactions FK previous transaction ID transaction type code FK transaction date transaction amount transaction amount transaction comment VARCHAR(512XXXxxxxxxXxxxxxxXxxx FK unique customer ID payment method code payment_method_code account name VARCHAR(32 XXXXXxxxXxxxxxXXxxxx VARCHAR(512) XXXxxxxXxxxxxxxxxxxx Payment_Methodspayment method code payment method_descirption payment method description VARCHAR(32)XXXxXXXxxxxXXxxxxXXX transaction type descriptiontransction type description VARCHAR(32)Xxxxxxxxxxxxx Rental_Status Codes rental status _code rental _status_ description rental staus description VARCHAR(32) xXXX actor first_name First name of actor Last name of actor other actor details movie identity VARCHAR(32) XXxxxxxXXxxxxxXxxxxx VARCHAR(32) other actor details VARCHAR(512)XXxxxxxxxxxxxxxxXxxx actor description format type code format type description VARCHAR(32) XXXxxxxxxXXxXxxXXXXx Format Types format type_description condition_description condition description ARCHAR(32) Video Stores store name store email other store details xXXX store email other store details VARCHAR(512XXxxxxxxxxxxxxxxxxx