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?
-
Troy (single) purchased a home in Hopkinton, MA on January 1, 2007 for $300,000. He sold the home on January 1, 2014 for $320,000. How much gain must Troy recognize on his home sale in each of the...
-
Answer the below questions. (a) Assume that the swap rate for an interest-rate swap is 7% and that the fixed-rate swap payments are made quarterly on an actual / 360 basis. If the notional amount of...
-
When a company uses the straight-line depreciation method for financial reporting purposes and an accelerated depreciation method for tax purposes, what is the result? a. a deferred tax asset b. a...
-
Neely, Inc., is preparing its direct labor budget for 2010 from the following production budget based on a calendar year. Each unit requires 1.6 hours of direct labor.InstructionsPrepare a direct...
-
?A company sells 1 0 0 0 ?units of a product annually with a cost per order of Rs 5 0 ?and a carrying cost of Rs 2 ?per unit per year . ?Calculate the EOQ . ?How many times in a year company need to...
-
John Henderson's will provides for the creation of a trust for the benefit of Holly Jones. Under the specific terms, the trust is required to distribute to Holly $50,000 cash and 1,000 shares of IBM...
-
At January 1, 2024, Caf Med leased restaurant equipment from Crescent Corporation under a nine-year lease agreement. The lease agreement specifies annual payments of $32,000 beginning January 1,...
-
Bob and Sally, unmarried taxpayers, each owned 50% of Lostalot, Inc., an S corporation. The corporation had a $50,000 operating loss for the tax year ending December 31, 2023. As of December 31,...
-
What are the key considerations in crafting inclusive language policies within organizational communication strategies, and how do these policies promote diversity, equity, and inclusivity in the...
-
What methodologies and tools are utilized to monitor and evaluate consistency metrics, such as variance analysis and deviation tracking, and how are these insights utilized to inform strategic...
-
Provide a summary of aural strategy style according the VARK questionnaire. 2. Describe your preferred learning strategies. Compare your current preferred learning strategies to the identified...
-
includes any criminal activity which involves the unauthorized access, dissemination, manipulation, destruction, or corruption of electronically stored data. Identity theft Digital crime Organized...
-
On January 1, a company borrowed cash by issuing a $400,000, 8%, installment note to be paid in three equal payments at the end of each year beginning December 31. (FV of $1, PV of $1, FVA of $1, PVA...
-
Tiger, Inc. signed a lease for equipment on July 1, 2007.The lease is for 10 years (the useful life of the asset).The first of 10 equal annual payments of $500,000 was made on July 1, 2007.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. $_________
-
(Multiple IRRs) You would like to open an investment company named Ripem. The cost of building up the company is $750,000. You offer your clients the following deal: For five annual deposits of...
-
Internal Control for Sales} Johnson Tires has three stores. Each store manager is paid a salary plus a bonus on the sales made by his or her store. On January 5, 2019, Kevin Samuel, manager of one of...
-
(Mutually exclusive projects) The following projects are offered to you. The annual cash flows are expected to continue forever. a. What is the IRR of each project? b. If the cost of capital is 7%,...
Study smarter with the SolutionInn App