#Customer rental movie er diagram movie
It is to be noted that every Movie Item entity has a unique ID. This ban is a temporary ban and can be changed by admin as situation changes. For example, a customer may be banned for not returning Movie Items for an extended period of time or situations may arise when the shop no longer wants to service a particular customer. A customer can be banned by an admin depending on the situation. Each customer can only rent Movie Items if he/she hasn't exceeded the quota allocated and if he/she is not banned. Normal customers do not have the privilege of doing this and can only rent from what's available in the store at the current time. That is, even if the Movie Item is not available at the store, the customer can request to reserve that Movie Item for him/her whenever a copy is returned. Another privilege to premium customers is that they can "request" up to 4 Movie Items. The difference between the two kinds is that normal customers get to rent up to 2 Movie Items using their account, whereas premium customers get to rent up to 4 Movie Items. All customers have to be only one of the two types. There are two kinds of customers: normal and premium. We may have one or more phone numbers for every user. Some important ones are security features like password for authentication and ID verification question and answers. For each user, we maintain several descriptive attributes. A person can be both administrator and customer. The customer can only borrow DVDs/Blu-Rays (hereby referred to as Movie Items) from the shop. The administrators manage the database and have authority to modify the database. All users have a unique ID to identify them. Transcribed image text: The rental shop has users who can either be administrators (Admin) or customers.