Spring 2023 ISM218 Group Project (100 points) Online Submission through Canvas Course Site One Submission per Group Project Deadline: 04/23, 2023 11:59PM INSTRUCTION ON GROUP FORMATION 1. This project requires a group of three members 2. The group has been created in Canvas and you can find you teammates. AFTER GROUP FORMATION 1. Each group should select a business case and run through the project exercises. You can select one case from below case list or can propose a different case. 2. One case can be selected by more than one group; however, the inter-group collaboration is not allowed. 3. You can consult the instructor anytime during your project. CASES Database for a Customer Complain Management System Database for a Warehouse and Inventory Management System Database for a Social Media Website Database for a Human Resources Department Database for a Stock Trading Platform Database for a Content Streaming Website Database for a Ride-sharing App PROJECT EXERCISES Requirement and Conceptual Modelling 80 points List of requirements for the database. Be sure to include 8 to 10 entity descriptions with all required attributes and relationship with cardinality descriptions. While listing the entities, attributes, and cardinalities, try to demonstrate your understanding about different types of entities (not mandatory, use only if applicable), different types of attributes, and different types of relationships (not mandatory, use only if appropriate) 40 points Entity Relationship Diagram based on the list of requirements. The ERD should be created using ERDplus tool. 40 points Logical Modelling and Implementation 20 points Databases Schema Relationship Diagram. The schema should be created using ERDplus tool. 10 points Database Creation MySQL Statement. Be sure to appropriately modify the datatypes. I only want the codes pasted in the word document. The code should be created using ERDplus tool. I will run the code on MySQL to check accuracy. 10 points