Translate the conceptual schema for Continental Palms DVD (CPD) into a logical schema. Make sure all tables are in 3NF. Specify all the integrity constraints.

Example: TableName (Column1, Column2, Column3, Column4, )

Primary Key {Column1}

Foreign Key {Column1}

Foreign Key {Column1}

Constraint: A column1 has a value between one to three.

2. CPD also hired another consulting group to design the database. In their design, there is the following big table:

DVD (catalogNo, copyNo, title, category, dailyRent, condition, branchNo, street, city, state, zip, actorDirectorStageName, actorDirectorName, actorDirectorGender, role)

From the requirements, we have identified the following functional dependencies:

catalogNo title, category, dailyRent

catalogNo, copyNo condition, branchNo

branchNo street, city, state, zip

actorDirectorStageName actorDirectorName, actorDirectorGender

catalogNo, actorDirectorStageName role

Now you need to help them do the following:

Give examples of data redundancies and data anomalies in their big table.

Determine the primary key of their big table.

Determine what normal form their big table is in.

Rescue their design by normalizing their big table into multiple 3NF tables. Rename some of the attributes when appropriate. Indicate the primary key of each table. Specify all the foreign keys.