Y5

The project

In this case study, your team is asked to design and implement the database component of a University's mobile application. Few wireframe screens (you will find them at the end of this document) were made during the requirements analysis of the project. Those screens will be your main source of information on the entities, attributes and relationships between them. You need to identify the business entities and attributes from the wireframes. Graphical User Interface components such as Windows, buttons, and lists are not entities. Below are the required tasks from your group:

• Conceptual Model: Model will be done using Draw.io. THE MODELS WILL NOT BE ACCEPTED IF MADE BY HAND.
• Relational Database: Convert the conceptual model to a relational logical model and make a data structure diagram for the tables ensuring that all the tables are in the 3^rd normal form. You need to state whether every table you created is in the third normal form. If not, then you need to convert it to the third normal form.
• Develop the SQL scripts that will create the tables and enforce all the appropriate constraints.
• Develop sample SQL scripts that will insert the data to the database (one row in each table).
• Convert at least 2 entities to MongoDB Collections. Write the scripts that will Create the collection(s).
• Create SQL SELECT statements that will:

1. Return all the information displayed on the Home tab (wireframe 1)
2. Return all the information displayed on the Classes tab (wireframe 2)
3. Return all the information displayed on the Messages tab (wireframe 3)

Also, Create the tables of the entities identified in above deliverable in table. Insert at least 5 data points (rows) for each table. Submit the creation scripts (code) as well as the outputs in the word format of the following select statements:

1. Return all the information displayed on the Home tab (wireframe 1)
2. Return all the information displayed on the Classes tab (wireframe 2)
3. Return all the information displayed on the Messages tab (wireframe 3