Phase II: Logical and physical database design You need to follow the steps listed below. Step 1: Map ER diagram you designed in Part I to Table Instance Chart (Process of Relational Data modeling), Step 2: Populate some sample data into the tables to include the cardinality and participation properties of relationships between any two entities, Step 3: Perform 1 st, 2nd, 3rd, and Boyce-Codd normalizations for the tables generating from Step 1 to identify any missing entity (entities), Step 4: Revise your ER diagram from part I to include the missing entity (entities) in it. You need turn in the all the deliverables listed above along with the original ERD from Phase I.

The following is the Requirement statements for a video store: I am the owner of a small video store. We have over 3,000 video tapes that we need to keep track of. Each of our video tapes has a tape number. For each movie, we need to know its title and category (e.g. comedy, suspense, drama, action, war, or sci-fi). Yes, we do have multiple copies of many of movies. We give each movie a specific id, and then track which movie a tape contains. A tape may be either Beta or VHS format. We always have at least one tape for each movie we track, and each tape is always a copy of a single, specific movie. Our tapes are very long, and we dont have any movies which require multiple tapes. We are frequently asked for movies starring specific actors. John Wayne and Katherine Hepburn are always popular. So wed like to keep track of the star actors appearing in each movie. Not all of our movies have star actors. Customers like to know each actors real birth name and date of birth. We track only actors who appear in the movies in our inventory. We have lots of customers. We only rent videos to people who have joined our video club. To belong to our club, they must have good credit. For each club member, wed like to keep their first and last name, current phone number, and current address. And, of course each club member has a membership number. Then we need to keep track of what video tapes each customer currently has checked out. A customer may check out multiple video tapes at any given time. You know we really need to keep a history of all our rentals. Each time a customer rents a tape, we would like to keep the rental date/time and return date/time. All our tapes are due back the next day, so we dont need to keep a due date. Keeping this rental history will allow us to analyze the pattern of our rentals. We will be able to determine how many tapes each customer rents and how many times a customer has returned a tape late. We will also know how many times a particular tape has been used, and will then know when to retire each tape. We will also be able to analyze our customers movie preferences.