Thank you SHOP Shop ID SA Shop name Street PRICE CHANGE City

SHOP Shop ID (SA) Shop name Street PRICE CHANGE City Film Genre code State Date zip code Previuos price Manager FILM GEN Film Genre code Description Rental price IDE MASTER RENTAL Video Nurmbre (SA) Rental Folio (SA) Batch Number stomer Num. Title Employee Num. Date Received Rental Date Distributor Code Film Genre Code Shop Code DETAIL RENTAL Rental Folio Video Number Rental Price CUSTOMER Customer ID Name Last Name Street City State Zip code Telephone Credit Card Card Number EMPLOYEE K Employee ID (SA) Name Last N TIN Street City State Zip Code elephone Entry Date Shop code DISTRIBUTOR Distributor Code Distributor Name

Solution

Yes.. Video entity is in #rd normal form.

Above entities are well categorized in the form attributes.and each non key attribute is transitively dependent on the primary key.

example:

Distributor code(video table) transitively dependent on the Distributor Code (DISTRIBUTOR table)

Film Genere Code(Video table) transitively dependent on the Film Genere Code(FILM GENERtable)

Shop code (Video table) transitively dependent on the Shop ID (Shop table)

3nf helps in achieving data integrity as it doesnt allow duplicates