1) Consider the relation A, with key and functional dependencies shown below. I. What Normal form...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1) Consider the relation A, with key and functional dependencies shown below. I. What Normal form is A in right now? Why? II. III. What actions would you take to normalize A to the next higher normal form (describe the steps)? Follow those steps you mentioned in the prior question to normalize A to the next higher normal form. Be sure to show all work. IV. V. Once you have normalized A, what normal forms are each the two new relations in? Why? If any of the remaining relations are not in 3NF, normalize them to 3NF. Be sure to show all work. P101 P102 P103 P103 P104 P105 P106 P111 P115 P116 P116 P117 A (p, r, s, t, u, v) P, r p, r➜s, t, u, v Key: FD1: FD2: FD3: 2) Given the Project relation below with sample data, write down the Key and Functional Dependencies. Then normalize the relation to 3NF. Be sure to follow all steps and show your work. Projects (ProjectID (Key), Contact Person, Street, City, State, ZipCode, PhaselD (Key), Name, Budget) Sample Data: r➜s, v t➜u ProjectID Contact Person Street Fawcett Smith Roberts Smith Grand Smith Smith Smith Alexander Davis Alexander Collins Laughton Laughton Smith City State ZipCode PhaselD Name Lincoln NE 68501 P52 Paving Lincoln NE 68501 | P50 Sidewalk Repairs Fremont NE 68025 P51 Fremont NE 68025 | P50 68505 P51 22nd 68601 P52 NE Columbus NE Bird Omaha NE Sloan Omaha 68007 P51 NE Lincoln Omaha NE Atwood KS Sun St Sun St Atwood KS Main Atwood KS Grand Main Lincoln 68111 P53 68007 P51 67730 P55 67730 P51 67730 | 150 Curb Replacement Sidewalk Repairs Curb Replacement Paving Curb Replacement ADA Crosswalk Curb Replacement ADA Crosswalk Curb Replacement Sidewalk Repairs Budget 1,025 1,575 1,050 1,575 1,050 1,050 1,300 1,500 1,050 1,000 1,100 1,050 Note that a few of the Projects are managed by the same Contact Person. Some cities have more than one ZipCode. Budget is in 1,000's of dollars. 1) Consider the relation A, with key and functional dependencies shown below. I. What Normal form is A in right now? Why? II. III. What actions would you take to normalize A to the next higher normal form (describe the steps)? Follow those steps you mentioned in the prior question to normalize A to the next higher normal form. Be sure to show all work. IV. V. Once you have normalized A, what normal forms are each the two new relations in? Why? If any of the remaining relations are not in 3NF, normalize them to 3NF. Be sure to show all work. P101 P102 P103 P103 P104 P105 P106 P111 P115 P116 P116 P117 A ( p, r, s, t, u, v) P, r p, r➜s, t, u, v Key: FD1: FD2: FD3: 2) Given the Project relation below with sample data, write down the Key and Functional Dependencies. Then normalize the relation to 3NF. Be sure to follow all steps and show your work. Projects (ProjectID (Key), Contact Person, Street, City, State, ZipCode, PhaselD (Key), Name, Budget) Sample Data: r➜s, v t➜u ProjectID Contact Person Street Fawcett Smith Roberts Smith Grand Smith Smith Smith Alexander Davis Alexander Collins Laughton Laughton Smith City State ZipCode PhaselD Name Lincoln NE 68501 P52 Paving Lincoln NE 68501 | P50 Sidewalk Repairs Fremont NE 68025 P51 Fremont NE 68025 | P50 68505 P51 22nd 68601 P52 NE Columbus NE Bird Omaha NE Sloan Omaha 68007 P51 NE Lincoln Omaha NE Atwood KS Sun St Sun St Atwood KS Main Atwood KS Grand Main Lincoln 68111 P53 68007 P51 67730 P55 67730 P51 67730 | 150 Curb Replacement Sidewalk Repairs Curb Replacement Paving Curb Replacement ADA Crosswalk Curb Replacement ADA Crosswalk Curb Replacement Sidewalk Repairs Budget 1,025 1,575 1,050 1,575 1,050 1,050 1,300 1,500 1,050 1,000 1,100 1,050 Note that a few of the Projects are managed by the same Contact Person. Some cities have more than one ZipCode. Budget is in 1,000's of dollars. 1) Consider the relation A, with key and functional dependencies shown below. I. What Normal form is A in right now? Why? II. III. What actions would you take to normalize A to the next higher normal form (describe the steps)? Follow those steps you mentioned in the prior question to normalize A to the next higher normal form. Be sure to show all work. IV. V. Once you have normalized A, what normal forms are each the two new relations in? Why? If any of the remaining relations are not in 3NF, normalize them to 3NF. Be sure to show all work. P101 P102 P103 P103 P104 P105 P106 P111 P115 P116 P116 P117 A (p, r, s, t, u, v) P, r p, r➜s, t, u, v Key: FD1: FD2: FD3: 2) Given the Project relation below with sample data, write down the Key and Functional Dependencies. Then normalize the relation to 3NF. Be sure to follow all steps and show your work. Projects (ProjectID (Key), Contact Person, Street, City, State, ZipCode, PhaselD (Key), Name, Budget) Sample Data: r➜s, v t➜u ProjectID Contact Person Street Fawcett Smith Roberts Smith Grand Smith Smith Smith Alexander Davis Alexander Collins Laughton Laughton Smith City State ZipCode PhaselD Name Lincoln NE 68501 P52 Paving Lincoln NE 68501 | P50 Sidewalk Repairs Fremont NE 68025 P51 Fremont NE 68025 | P50 68505 P51 22nd 68601 P52 NE Columbus NE Bird Omaha NE Sloan Omaha 68007 P51 NE Lincoln Omaha NE Atwood KS Sun St Sun St Atwood KS Main Atwood KS Grand Main Lincoln 68111 P53 68007 P51 67730 P55 67730 P51 67730 | 150 Curb Replacement Sidewalk Repairs Curb Replacement Paving Curb Replacement ADA Crosswalk Curb Replacement ADA Crosswalk Curb Replacement Sidewalk Repairs Budget 1,025 1,575 1,050 1,575 1,050 1,050 1,300 1,500 1,050 1,000 1,100 1,050 Note that a few of the Projects are managed by the same Contact Person. Some cities have more than one ZipCode. Budget is in 1,000's of dollars. 1) Consider the relation A, with key and functional dependencies shown below. I. What Normal form is A in right now? Why? II. III. What actions would you take to normalize A to the next higher normal form (describe the steps)? Follow those steps you mentioned in the prior question to normalize A to the next higher normal form. Be sure to show all work. IV. V. Once you have normalized A, what normal forms are each the two new relations in? Why? If any of the remaining relations are not in 3NF, normalize them to 3NF. Be sure to show all work. P101 P102 P103 P103 P104 P105 P106 P111 P115 P116 P116 P117 A ( p, r, s, t, u, v) P, r p, r➜s, t, u, v Key: FD1: FD2: FD3: 2) Given the Project relation below with sample data, write down the Key and Functional Dependencies. Then normalize the relation to 3NF. Be sure to follow all steps and show your work. Projects (ProjectID (Key), Contact Person, Street, City, State, ZipCode, PhaselD (Key), Name, Budget) Sample Data: r➜s, v t➜u ProjectID Contact Person Street Fawcett Smith Roberts Smith Grand Smith Smith Smith Alexander Davis Alexander Collins Laughton Laughton Smith City State ZipCode PhaselD Name Lincoln NE 68501 P52 Paving Lincoln NE 68501 | P50 Sidewalk Repairs Fremont NE 68025 P51 Fremont NE 68025 | P50 68505 P51 22nd 68601 P52 NE Columbus NE Bird Omaha NE Sloan Omaha 68007 P51 NE Lincoln Omaha NE Atwood KS Sun St Sun St Atwood KS Main Atwood KS Grand Main Lincoln 68111 P53 68007 P51 67730 P55 67730 P51 67730 | 150 Curb Replacement Sidewalk Repairs Curb Replacement Paving Curb Replacement ADA Crosswalk Curb Replacement ADA Crosswalk Curb Replacement Sidewalk Repairs Budget 1,025 1,575 1,050 1,575 1,050 1,050 1,300 1,500 1,050 1,000 1,100 1,050 Note that a few of the Projects are managed by the same Contact Person. Some cities have more than one ZipCode. Budget is in 1,000's of dollars.
Expert Answer:
Answer rating: 100% (QA)
1 The relation A is currently in the first normal form 1NF This is because it contains a composite key p r and all attributes are atomic meaning they ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
What types of problems are more common among people who do not have their finances under control?
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
The recently completed new building to house the exhibits and staff of the Central City Museum was located adjacent to the campus of a private university. The new building was financed by the...
-
The population of a certain colony of bacteria increases by 5% each hour. After 7 hours, what is the percent increase in the population over the initial population?
-
Television channels are 6 MHz wide. How many bits/sec can be sent if four-level digital signals are used? Assume a noiseless channel.
-
Is (S,R) a poset if S is the set of all people in the world and (a, b) R, where a and b are people, if a) A is taller than b? b) A is not taller than b? c) A = b or a is an ancestor of b? d) A and b...
-
Starting with Eq. (4.1-10), show that if \(\Delta v \ll \bar{v}\) and \(r \ll 2 c / \Delta v\) for all \(P_{1}\), then \[ \mathbf{u}\left(P_{0}, t ight) \approx \iint_{\Sigma} \frac{e^{j 2 \pi(r /...
-
Assume that a new project will annually generate revenues of $2,000,000 and cash expenses (including both fixed and variable costs) of $800,000, while increasing depreciation by $200,000 per year. In...
-
Applying analytical synthesis of mechanisms, design a four-bar mechanism to move the object shown in the figure, through the three positions indicated in their numbered order without taking into...
-
Wolsey Industries Inc. expects to maintain the same inventories at the end of 20Y3 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to...
-
The following C program has three (3) syntax errors/warnings in it when compiled. Identify and correct the errors by stating the line number where they occur [2 marks each, 6 marks in total]. 10...
-
Conduct an ethics assessment. Analysis your department's or organization's "ethical scorecard." Look at the policies that most strongly affect services and their implementation. After reviewing the...
-
Set out below is the sales revenue and profit for 2023. Year Sales Profit 2023 464,820 146,522 In 2023, the business manufactured and sold 104,000 units and had fixed costs of 121,370. All other...
-
how to conduct an external and internal company analysis. Conduct an external analysis of a company or organization of your choosing. Use all of the tools necessary to conduct a thorough evaluation...
-
How can organizations ensure the seamless integration of computerized accounting systems with other business processes, and what measures should be implemented to enhance the security and...
-
I need a detailed newsletter on the following topic: How do students apply for income tax? To get the benefits!!! I need references as well.
-
A 50 Hz, 3-phase induction motor has a full load speed of 1440 r.p.m. The number of poles of the motor are (A) 4. (C) 12. (B) 6. (D) 8.
-
You are a U.S. investor who purchased British securities for 2,000 one year ago when the British pound cost U.S. $1.50. What is your total return (based on U.S. dollars) if the value of the...
-
David and Darlene Jasper have one child, Sam, who is 6 years old. The Jaspers reside at 4639 Honeysuckle Lane, Los Angeles, CA 90248. David's Social Security number is 577-11-3311, Darlene's is...
-
Cedar Corporation has an S corporation election in effect. During the 2012 calendar tax year, the corporation had ordinary taxable income of $200,000, and on January 15, 2012, the corporation paid...
-
Quince Corporation has taxable income of $450,000 for its 2012 calendar tax year. Calculate the corporation's income tax liability for 2012 before tax credits. $_________
-
A container of an organic liquid a $25^{\circ} \mathrm{C}$ has a mass of $1100 \mathrm{~kg}$ and a volume of $0.94 \mathrm{~m}^{3}$. Find the liquid's weight, its density, and its specific gravity.
-
What is the pressure one mile $(1.6 \mathrm{~km})$ beneath the ocean's surface?
-
At what pressure will water boil at $65^{\circ} \mathrm{C}$ ? The vapor pressure of water can be determined from the Antoine equation: \[\frac{P(P a)}{1 \times...
Study smarter with the SolutionInn App