DATABASE

Blockbuster is making a comeback and needs to you create an ER Diagram for them. The company is made up of stores, each store has a unique store number. It also has information about its address, which is made up of city, state and zip. The stores have movies they can rent. The movies contain a unique movie title. It also has a year it was made and the studio who made it. It will also contain all the actors. (You can model actors as an attribute instead of its own entity). Each store can have multiple movies on its shelves. Customers are unique by name. Each customer can only have one home store, but they can rent as many movies as they like. When a movie is rented the return date should be provided. A customer can rent as many movies as they like. Model the return date as an attribute of the relationship. Customers doesn't exist if they do not have a home store