Project Title: A database design for Customer Management in CRMS Division

You should print and submit a report that includes the E/R model for your database design together with reasonable assumption(s) you made; script to create and populate the tables (SQL), this must include a list of all relational schemas/tables and attributes within each table with appropriate data types, identify the key attributes for each table, and show the relationships among the tables. You should hand in the printout of tuples/records in each table, the script for the SQL queries and the output of the queries.

For the customer management division specified in the project, you need to deve lop the design for the users of the system to perform various operations required to serve the emp loyees, managers and owners ofthe CRMS division in the enterprise. You should use MySQL DBMS to implement the database system and show its execution by queries. Proble m State me nt: The Operation's manager decided to transform CRMS division from the file and paper process to a digital subdivision. P-1) CRMS system should maintain information about: 1. Departments 2. Employees 3. Salaries 4. Dept.- Employee 5. Dept.-Manager 6. Titles P-2) Each employee receives a call from customers who have various issues with their gadgets and an emp lo yee must record the fo llowing information regarding the Customer: 1. Name- First, Last 2. Contact Number 3. Email 4. Address City, State and ZIP code - Data should be only of Ca na da (All provinces). 5. Payment details: Credit Card, Debit or Cheque de tails. 6. Amount- Every Entry should be double. (ex. S101.23) 7. Service date: Automatically allocate today's date from system date to each customer 8. Device: Computer, Printe r-No other value You need to complete the database design, implement the database. collect appropriate data and store them into the database. Make sure each tabke in the database has sufficient number of