Your task is to design a relational database, as well as a data warehouse to support the daily operations and strategic planning of the organization. The task can be broken down into the following...

Your task is to design a relational database, as well as a data warehouse to support the daily operations and strategic planning of the organization. The task can be broken down into the following sub-tasks:

1. construct a mini-world use case based on the daily operations of the organization

2. identify key information that needs to be stored within the organization to support the daily operations, including entities and their relation- ships (ER modelling)

3. design a logical model based on the ER modeling, including keys and constraints

4. make sure the design is normalized to 3NF

5. implement the database in MYSQL Workbench using SQL table creation and modification queries