Question: Question # 1 Consider the following table. Following the steps of normalization (beginning with determining the functional dependencies), do what is necessary to take it

Question # 1

Consider the following table. Following the steps of normalization (beginning with determining the functional dependencies), do what is necessary to take it to 1NF to 2NF and to 3NF. Once in 3NF, discuss whether or not it is also in BCNF, 4NF, and 5NF. If it is not, make the necessary changes. Assume that Dept# and Cust# construct the primary key in our initial table.

Question # 1 Consider the following table. Following the steps of normalization

Unnormalized Table Mgr Dept ID Tel Date of Dept Name Location Mgr Name No. Exin. Cust# Cust Name Complaint Nature of Complaint 11232 Soap Division Cincinnati Mary Samuel S117711 P10451 Robert Drumtree 1998-01-12 Poor Service P10480 Steven Parks 1998-01-14 Discourteous Attendant

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 Databases Questions!

Page. 1 210.02 Lab 210.02 Data Normalization Lab (Revised 2/11/04) Data Normalization Basics This exercise consists of two exercises that will demonstrate your ability to normalize data using the...

Question 1. Consider a relation R (A, B, C, D, E) with the following functional dependency set F = {AB -> C, CD -> E, DE -> B} [ Read an f.d XY -> Z as {X, Y} -> {Z} where X, Y, and Z are atomic...

Can I get help with this question, please. Consider the following relation for published books: BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publisher). The primary key for this...

I'm an undergrad accounting student in an introduction to forensic accounting course.I need help getting started on a final project for this class over a fictitious company called the Grand Teton...

Its only 8 simple question but looks like lengthy assignment. Just need focus and attention Term Project - week 8 - (17%): You were just hired to make a database to track blood draws at a lab....

This is not an easy and quick question for you instructors. It need attention and time and good knowledge of data base. It is complete question. Term Project - week 8 - (17%): You were just hired to...

You were just hired by an airline industry to create a database to record the various airlines and the pilots that work for them Discussions with the industry representatives focused on two initial...

SQL Background: Premiere Products database team is working on storing the information contained in the order invoice form in a databases table. Looking at what data is captured in the order form,...

(1 point) The graph of f(x) = 2x + 15x 84x + 20 has two horizontal tangents. One occurs at a negative value of x and the other at a positive value of x. What is the negative value of x where a...

43. Given the following two stocks A and B Security Expected rate of return Beta 1.2 1.8 A B 0.12 0.14 If the expected market rate of return is 0.09 and the risk-free rate is 0.05, which security...

3. Shannon's Irish Cookware is implementing a project that will initially increase accounts payable by 5,000, increase inventory by 3,200, and decrease accounts receivable by 1,800. All net working...

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

6. Search YouTube for a segment with a speaker giving a speech or visit TED talks (the topic does not matter). Turn off the volume so you can only see (not hear) the speech. Analyze the physical...

6. Pick a general topic and try to come up with several different attention getters for that topic. Heres an example for the topic dogs: c Tell a funny story about your dog. c Did you know that the...

5. Establishing a relationship with the audience is important when giving a speech. Make a list of all of the possible members of your audience. How do you plan to connect with all members of the...