Part 1. Designing a Database (Due: Week 5) - Worth 10% of Final Grade You will be required to develop a logical database design in Access that contains a minimum of 5 tables. Using the Database Relationship View, all tables must be interconnected by the appropriate 1 to many relationships. Standalone tables or tables with 1 to 1 relationships should not be incorporated into your design (please check with your professor if you feel that an exception is valid) Tables in your database must be given understandable names and descriptions. Variables (or columns) in the tables must be defined across a range of data types including; text, date, number. You must use a MINIMUM of 4 different field data types in your design. Each table must have a primary key (or composite primary key) defined. At this stage of the deliverable, you are not required to populate your tables with data. You are just required to define all the tables, fields, and relationships, and include full descriptions of them in your Table Design View. You will be required to submit 2 files. The first file will be the finalized Solution Proposal Document. This document must contain any changes or updates to your solution proposal that was delivered previously. If there were no modifications to your topic proposal, you still MUST submit it with your ERD design so they can be reviewed and graded together. The second file will be the Access file containing the database logical design