DBAS27198 Database Design and Implementation Assignment

Assignment Help Database Management System

Reference no: EM132579049 , Length: 6 pages

DBAS27198 Database Design and Implementation - Sheridan College

Database Design and Implementation for a Fitness Center

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 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)

Attachment:- Database Design and Implementation.rar

Reference no: EM132579049

Questions Cloud

Compute effect of transaction on the accounting equation is : £9,700 payment from a customer to settle their account for goods sold on credit. The effect of this transaction on the accounting equation is to

Authorized shares and outstanding shares : Discuss the difference between authorized shares and outstanding shares. Are there other classifications of shares that are important to consider?

What is tax bracket : What is your tax bracket?Your W-2 form reports that your total wage Your W-2 form also reports that $10,266 was withheld from your wages for federal income tax.

What is total tax for the year : What is your total tax for the year? Your W-2 form also reports that $4,178 was withheld from your wages for federal income tax.

DBAS27198 Database Design and Implementation Assignment : DBAS27198 Database Design and Implementation Assignment Help and Solution, Sheridan College - Assessment Writing Service

How much is taxable income : How much is your taxable income? Your W-2 form also reports that $4,178 was withheld from your wages for federal income tax.

Marketing communications plan : What factors do you think would be involved in developing and managing an effective marketing communications plan for a new product or service?

Calculate the maximum value of cell : What is a formula that uses the MAX function to calculate the maximum value of cell c20 of the monday through friday worksheet group.

Social media can enhance employee engagement : A proposal is a formal document prepared to offer a suggestion or recommendation. Social media can enhance employee engagement.

User Account

All Pages