Database design and Entity Relationship Diagrams:
Please read the flollowing new business requirements and resolve the M:M (many-to-many) relationship. Identify UIDs for all the entities that require multiple DVDs.
"I'm the owner of a small video store. We have over 3,000 DVDs that we need to keep track of.
"Each of our DVDs has a disk 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 our movies. We give each movie a specific ID, and then we track which movie a disk contains. A disk may be either High Definition (HD) or BlueRay format. We always have at least one disk for each movie we track, and each disk is always a copy of a single, specific movie. Our disks are very big, although we don't have any movies that require multiple disks."
"We are frequently asked for movies starring specific actors. John Wayne and Katherine Hepburn are always popular. So we'd 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 actor's "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 DVDs to people who have joined our DVD club. To belong to our club, they must have good credit. For each club member, we'd like to keep the 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 DVDs each customer currently has checked out. A customer may check out multiple DVDs at any given time. We just track current rentals. We don't keep track of any rental histories."