Small homework database system viso

All you have to do is requirement 4 & 5!!! 1. Using Visio or any other drawing software, draw the **ERD** (entities, relationships and cardinalities) of the database used to support the operations of the business described in the case. You are **required** to use the Crow's foot notation. 1. Draw the **Logical Data Model** in Visio or other drawing tool showing all the related attributes, the relationships between entities, and their cardinality (Use Crow's foot notation). * In each entity, underline the primary keys and highlight the foreign keys; 1. **Create** the data dictionary for your complete data model and fill in the dictionary information for **one primary key**, **one foreign key**, and **two fields** that are **not** keys. ## Deliverables 1. **Draw the **Logical Data Model** in Visio or other drawing tool showing all the related attributes, the relationships between entities, and their cardinality (Use Crow's foot notation).** * In each entity, underline the primary keys and highlight the foreign keys; 1. **Create** the data dictionary for your complete data model and fill in the dictionary information for **one primary key**, **one foreign key**, and **two fields** that are **not** keys. ** ** ** ** ** ** **Business Case: Video Club** ** ** Members rent movies from the videoclub. To do so, they need their member id card. The videoclub holds numerous movies which are identified by a bar code. The videoclub has only one copy of movies that are not often rented but holds many copies of movies in high demands. At any time, a member can rent up to 5 movies. The member is required to bring back rented movies within 5 days of the borrowing date. Because the videoclub is opened 7 days a week from 7:00 am to 11:00 pm, there are many clerks who work at the circulation desk. Every time a member wants to rent a movie, he/she needs to find the movie on the shelves, bring it to the circulation desk where the clerk will scan the movie id and the member id card. The clerk gives the movie and the member id card to the client along with a receipt indicating the details of the transaction as well as the return date.