Part 2 Practicing Normalization Please explain, thank you Exercise 1 Transforming Attributes The manager of a company dinner club would like to have an information system that assists him to plan the meals and to keep track of who attends the dinners, and so on Because the manager is not an IS expert, the following table is used to store the information As a member can attend many dinners and a member will not attend more than 1 dinner on the same date, the primary key of the following table is Member ID and Dinner ID Dinners can have many courses, from one course dinner to as many courses as the chef desired Member customer Dinner meal Venue location Food specific food item PK MEMBERID DINNERID TEST Does each attribute depend on both components of the Primary Key, or just a portition The manager of a company dinner club would like to have an information system that assists him to plan the meals and to keep track of who attends the dinners, and so on Because the manager is not an IS expert, the following table is used to store the information As a member can attend many dinners and a member will not attend more than 1 dinner on the same date, the primary key of the following table is Member Num Dinner Num Dinners can have many courses, from one course dinner to as many courses as the chef desired MEMBER NUM MEMBER NAME MEMBER ADDRESS DINNER NUM DINNER DATE VENUE CODE VENUE DESCRIPTION FOOD CODE FOOD DESCRIPTION 214 Peter Wong 325 Meadow Park D0001 15 Mar 10 B01 Grand Ball Room EN3 Stu ed crab DE8 Chocolate mousse 235 Mary Lee 123 Rose Court D0002 15 Mar 10 B02 Pe)t Ball Room EN5 Marinated steak DE8 Chocolate mousse 250 Peter Wong 9 Nine Ave D0003 20 Mar 10 C01 Caf SO1 Pumpkin soup EN5 Marinated steak DE2 Apple pie 235 Mary Lee 123 Rose Court D0003 20 Mar 10 C01 Caf SO1 Pumpkin soup EN5 Marinated steak DE2 Apple pie 300 Paul Lee 123 Rose Court D0004 20 Mar 10 E10 Pe)t Ball Room SA2 Apple pie This table has only 5 records a Use proper notation to write down the above table Use Member Dinner as the table name b Convert the above Member Dinner table into 1 st Normal Form table c Assuming you can identify the functional dependencies from the table draw a functional dependencies diagram for the 1 st NF table d Develop a set of 3NF tables Show every step of normalization along the way MemberID MemberName MemberAddress DinnerID DinnerDate VenueCode VenueDescription FoodCode FoodDescription 214 Peter Wong 325 Meadow Park D0001 02 02 2020 L01 Grand Ball Room EN3 Stu ed crab DEB Beef 235 Mary Lee 123 Bellfower D0002 02 02 2020 L02 Caf EN5 Chocolate Mousse DEB Beef 250 John Doe 9923 Orange D0003 03 03 20 L01 Grand Ball Room SO1 Marinated Steak EN5 Chocolate Mousse DE2 Apple Pie 235 Mary Lee 123 Bellfower D0004 03 03 2020 L02 Caf S01 Pumpkin Soup SA2 Marinated Steak DE2 Apple Pie 300 Paul Lee 123 Bellfower D0004 03 03 2020 L03 Petit Ball Room SA2 Marinated Steak MemberID MemberName MemberAddress DinnerID DinnerDate VenueCode VenueDescription FoodCode FoodDescription 214 Peter Wong 325 Meadow Park D0001 02 02 2020 L01 Grand Ball Room EN3 Stu ed crab 214 Peter Wong 325 Meadow Park D0001 02 02 2020 L01 Grand Ball Room DEB Beef 235 Mary Lee 123 Bellfower D0002 02 02 2020 L02 Caf EN5 ChocolateMousse 235 Mary Lee 123 Bellfower D0002 02 02 2020 L02 Cafe DEB Beef 250 John Doe 9923 Orange D0003 03 03 20 L01 Grand Ball Room SO1 Marinated Steak 250 John Doe 9923 Orange D0003 03 03 20 L01 Grand Ball Room EN5 Chocolate Mousse 250 John Doe 9923 Orange D0003 03 03 20 L01 Grand Ball Room DE2 Apple Pie 235 Mary Lee 123 Bellfower D0004 03 03 2020 L02 Caf S01 Pumpkin Soup 235 Mary Lee 123 Bellfower D0004 03 03 2020 L02 Caf SA2 Marinated Steak 235 Mary Lee 123 Bellfower D0004 03 03 2020 L02 Caf DE2 Apple Pie 300 Paul Lee 123 Bellfower D0004 03 03 2020 L03 Petit Ball Room SA2 Marinated Steak Is the above table considered a relation Why or why not Is it in any normal form If so, which one Transform the table above into first normal form 1NF (To do this, check if there are multivalued attributes and transform the table to get rid of them) Identify the dependencies and which type they are (full dependencies, partial dependencies, transitive dependencies Transform the table above into second normal form 2NF (To do these separate partial dependencies into separate tables) Transform the table above into third normal form 3NF (To do this, remove the transitive dependencies by creating separate tables and relate them with the common attribute)

The Answer is in the image, click to view ...

Question: Part 2: Practicing Normalization Please explain, thank you. Exercise 1: Transforming Attributes The manager of a company dinner club would like to have an information

Part 2: Practicing Normalization

Please explain, thank you.

Exercise 1: Transforming Attributes

The manager of a company dinner club would like to have an information system that assists him to plan the meals and to keep track of who attends the dinners, and so on.

Because the manager is not an IS expert, the following table is used to store the information. As a member can attend many dinners and a member will not attend more than 1 dinner on the same date, the primary key of the following table is Member ID and Dinner ID. Dinners can have many courses, from one-course dinner to as many courses as the chef desired.

Member = customer

Dinner = meal

Venue = location

Food = specific food item

PK = MEMBERID + DINNERID

TEST: Does each attribute depend on both components of the Primary Key, or just a portition?

The manager of a company dinner club would like to have an information system that assists him to plan the meals and to keep track of who attends

the dinners, and so on.

Because the manager is not an IS expert, the following table is used to store the information. As a member can attend many dinners and a member

will not attend more than 1 dinner on the same date, the primary key of the following table is Member Num + Dinner Num. Dinners can have many

courses, from one-course dinner to as many courses as the chef desired.

MEMBER

NUM

MEMBER

NAME

MEMBER

ADDRESS

DINNER

NUM

DINNER

DATE

VENUE

CODE

VENUE

DESCRIPTION

FOOD

CODE

FOOD

DESCRIPTION

214 Peter Wong

325

Meadow

Park

D0001 15-Mar-10 B01

Grand Ball

Room

EN3 Stu ed crab

DE8

Chocolate

mousse

235 Mary Lee

123 Rose

Court

D0002 15-Mar-10 B02 Pe)t Ball Room EN5 Marinated steak

DE8

Chocolate

mousse

250 Peter Wong 9 Nine Ave D0003 20-Mar-10 C01 Caf SO1 Pumpkin soup

EN5 Marinated steak

DE2 Apple pie

235 Mary Lee

123 Rose

Court

D0003 20-Mar-10 C01 Caf SO1 Pumpkin soup

EN5 Marinated steak

DE2 Apple pie

300 Paul Lee

123 Rose

Court

D0004 20-Mar-10 E10 Pe)t Ball Room SA2 Apple pie

* This table has only 5 records.

a. Use proper notation to write down the above table. Use Member Dinner as the table name.

b. Convert the above Member Dinner table into 1

Normal Form table.

c. Assuming you can identify the functional dependencies from the table; draw a functional dependencies diagram

for the 1

NF table.

d. Develop a set of 3NF tables. Show every step of normalization along the way.

MemberID	MemberName	MemberAddress	DinnerID	DinnerDate	VenueCode	VenueDescription	FoodCode	FoodDescription
214	Peter Wong	325 Meadow Park	D0001	02/02/2020	L01	Grand_Ball_Room	EN3	Stu ed crab
	DEB	Beef
235	Mary Lee	123 Bellfower	D0002	02/02/2020	L02	Caf	EN5	Chocolate Mousse
	DEB	Beef
250	John Doe	9923 Orange	D0003	03/03/20	L01	Grand_Ball_Room	SO1	Marinated Steak
	EN5	Chocolate Mousse
DE2	Apple Pie
235	Mary Lee	123 Bellfower	D0004	03/03/2020	L02	Caf	S01	Pumpkin Soup
	SA2	Marinated Steak
DE2	Apple Pie
300	Paul Lee	123 Bellfower	D0004	03/03/2020	L03	Petit_Ball_Room	SA2	Marinated Steak

MemberID	MemberName	MemberAddress	DinnerID	DinnerDate	VenueCode	VenueDescription	FoodCode	FoodDescription
214	Peter Wong	325 Meadow Park	D0001	02/02/2020	L01	Grand_Ball_Room	EN3	Stu ed crab
214	Peter Wong	325 Meadow Park	D0001	02/02/2020	L01	Grand_Ball_Room	DEB	Beef
235	Mary Lee	123 Bellfower	D0002	02/02/2020	L02	Caf	EN5	ChocolateMousse
235	Mary Lee	123 Bellfower	D0002	02/02/2020	L02	Cafe	DEB	Beef
250	John Doe	9923 Orange	D0003	03/03/20	L01	Grand_Ball_Room	SO1	Marinated Steak
250	John Doe	9923 Orange	D0003	03/03/20	L01	Grand_Ball_Room	EN5	Chocolate Mousse
250	John Doe	9923 Orange	D0003	03/03/20	L01	Grand_Ball_Room	DE2	Apple Pie
235	Mary Lee	123 Bellfower	D0004	03/03/2020	L02	Caf	S01	Pumpkin Soup
235	Mary Lee	123 Bellfower	D0004	03/03/2020	L02	Caf	SA2	Marinated Steak
235	Mary Lee	123 Bellfower	D0004	03/03/2020	L02	Caf	DE2	Apple Pie
300	Paul Lee	123 Bellfower	D0004	03/03/2020	L03	Petit_Ball_Room	SA2	Marinated Steak

Is the above table considered a relation? Why or why not? Is it in any normal form? If so, which one?

Transform the table above into first normal form 1NF. (To do this, check if there are multivalued attributes and transform the table to get rid of them)

Identify the dependencies and which type they are (full dependencies, partial dependencies, transitive dependencies.

Transform the table above into second normal form 2NF. (To do these separate partial dependencies into separate tables).
Transform the table above into third normal form 3NF. (To do this, remove the transitive dependencies by creating separate tables and relate them with the common attribute)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

2. The manager of a company dinner club would like to have an information system that assists him to keep track of who makes 3. please solve this appointments for each dinner. A customer can only...

2. The manager of a company dinner club would like to have an information system that assists him to keep track of who makes 3. please solve this appontments for each dinner. A customer can only...

The manager of a company dinner club would like to have an information system that assists him to plan the meals and to keep track of who attends the dinners, and so on. Because the manager is not an...

Please see attached document, I only need part 2 and 10 answered. I already completed the rest but I wasn't sure about those two. If additional information is need for the question, please let me...

\f \f11TH EDITION STRATEGIC MANAGEMENT THEORY 11TH EDITION Strategic Management THEORY Charles W. L. Hill University of Washington - Foster School of Business Gareth R. Jones Melissa A. Schilling New...

Wine Tasting Facilitator Guide Welcome and Training Agenda Today, we will be training on seasonal wines that will now be offered at Buca di Beppos. We are doing this training to help our all front of...

N A S TIO I C VE A N T I IZ O E T N R C A TI O PE G CA E S R NI H R T E O U P OR M 2 F OM E R T P C A L C H A L LEARNING OBJECTIVES After studying this chapter, you will be able to answer several...

what is your overall evaluation of PepsiCo?s business portfolio in 2014? Does the portfolio provide the company?s shareholders with an opportunity for above-average market returns? 5 PEPSICO PepsiCo...

The articles describes four cultures defined by two continuums in a 2 x 2 matrix. Would a complex project be able to be accomplished in a fragmented Project Management team culture? If not, what...

AudienceView Case (attached) Questions Identify which issues are the most important to come to grips with (that is if you do not get a positive answer, you would not go forward with this investment?...

a. If we will apply the concept of PPF to Philippines economy in 2020, how will you illustrate it using a PPF. Why do you think that we experience negative growth in 2020? b. Do you think the PPF of...

Suppose bundles A and B lie on the same indifference curve. Bundle C lies between bundles A and B, on a straight line that connects them. The consumer's preferences satisfy the Declining MRS...

In this question, the Indonesian Rupiah is IDR, the South Korean Won is SKW , the Australian dollar is AUD, and the US dollar is USD. This question involves five ( repeat , FIVE ) spot exchange rates...

Premise: Using a dictionary and list, create a set of key / value pairs that consists of a musical database. The key / value pairs should consist of Artist Name: Song Names pattern. For example, EACH...