Obtain A++ grades by taking Information Level Design Assignment Help and Online Tutor Services!!

Home   Course   Information Level Design Assignment Help
Previous << || >> Next

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 Company.jpg

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.

Customer

Cust_num

First_name

Last_name

Address

Payment

Eid

  321

Macro

veldi

Victoria

2400

11

322

Steffan

shah

Melbourne

3500

14

323

Ronarldo

antario

Washington

2600

15

324

Mickey

roger

Victoria

3400

16

P

Cust_num

P_NUM

Ptitle

321

1101

Aerobics

322

1102

Cardio flex

323

1104

Yoga for mind

324

11102

Cardio flex

Program

P_NUM

Ptitle

Start_date

Finish_date

Price

1101

Aerobics

5/19/2019

8/19/2019

5000

1102

Cardio flex

7/7/2019

7/9/2019

4000

1103

Muscular flex

8/6/2019

11/7/2019

6000

1104

Yoga for mind

7/6/2019

9/8/2019

4500

Exercise log

Eid

Edate

Ecategory

Esubcategory

Time_spent(in mins)

Calories_burnt

11

6/15/2019

Aerobics

Stretching

40

200

14

7/22/2019

Cardio

Weight loose

25

400

15

6/24/2019

Yoga

Zumba

30

600

16

7/24/2019

Cardio

fitness

35

675

Coach

Id_number

First_name

Last_name

Address

Date_Of_Birth

Contact_no

Username

Password

PNUM

141627

Ronan

Roger

Victoria

4/21/1996

1233456789

ronanro

234576

1102

142628

Hugo

Fiddler

Melbourne

4/6/1993

1234561234

hugofidd

222466

1103

143629

Diego

Chris

Washington

5/7/1992

1345678991

deigochris

345664

1101

144630

Brayden

Madden

Melbourne

3/8/1991

1234545273

vraydadde

122435

1102

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

Customer

Cust_num

First_name

Last_name

Address

Payment

Eid

  321

Macro

veldi

Victoria

2400

11

322

Steffan

shah

Melbourne

3500

14

323

Ronarldo

antario

Washington

2600

15

324

Mickey

roger

Victoria

3400

16

 

Program of customers

Cust_num

P_NUM

Ptitle

321

1101

Aerobics

322

1102

Cardio flex

323

1104

Yoga for mind

324

11102

Cardio flex

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

E-R Diagram of Mindful body fitness.jpg

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

Tag This :- EM201928WAS528CN, Information Level Design Assignment Help

get assignment Quote

Assignment Samples

    Safety Measures Assignment Help

    safety measures assignment help - The task is based on the ability of a competent person to handle all the safety measures that goes in a construction site.

    Creative Story Writting Assignment Help

    creative story writing assignment help - Tell the story of a scar, whether a physical scar or emotional one. Write a fiction or nonfiction story about a scar.

Get Academic Excellence with Best Skilled Tutor! Order Assignment Now! Submit Assignment