You are a database designer assigned to design a database for a video rental store. Please list 5 relevant entities to be used in your design. For each of the 5 entities please list at least 5 attributes. For each of the 5 entities please list the primary key. For each of the 5 entities create a table with attributes as its columns. Create 3 records (rows) with data items in the attribute columns.This is an exercise in how well you can do research and grasp new concepts. Please use the course materials and internet to do research on these database terms and concepts in order to complete the assignment. Search on key terms such as entity relationship diagram, what is an ERD, database entity, attribute, etc.EXAMPLE IS ATTACHED SINCE IT DID NOT COPY WELLEntity XAttributes: Number, Name, Color, Count, MonthPrimary Key: NumberNumberNameColorCountMonth1AGreen3January2BRed2March3CBlue4AugustEXAMPLE IS ATTACHED SINCE IT DID NOT COPY WELL
