The project involves designing a complete database management system and implementing a relational database based on your design. Your database system should be designed to perform general information management tasks such as systematic collection, update, and retrieval of information for a small organization. Students should work in a group of two or three. The number of tables in your project should be at least double of your members. For example, if your team has two group members, your project should have at least four tables; if your team has three members, you should design at least six tables. Milestone 1: Initial Phase The starting point of your project is to identify a database need of a real or hypothetical client, and explore questions such as: - What is the purpose of the database? Why is it needed? What should it do? - Who are the users and what are their information needs? - What are the problems that the system should solve? - What kind of information should be stored in the database? - Design E-R data model for your project. Finish your logical level database design. Your design is converting E-R data model to database design so make sure you follow the steps and identify all weak entities, strong entities, subtypes, any 1:1, 1:n, and n:m relations. Finish normalization if necessary. Please submit the following items: 1. Draw the EER diagram using MySQL for your database. Please check all tables and tables, and choose the right Crow's foot annotation for them. 2. Provide the description of your tables and relationships. 3. List Database Column Specifications for all tables. 4. List Referential Integrity Constraint Enforcement for the design. Deliverable You must submit the four items listed above to Blackboard on time. You should attend the in-class report meeting. Milestone 3: Actual Implementation Implement your tables in MySQL DB. You must have tables and views defined. You must implement at least one query for each user. You must also have - At least one insert - At least one update - At least one delete Deliverable You should submit your implementation (MySQL code) with a document describing the tables, views, queries you implemented, and attend the in-class report meeting. This submission focuses on your business scenario with various queries and analysis. For each of the team member, based on your business, you need to finish the following queries: 1. One query with subquery 2. One query with join 3. One query with built-in functions (such as, min, max, count) 4. One query with GroupBy 5. One query with the filter functions (such as, with the number range or text pattern) 6. One query with multiple condition combination. When you design the above queries, you must think about your queries: - If the query is meaningful for the end user. - If the query is useful for the end user. - How to interpret your results. Deliverablessub You must submit the whole project with the project (MySQL) and a report about the assessment of your project. You must attend the final presentation to report the whole project, including the following items: - Title: you must write your desired title for your project. Example: Sales and Inventory System - System Description (Max 3 sentences) - Data Dictionaries For Data Dictionaries, you have to write the descriptive details of each field in every table. (see example tables below) - Entity Relationship Diagram