Information System Design & Management

Think about how your local video rental store works. There are many customers renting many videos, and many videos sit on the shelves unrented. Customers can rent many videos at one time. Some videos are so popular that the video rental store keeps many copies. Create a document that shows the various business rules that define how a video rental store works with respect to entity classes and their relationships. Now, draw the initial E-R diagram based on the rules you defined. Don’t worry about going through the normalization process at this point. Identify the appropriate relationships among the entity classes and define the minimum and maximum cardinality of each relationship.(Minimum 2 pages, double-spaced).