Question: 2. For the following two relations below (A and B) (40pts): 1) Determine what normal form it is currently in 2) Explain why it's in

2. For the following two relations below (A and B) (40pts): 1) Determine what normal form it is currently in 2) Explain why it's in that normal form (and not others) 3) Do what is necessary to get it into 3NF if it's not already there. (A) Class (Course, Inst, Course Name, Class Time, InstructorLastName) Functional Dependency: Course# --> Course Name Functional Dependency: Inst# --> InstructorLastName Functional Dependency: Course and Inst# --> Class Time (B) Sales (Sales Number, Sales Date, Salesrep#, SalesrepLastName) Functional Dependency: Sales Number --> SalesDate, SalesRep# SalesrepLastName Functional Dependency: Salesrep# --> SalesreplastName

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 General Management Questions!

How would one create deliverable 1 in 3rd Normal form? Thanks! CIS3050-03 Project 1 - Protected View- Saved to this PC ApacheWarloed OfTheSouth-X File Home Insert Draw Design Layout References...

Please workexercise 2-6 thru 2-12, chapter 2 pages and work template attached. CHAPTER 2 THE FINANCIAL STATEMENTS CHAPTER LEARNING OBJECTIVES Upon completion of this chapter, you should be able to:...

Need the required for exercise2-5 thru 2-16 for year 2014 per provided information on attachement. CHAPTER 2 THE FINANCIAL STATEMENTS CHAPTER LEARNING OBJECTIVES Upon completion of this chapter, you...

Please help with the following questions!! Thank you in advance Lesson 6.1: Graphs of Relations Workbook 6A Lesson 6.1: Graphs of Relations Explore Your Understanding Assignment 1. The graph shows...

does anyone know how to put this information into a form 1040 and schedules 1,2,3? repostinng the info becasue some one said it was "unclear" this is everything i was given & she said to put this...

1. Find the equation of the line, and write the equation in the specified form. Be sure to define your parameter(s) if applicable (a) the line parallel to m = (1, 3) and passes through the point (7,...

QUESTION 1 In the lease versus buy decision, leasing is often preferable A. because the lessee owns the property at the end of the least term. B. because lease obligations do not affect the firm's...

AND 1. THE USE OF CALCULATORS SPREAASHEETS 2. PLEASE MAKE SURE TO WRITE Stolal ANSWER EXPLANATIONS THAT ARE SUPPORTED BY YOUR CALCULATIONS deep AsE OuESTION 3. PLEASE USE EXCEL TO CALCULATE AND SHOW...

This question concerns the portrayal of parse tree hubs for articulations made out of number constants, identififiers, and whole number administrators for expansion, deduction, increase and division....

2Project 02 Using Linear Programming to Make Business 3Decisions chairs, rocking chairs, chaise lounges, and large tables. Each piece of furniture passes through three different departments:...

When fixed costs are $90,000 and variable costs are 70% of the selling price, then breakeven sales se Pound the final answer to the nearest dollar.) $117.000 $300,000 $128,571 $153,000

answer this 8. The language used in a business report should be factual, timely, direct and ) concise ) complex C) personal O stylish

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...