Database Design and Implementation for a Fitness Center

Database Design and Implementation for a Fitness Center

Note: – Case Study will be evaluated on group work:-

          Group Work – 20 Marks

Detail about possible points and weightage for Group Work is given below.

Objective

The objective of the case study is to reinforce the concepts learnt 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 ER 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)

Deliverables

DeliverableDelivery DatePossible PointsWeightage
1Conceptual ModelER DiagramWeek 920      20 (Group Work)
2RelationalNormalizationWeek 1010
3 Create tablesWeek 1010
4 Insert rowsWeek 1010
5NoSLQConvert entities to MongoDB collectionWeek 1110
6Select statements Week 1120
Total possible points8020

Instructions

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

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

·       The diagrams must be done using 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 on groups of 3-5 students.

·       The case Study has 6 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

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

Appendix: Wireframes

Order Now

Get expert help for Database Design and Implementation for a Fitness Center and many more. 24X7 help, plag free solution. Order online now!

Universal Assignment (February 16, 2026) Database Design and Implementation for a Fitness Center. Retrieved from https://universalassignment.com/database-design-and-implementation-for-a-fitness-center/.
"Database Design and Implementation for a Fitness Center." Universal Assignment - February 16, 2026, https://universalassignment.com/database-design-and-implementation-for-a-fitness-center/
Universal Assignment July 23, 2022 Database Design and Implementation for a Fitness Center., viewed February 16, 2026,<https://universalassignment.com/database-design-and-implementation-for-a-fitness-center/>
Universal Assignment - Database Design and Implementation for a Fitness Center. [Internet]. [Accessed February 16, 2026]. Available from: https://universalassignment.com/database-design-and-implementation-for-a-fitness-center/
"Database Design and Implementation for a Fitness Center." Universal Assignment - Accessed February 16, 2026. https://universalassignment.com/database-design-and-implementation-for-a-fitness-center/
"Database Design and Implementation for a Fitness Center." Universal Assignment [Online]. Available: https://universalassignment.com/database-design-and-implementation-for-a-fitness-center/. [Accessed: February 16, 2026]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as $10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

Popular Assignments

Assignment SHSM024 RESEARCH DESIGN & DATA REPORT

ANSWER FORM ETHICS: (approx. 300 words in total) 10 OBTAINING CONSENT: Describe the process that the researchers would have to implement to obtain consent for a pregnant woman to participate in the study. OBTAINING ETHICAL APPROVAL: Describe two other areas of the study procedures (not including ‘obtaining consent’) that a

Read More »

Assignment Brief Sheet

Assignment Brief Sheet1Module Tutor:Dr Dennis PeppleModule NameStudy Skills and Personal Development PlanningModule CodeCBU401Title of Coursework:Assessment 1: Written Assignment (1500 words)Weight: 50%Title of Coursework:Assessment 2: Reflective (PDP) Report (1500 words)Weight: 50%Feedback detailsThe university policy is that you will receive prompt feedback on your work within 2 weeks of the submission date.

Read More »

Assignment Faculty of Business, Computing and Digital Industries

Module Handbook Faculty of Business, Computing and Digital Industries School of Business (On-campus) E-Business and E-Marketing Module. 2025-26 Contents Module Introduction Module Leader Welcome Hello A very warm welcome to the E-Business and E-Marketing module. I hope that you find this Module Handbook helpful in supporting your studies and that

Read More »

Assignment Brief BMM6422: Business and Management Strategies

Assignment Brief BMM6422: Business and Management StrategiesComponent numberAssignment 1Assignment typeReportLearning outcomes for this assessment(Please see module Handbook for all learning outcomes)Upon completion of this module students should be able to:1 Evaluate the benefits to organisations of strategic planning within the business environment.2 Employ specific techniques, methods and models used in

Read More »

ASSIGNMENT Business and Management Strategy

Module Handbook Faculty of Business, Computing and Digital Industries School of Business (On-campus) Business and Management Strategy BMM6422 2025-26 Contents Module Introduction Module Leader Welcome Welcome to Business and Management Strategy Hello I hope that you find this Module Handbook helpful in supporting your studies and that it provides you

Read More »

BMM6302 Entrepreneurship and Creativity 

Assignment Brief – Cohort 06 BMM6302 Entrepreneurship and Creativity  Component number Assignment 2 Assignment type 02 Dragon’s Den Presentation (Live Presentation) Learning outcomes for this assessment (Please see module Handbook for all learning outcomes) Compare and contrast a variety of strategic models to develop and critically evaluate business start-up ideas.

Read More »

BMM6302 Entrepreneurship and Creativity 

Assignment Brief – Cohort 07 BMM6302 Entrepreneurship and Creativity  Component number Assignment 1 Assignment type 01 Business Idea (Video Presentation – Panopto) Learning outcomes for this assessment (Please see module Handbook for all learning outcomes) Compare and contrast a variety of strategic models to develop and critically evaluate business start-up

Read More »

LCRM301 Researching Criminology

LCRM301 Researching CriminologyTopic: Introduction to theoryand the research processand undertaking acriminological literaturereviewAcknowledgement ofcountryPART ONE: Preparingcriminological research(Weeks 1-5)In the first part of the unit, we focus on preparing criminologicalresearch and decision-making processes. This includes deciding onthe topic you want to focus on, the kinds of methods to use and thetypes of

Read More »

LCRM301 Researching criminology

LCRM301 Researching criminologyWorksheet 1This worksheet will be disseminated to students in Week 3 and will assist them in the planning and development of the second assessment task: literature review. PART 1: Refining your topicThe topic I am interested in is: I am interested in this topic because: This is an

Read More »

LCRM301 Researching Criminology

LCRM301 Researching CriminologyTopic: Planningcriminological research andformulating effectiveresearch questionsAcknowledgement ofcountryLecture structure Example?How do police perceptions of their own organization influence their views of the public,specifically their trust of people in the areas they patrol?How do women with insecure migration status experience and seek help for family violenceand what are their experiences

Read More »

ASSESSMENT NO.2 – COURT APPLICATION FACT PATTERN

FACULTY OF LAW AND BUSINESSThomas More Law SchoolLAWS201: CIVIL PROCEDURE & ADRSEMESTER TWO, 2025 – NATIONAL –ASSESSMENT NO.2 – COURT APPLICATION FACT PATTERN(AND THE FACT PATTERN FOR THE PLEADINGS WORKSHOP IN WEEK 5)BackgroundRachel Richardson is a printer by trade although she currently works in art design fora fashion magazine based

Read More »

Assessment 2: Court Application

02/09/2025, 20:3430 Points PossibleAssessment 2: Court ApplicationAssessment 2: Court ApplicationDetailsAssessment task 2: Court Application (worth 30% of the final total mark for this unit)Add commentA simulated court application will be run in weeks 6 and 7 of semester on selected topics from the first five weeks of the unit. Your

Read More »

APPENDIX B: ASSESSMENT TASK 2 – COURT APPLICATION

APPENDIX B: ASSESSMENT TASK 2 – COURT APPLICATION (30% OF FINAL MARK)General informationThis Assessment task is worth 30 marks of your final mark.The task is either making (Applicant) or opposing (Respondent) an application before theSupreme Court in your respective state based on a fact scenario, which will be uploaded on

Read More »

Assessment task Assessment 1 – ASSIGNMENT

Assessment Task 1 (30% of the final mark)This Week30 Points PossibleIn ProgressNEXT UP: Submit assignmentUnlimited Attempts Allowed11/08/2025Attempt 1 Add commentDetails Assessment task Assessment 1 – ASSIGNMENTPurpose To give students the opportunity to produce a well-written piece of formal analysis on a topic inland law. Graduate capabilities GC1,3,7-11 are covered by

Read More »

Assessment Brief- Assessment 3- Map-Reduce Programming Challenge

Assessment Brief- Assessment 3- Map-Reduce Programming Challenge Unit Code/Description ICT313 Big Data for Software DevelopmentCourse/Subject Bachelor of Information TechnologySemester S1 – 2025Unit Learning OutcomesAddressedULO3: Critically assess and implement advanced data pre-processing andanalytics strategies in a software development context, focusing on tasks like datacleansing, transformation, and feature selection.ULO4: Design, develop, and

Read More »

Assessment 2 Infographic and Reflection

Assessment 2 Infographic and Reflection Part 1 Infographic and Part 2 Reflection using the Gibbs CycleThis assessment is worth 35% of your final grade (Infographic 18% + Reflection 17%). Assessment InstructionsPart 1: InfographicCreate an A3 size infographic (portrait layout).Submit as a .pdfTOPIC:Create your infographic as a poster (A3 paper size)

Read More »

CHCCSM013 Facilitate and review case management

ContentsAbout this document 4Student details section 4The community services work environment 5Workplace hours 6Responsibilities 6Evidence collection 7Section 1: Determine response for case management 9Section 2: Conduct case management meetings and develop case management plan 18Section 3: Monitor and review case work activities and processes 24Section 4: Supervisor report 28 About

Read More »

BMM6302 Entrepreneurship and Creativity Assignment help

Assignment Brief – Cohort 07 BMM6302 Entrepreneurship and Creativity  Component number Assignment 1 Assignment type 01 Business Idea (Video Presentation – Panopto) Learning outcomes for this assessment (Please see module Handbook for all learning outcomes) Compare and contrast a variety of strategic models to develop and critically evaluate business start-up

Read More »

BMM6582: eBusiness and eMarketing 02 Analytical Review Assignment Help

Assignment Brief BMM6582: eBusiness and eMarketing Component number Assignment 2 Assignment type 02 Analytical Review Learning outcomes for this assessment (Please see module Handbook for all learning outcomes) Compare, contrast, and analyse approaches used to evaluate a company’s current positioning in the traditional and electronic marketplaces. Appraise various options for

Read More »

BMM6582: eBusiness and eMarketing Assignment 2 Assignment Help

Assignment Brief BMM6582: eBusiness and eMarketing Component number Assignment 2 Assignment type 02 Analytical Review Learning outcomes for this assessment (Please see module Handbook for all learning outcomes) Compare, contrast, and analyse approaches used to evaluate a company’s current positioning in the traditional and electronic marketplaces. Appraise various options for

Read More »

BMM6582: eBusiness and eMarketing Assignment Help

Assignment Brief BMM6582: eBusiness and eMarketing Component number Assignment 1 Assignment type 01 Video presentation (Panopto) Learning outcomes for this assessment (Please see module Handbook for all learning outcomes) Compare, contrast, and analyse approaches used to evaluate a company’s current positioning in the traditional and electronic marketplaces. Appraise various options

Read More »

Business and Management Strategy Assignment Help

Business and Management Strategy: Assignment Guidelines and Suggested Structure (3,000 Words) 1. Introduction (approx. 250–300 words) 2. Industry Analysis and Competitive Environment (400–450 words) 3. Competition and Customer Requirements (550–600 words) 4. Resources and Strategy Implementation (500–550 words) 5. Strategic Capabilities & Sustainable Advantage (400–450 words) 6. Development of Resources

Read More »

BMM6452 – Professional Learning Through Work Assignment Help

Assignment Brief  BMM6452 – Professional Learning Through Work Assignment type  Final Assessment (Assessment 3)-To be Negotiated Learning outcomes   (Please see module Handbook for all learning outcomes)  By the end of this module, the student should be able to:  Demonstrate enhanced graduate employability skills, knowledge, behaviours and attitudes developed through working

Read More »

CSE2/4DBF (2025) – Assignment 1

CSE2/4DBF (2025) – Assignment 1 Page 1/3 CSE2/4DBF 2025Assignment 1 (20%)Due date: this week AIMS AND OBJECTIVES:✓ to represent a problem description given in natural language as an (Enhanced) EntityRelationship modelThis is an individual Assignment. You are not permitted to work as a group when writingthis assignment. The use of

Read More »

Can I Pay Someone to Do My Assignment? A Complete Student Guide

If you’re a student juggling multiple deadlines, exams, part-time work, or personal responsibilities, you may have found yourself asking: can I pay someone to do my assignment? You’re not alone. This is one of the most searched academic questions today, especially among university and college students worldwide. In this blog,

Read More »

Project Development and Analysis in Emerging Technologies

Assessment Brief- Assessment 2 Unit Code/Description ICT305 – Topics in IT Course/Subject BIT Semester 2024- S1 Unit Learning Outcomes Addressed ULO 1, 2, and 3. Assessment Objective The primary objective of this assessment is to provide students with hands-on experience in designing, implementing, and analysing a project in one of

Read More »

EDUC1006 Interdisciplinary Studies: Crossing the line

ASSESSMENT 2: Report Summary Title Assessment 2 Type Report Due Date Thursday 17 April, 11.59 pm (end of Week 6) Length 1500 words or equivalent Weighting 50% Academic Integrity The use of GenAI is allowed but limited for this assessment task. Submission Word document or PDF submitted to Turnitin Unit

Read More »

Writing in Community Development

Assessment Overview Overview Length or Duration Worth Due This essay should demonstrate a coherent argument, which is backed up by evidence from relevant journal articles, books and websites. You are expected to make two direct quotations only; and the rest should be paraphrases. You should also list at least eight sources.   If you are unsure of

Read More »

Can't Find Your Assignment?