Database Design and Implementation For A Fitness Center - Case Study - 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)

Instructions 

• All the deliverables will be delivered as one report in Microsoft word format to the Slate Drop Box 

• The report should be professionally formatted and it should include a cover page that includes the name of the report and the group members, page number in the footer of each place, etc. 

• All the group members will abide to the rules of the group contract 

• The diagrams must be done using Draw.io or Visual Paradigm or any equivalent software. Hand-drawn sketches will not be accepted. 

• The wireframes should give you enough information on the needed entity types, attributes, and their relation. You can make any assumptions as needed; however, you need to state those assumptions in the EER diagram. 

• You will work in groups of a maximum of 4 students. 

• The Case Study has 8 deliverables, you need to consult with each other and agree to assign a deliverable lead to each of the deliverables. Each of you will be a lead of two or three deliverables. The deliverable lead is responsible for coordinating the work on the deliverable with the other team members. Additionally, the deliverable lead is ultimately responsible for the quality and the submission of the deliverable. If I receive a complaint from a group that the deliverable lead is falling short on coordinating and\or delivering his\her deliverable, I reserve the right to interview the group and to give the other members of the group bonus for their ideas on how to improve the deliverable.

This 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.