ENDLESS SUPPORT IN INFORMATION LEVEL DESIGN ASSIGNMENTS WRITING SERVICES - YOU GET REVISED OR MODIFIED WORK TILL YOU ARE SATISFIED WITH OUR INFORMATION LEVEL DESIGN ASSIGNMENT HELP SERVICES!

Question: Complete the information-level design for a database that satisfies the following constraints and user view requirements.

Answer: Database Design of Mindful Body Fitness Company

Mindful body fitness company provides health care services for relaxing mind and body. The database Mindful body fitness company has four entities named as Coach, Program, Customer and Exercise log. Each entity has certain attributes associated with it. The attributes of various entities of Mindful body fitness company are :

Identify and list entities described in all user requirements given above.

Entities and attributes
a) Coach
1) ID number (Primary key)
2) First_name
3) Last_name
4) Address
5) Date_Of_Birth
6) Contact_no
7) Username
8) Password

b) Program
1) PNUM (Primary key)
2) Ptitle
3) Start_date
4) Finish_date
5) Price

c) Customer
1) Cust_num(Primary key)
2) First_name
3) Last_name
4) Address
5) PNUM
6) Ptitle
7) Payment

d) Exercise log
1) Eid(Primary key)
2) Date
3) Ecategory
4) Esubcategory
5) Time_spent
6) Calories_burnt

Question: Add attributes to these entities and represent them as a collection of tables and attributes (Database schema)

Information design of Mindful body fitness

Information design of Mindful body fitness

MOST RELIABLE AND TRUSTWORTHY INFORMATION LEVEL DESIGN ASSIGNMENT HELP & HOMEWORK WRITING SERVICES AT YOUR DOORSTEPS!

Question: Outline 3 business rules that describe the relationships between entities.

Business Rules of Mindful body fitness
1) A coach can work on only one program.
2) A program can have one or more coaches associated with it.
3) One customer can enroll for only one program at one time.
4) A coach guides one or more customers
5) Each program has one or more customers in it.
6) Each customer has one or more Exercise log.

Relationships between entities
1) Coach and Program has one to many relationship.
2) Coach and customer has one to many relationship.
3) Customer and Program has one to many relationship.
4) Customer and Exercise log has one to many relationship.

Question: Determine the functional dependences.

Functional Dependencies
Cust_num→First_name
Cust_num→Last_name
Cust_num→Address
Cust_num→P_num
Cust_num→Ptitle
Cust_num→Payment
P_num→Ptitle
Id_number→First_name
Id_number→Last_name
Id_number→Address
Id_number→Date_Of_Birth
Id_number→Contact_no
Id_number→Username
Id_number→Password
P_num→Start_date
P_num→Finish_date
P_num→Price
Eid→Date
Eid→Ecategory
Eid→Esubcategory
Eid→Time_spent
Eid→Calories_burnt
Ecategory→Esubcategory

HIRE PROFESSIONAL WRITER FROM EXPERTSMINDS.COM AND GET BEST QUALITY INFORMATION LEVEL DESIGN ASSIGNMENT HELP AND HOMEWORK WRITING SERVICES!

a. Then normalise these tables. Make the normalization to 3NF. State for every step in the normalization, which functional dependency causes it.

Normalization of tables

Normalization is the process of removing redundancy from the tables.

The tables are in first normal form as all the tables contain one value for each field and no field is null.

The tables are in second normal formal as they satisfy the first normal form and all the non key attributes are fully dependent on the key attributes.

The table  customer is not in third normal form as there are transitive dependencies in these tables.

Cust_num→P_num

P_num→Ptitle

Cust_num→Ptitle

So, we will split customer table on basis of these functional dependencies

Question 2. Represent the structure of your database visually by using an entity-relationship (E-R) diagram. If you make any assumptions about data that are not explicitly given in the problem, these must be described.

E-R Diagram of Mindful body fitness

GET ASSURED A++ GRADE IN EACH INFORMATION LEVEL DESIGN ASSIGNMENT ORDER - ORDER FOR ORIGINALLY WRITTEN SOLUTIONS!