Creating a Conceptual EER Model and Relational Database

Conceptual Model with Software

Conceptual EER model. The model will be done using Visual Paradigm, Visio, Draw.IO orany other equivalent software. You can also make the Model using UML notation. The

models will not be accepted if made by hand

Relational Database

• Relational logical data model: convert the conceptual model to relational logical modeland make data structure diagram for the tables make sure that all the tables are in the3rd normal form. You need to state if every table that you created is in the third normalform or not. If not then you need to convert it to the third normal form

Page 2 of 6

• Develop the SQL scripts that will create the tables and enforce all the appropriateconstraints

• Develop sample SQL scripts that will insert the data to the database (one row in eachtable)

• Convert at least 2 entities to MongoDB Collections. Write the scripts that will Create thecollection(s)

• Create SQL SELECT statements that will:

1. Return all the information displayed on the Locations tab (wireframe 1)

2. Return all the information displayed on the Midtown Location tab(wireframe 1)

3. Return all the information displayed on the Coaches tab (wireframe 3)

4. Return all the information displayed on the Coach Sally tab (wireframe 4)