Database Third Normal Form Scenario A builder needs a database to keep track of contractors he hires for various projects So far we have this 2NF relation, with sample data shown Normalize to 3NF CONTRACTOR ( ConID, Lname, Fname, JobTitle, Company, Street, City, State, Zip, CompanyPhone, CellPhone ) ConID Lname Fname JobTitle Company Street City State Zip Phone CellPhone 2 Garcia Mary Carpenter Construct Co 123 Main Portland OR 97204 823 1234 645 5423 14 Jones Tomas Welder Construct Co 123 Main Portland OR 97204 823 1234 344 3475 8 Tanaka Bill Plumber Water Inc 456 21 st St Portland OR 97219 722 0045 805 7602

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

Question: Database Third Normal Form Scenario: A builder needs a database to keep track of contractors he hires for various projects. So far we have this

Database

Third Normal Form

Scenario: A builder needs a database to keep track of contractors he hires for various projects. So far we have this 2NF relation, with sample data shown. Normalize to 3NF.

CONTRACTOR ( # ConID, Lname, Fname, JobTitle, Company, Street, City, State, Zip, CompanyPhone, CellPhone )

ConID	Lname	Fname	JobTitle	Company	Street	City	State	Zip	Phone	CellPhone
2	Garcia	Mary	Carpenter	Construct Co	123 Main	Portland	OR	97204	823-1234	645-5423
14	Jones	Tomas	Welder	Construct Co	123 Main	Portland	OR	97204	823-1234	344-3475
8	Tanaka	Bill	Plumber	Water Inc	456 21^st St	Portland	OR	97219	722-0045	805-7602

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!

Database First Normal Form Scenario: An auto shop is designing a database to keep track of repairs. So far we have this UNF relation, with some sample data shown. Normalize to 1NF. REPAIRS ( # VIN,...

Database Second Normal Form Scenario: PCC needs to track grades received by students taking courses. So far we have this 1NF relation, with sample data shown. Normalize to 2NF. GRADES ( # GNumber, #...

A.3. Scenario, Background and Tasks Scenario need to submit the data modelling phase for this assignment by The implementation phase needs to be completed and submitted by Choice Appointments is a...

Question 1 ) ( 1 0 points ) In this question, you will delve deeper into the principles of database normalization by working with a more complex denormalized table. Your task is to transform the...

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

I don't get the question mean... Please explain what should I write down it... This question related to Case Study which is attach the file... The question is What aspects of the implementation and...

Introduction to Ridgeline Mountain Outfitters (RMO) Ridgeline Mountain Outfitters (RMO) is a large retail company that specializes in clothing and related accessories for all types of outdoor and...

Income Statement of an interior design firm, Grand Designs, that makes money by selling hours (fees) and by selling furniture or other items (Sale of Goods). 1) Using the formula for Profit Margin,...

How do you do 1NF, 2NF, and 3NF How many payments have been processed for any given policy to date? Hint: Draw an initial ERD for the text description then use view integration mechanisms to...

Cory and Ninoy are partners. They Share profits and losses at a ration of 2:3. If the capital of Cory is P16,800.00, how much is the capital of Ninoy? 2. For a certain recipe, Cris combines water and...

Explain Webers theory of bureaucracy.

Scenario 1 : Young Professional Saving for Retirement Alex is 2 5 years old and has just started their first full - time job. They want to start investing for retirement and won't need to access...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

KEY QUESTION Use the demand schedule to the upper right to calculate total revenue and marginal revenue at each quantity. Plot the demand, total-revenue, and marginal-revenue curves and explain the...

KEY QUESTION Suppose a pure monopolist is faced with the demand schedule shown below and the same cost data as the competitive producer discussed in question 4 at the end of Chapter

KEY QUESTION Use the following demand schedule to determine total revenue and marginal revenue for each possible level of sales: a. What can you conclude about the structure of the industry in which...