DBAS27198 - Database Design and Implementation - IT Assignment Help

Assignment Task -             

Objective 

The objective of the case study is to reinforce the concepts learned in the course through engaging in a database design process from the development of business rules to the implementation. 

The project 

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

• Conceptual EER model. The model will be done using Visual Paradigm, Visio, Draw.IO or any 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 model and make data structure diagram for the tables make sure that all the tables are in the 3rd normal form.  You need to state if every table that you created is in the third normal form or not. 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 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

This DBAS27198 - IT Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.