The following relation(table) contains data about employees in an institution of higher learning. Employees can have...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following relation(table) contains data about employees in an institution of higher learning. Employees can have more than one designation or title and can belong to 1 or more departments as shown in this relation. A composite key (Designation, Emp_ No, Dept No) uniquely identifies each row. Designation Emp_Name Technician Mdu Technician Moodley Receptionist Zintle Marketer Mbuso Lecturer Lecturer Lecturer Lecturer Dept Name MICT MICT Admin Marketing BEMS MICT Moodley MICT Mdu MBA The following are the attributes of this relation: Emp_Name: Name of employee, Emp_Add: Address of employee, Emp_No: Employee number, Dept_No: Department number, Dept_Name: Name of department, and Dept Location: location of the department. 4.1 Identify the update and deletion anomalies in the above relation. (5) 4.2 Normalise the above relation up to Boyce Codd Normal Form (BCNF). For each of the normal forms, state the conditions and explain if the relation(s) meet the requirements for that normal form. Write down all the relations, indicating primary keys for each of them. (20) Hint: the following functional dependencies exist: Emp No → Emp_Name, Emp_Add Dept No →→ Dept Name, Dept_Location Dept Name → Dept_Location Emp_Add 123 1st Road 555 2nd ST 222 Aim ST 321 Brad ST 123 1st Road 123 1st Road 555 2nd ST 123 1st Road Pillay Mdu Emp_No 001 005 003 002 009 001 005 001 Dept_No Dept Location Area 1 Area 1 Area 2 Area 3 Area 4 Area 1 Area 1 Area 5 100 100 200 600 500 100 100 800 The following relation(table) contains data about employees in an institution of higher learning. Employees can have more than one designation or title and can belong to 1 or more departments as shown in this relation. A composite key (Designation, Emp_ No, Dept No) uniquely identifies each row. Designation Emp_Name Technician Mdu Technician Moodley Receptionist Zintle Marketer Mbuso Lecturer Lecturer Lecturer Lecturer Dept Name MICT MICT Admin Marketing BEMS MICT Moodley MICT Mdu MBA The following are the attributes of this relation: Emp_Name: Name of employee, Emp_Add: Address of employee, Emp_No: Employee number, Dept_No: Department number, Dept_Name: Name of department, and Dept Location: location of the department. 4.1 Identify the update and deletion anomalies in the above relation. (5) 4.2 Normalise the above relation up to Boyce Codd Normal Form (BCNF). For each of the normal forms, state the conditions and explain if the relation(s) meet the requirements for that normal form. Write down all the relations, indicating primary keys for each of them. (20) Hint: the following functional dependencies exist: Emp No → Emp_Name, Emp_Add Dept No →→ Dept Name, Dept_Location Dept Name → Dept_Location Emp_Add 123 1st Road 555 2nd ST 222 Aim ST 321 Brad ST 123 1st Road 123 1st Road 555 2nd ST 123 1st Road Pillay Mdu Emp_No 001 005 003 002 009 001 005 001 Dept_No Dept Location Area 1 Area 1 Area 2 Area 3 Area 4 Area 1 Area 1 Area 5 100 100 200 600 500 100 100 800
Expert Answer:
Answer rating: 100% (QA)
Based on the given relation and the functional dependencies lets first address the update and deletion anomalies and then well move on to normalizing the given relation up to BoyceCodd Normal Form BCN... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these programming questions
-
a) 2u - 3v b) uxv Let <1,2,3 > and < 2, 2, -1> Find: c) The angle between the vectors d) The vector component of along u
-
There is an XYZ Company, which purchases some parts from vendors to produce some products. It has several departments, marketing sites, and parts supply vendors in the company. 1) For each...
-
Based on Westlaw's data on the case Christoff v. Nestl USA, INC., I did the brief case. My question is, is there any need to add and adjust the content and form of the case brief, especially the...
-
What is the main difference between n-type and p-type semiconductors?
-
The disk of mass m0 rests on the surface for which the coefficient of static friction is A Determine the friction force at A. Given: M 50 = N m mo = 45 kg A = 0.2 a = 300 mm b = 400 mm r = 125 mm
-
In Problem write the expression as a quotient of integers, reduced to lowest terms. 3 16 3 1 16
-
Throughout the US presidential election of 2016, polls gave regular updates on the sample proportion supporting each candidate and the margin of error for the estimates. This attempt to predict the...
-
In Austin, Texas, a comedy club complained to its landlord that its performances were being interrupted by the boisterous congregation of a church within the same building. The landlord asked the...
-
The Welding Department of Sheridan Company has the following production and manufacturing cost data for February 2025. All materials are added at the beginning of the process. Manufacturing Costs...
-
You are employed by McDowell and Partners, Chartered Accountants (M&P). A new client, Community Finance Corporation (CFC), approached M&P for assistance. Enviro Ltd. (Enviro) has asked CFC for a loan...
-
Explain the relation between resources, scarcity, opportunity cost, and production. Sarah and her boyfriend Mike want to save some money to pay for their wedding. So they decided to help people in...
-
If you know the names of the starting batters for a baseball team, what is the probability of randomly selecting a batting order and getting the order that is used in the beginning of the game?...
-
As the author is creating this exercise, a weather reporter stated that there are 3 chances in 10 of rain today. What is the probability of no rain today?
-
Determine the damping ratio associated with a second-order system in the standard form of Equation 8.32 that corresponds to a maximum (peak) logarithmic magnitude of \(15.22 \mathrm{~dB}\)....
-
When a couple has five children, none of the five is a girl. Assume that boys and girls are equally likely. Describing Complements. Provide a written description of the complement of the given event,...
-
A multiple-choice question on a statistics quiz has possible correct answers of a, b, c, d, e. What is the probability that false is the correct answer?
-
I need COS JIT 2 (2/) (1 + (1)") (-1)"
-
For a Poisson process of rate , the Bernoulli arrival approximation assumes that in any very small interval of length , there is either 0 arrivals with probability 1- or 1 arrival with probability ....
-
Breakeven analysis and target profit for a hospital Morton Medical Institute operates a 300-bed hospital and offers a number of specialized medical services. Mortons hospital facility and equipment...
-
Relevant and sunk costs McKinnon Company's plant manager is considering buying a new grinding machine to replace an old grinding machine or overhauling the old one to ensure compliance with the...
-
What are the three most common methods of setting a budget?
-
Suppose that in September 2013 a company takes a long position in a contract on May 2014 crude oil futures. It closes out its position in March 2014. The futures price (per barrel) is \($88.30\) when...
-
Explain how the control variate technique is implemented.
-
A company wishes to hedge its exposure to a new fuel whose price changes have a 0.6 correlation with gasoline futures price changes. The company will lose $1 million for each 1 cent increase in the...
Study smarter with the SolutionInn App