数据库ER图设计 电影碟片租赁管理系统

材料

I’m the owner of a small video rental store. We have over 3,000 movies that we need to keep track of. Each of our movies has a DVD or VHS 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 our movies. We give each movie a specific ID, and then track which DVD or VHS contains the movie. A movie can be either DVD or VHS format. 

We always have at least one DVD or VHS tape for each movie we track, and each DVD or VHS tape is always a copy of a single, specific movie. 

Our DVDs and VHS tapes are very long. We don’t have any movies that require multiple DVDs or VHS tapes. 

We are frequently asked for movies starring specific actors. Mel Gibson and Julia Roberts 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. Cust