Consider the following relation: CAR_SALE(Car#, Date_sold, Salesman#, Commision%, Discount_amt Assume that a car may be sold by
Question:
CAR_SALE(Car#, Date_sold, Salesman#, Commision%, Discount_amt
Assume that a car may be sold by multiple salesmen and hence {CAR#, SALESMAN#} is the primary key. Additional dependencies are:
Date_sold ->Discount_amt and
Salesman# ->commission%
Based on the given primary key, is this relation in 1NF, 2NF, or 3NF? Why or why not? How would you successively normalize it completely?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 90% (11 reviews)
Given the relation schema CarSale Car Salesman Dates...View the full answer
Answered By
Ali Khawaja
my expertise are as follows: financial accounting : - journal entries - financial statements including balance sheet, profit & loss account, cash flow statement & statement of changes in equity -consolidated statement of financial position. -ratio analysis -depreciation methods -accounting concepts -understanding and application of all international financial reporting standards (ifrs) -international accounting standards (ias) -etc business analysis : -business strategy -strategic choices -business processes -e-business -e-marketing -project management -finance -hrm financial management : -project appraisal -capital budgeting -net present value (npv) -internal rate of return (irr) -net present value(npv) -payback period -strategic position -strategic choices -information technology -project management -finance -human resource management auditing: -internal audit -external audit -substantive procedures -analytic procedures -designing and assessment of internal controls -developing the flow charts & data flow diagrams -audit reports -engagement letter -materiality economics: -micro -macro -game theory -econometric -mathematical application in economics -empirical macroeconomics -international trade -international political economy -monetary theory and policy -public economics ,business law, and all regarding commerce
4.00+
1+ Reviews
10+ Question Solved
Related Book For
Fundamentals of Database Systems
ISBN: 978-0136086208
6th edition
Authors: Ramez Elmasri, Shamkant Navathe
Question Posted:
Students also viewed these Computer Sciences questions
-
This exercise asks you to converting business statements into dependencies. Consider the following relation DiskDrive(serialNumber, manufacturer, model, batch, capacity, retailer). Each tuple in the...
-
Consider the following relation for published books: BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publisher) Author_affil referes to the affiliation of the author. Suppose the...
-
Consider the following relation instance of the CAR relation schema: a. What is the minimal cover of functional dependencies that exists in CAR? b. What is (are) the candidate key(s) of CAR? c. If...
-
Builder Products, Incorporated, uses the weighted-average method in its process costing system. It manufactures a caulking compound that goes through three processing stages prior to completion....
-
The following information was taken from the ledger of Jefferson Industries, Inc.: Prepare the following: a. A schedule of cost of goods manufactured for the year ended December 31. b. An income...
-
For the data set in Example 2, find the percentile that corresponds to $34,000. Data from Example 2 The tuition costs (in thousands of dollars) for 25 liberal arts colleges are listed. Use technology...
-
For case 2 in Exercise 1, which country would prefer an international terms of trade of 1.2 rather than an international price of 1.66? Explain. Data from in exercise 1 For each of the following...
-
The pull strength of a wire bond is an important characteristic. The following table gives information on pull strength (y), die height (x1), post height (x2), loop height (x3), wire length (x4),...
-
Develop a strategic business plan. The CEO of the real estate agent has given new directives regarding the increase of average profit annually. You, as a manager, have been given a job to analyse...
-
The idea for Honest Tea came about in 1997, when Yale School of Management graduate Seth Goldman stopped for a post-workout beverage at a local convenience store. Finding only soft drinks and teas...
-
Consider the relation: BOOK (Book_Name, Author, Edition, Year) with the data: a. Based on a common-sense understanding of the above data, what are the possible candidate keys of this relation? b....
-
What update anomalies occur in the EMP_PROJ and EMP_DEPT relations of Figure 15.3 and 15.4?
-
In the market for coffee, the elasticity of demand is estimated to be -0.6 and the elasticity of supply is estimated to be 1.2. If the government imposes a $1 tax on each cup of coffee sold, what...
-
There is an athletic organization named Jingle Jangle plans to invest P1,000,000 to host soccer game. They expect to sell tickets worth P1,500,000 .However, if it rains on the day of game, they won't...
-
Duarte Mfg. Corp. splits its manufacturing operations into profit centers by product line. One such pro center manufactures a product, the P222, with production costs per unit based on a normal...
-
Use the terms (provided in the table) to describe each representation of functions. FUNCTION PLACEMATS r + y =9 y=r+1 y= T20 -7 <0 #
-
Your firm, ACTG 307 & Associates, is engaged to audit the financial statements of XYZ Corporation. It is a private manufacturing company that is considering going public in three to four years. Your...
-
5n 0 = -5 rad, (a) Suppose 0 = 13 rad, 5 m, and 2 = 7 m. 18 Sketch the orientation of the robot in the x-y plane, and determine the x-y coordinates of point P. (b) Suppose now that the same robot is...
-
Templeton Company sponsors a defined contribution pension plan for its employees. The plan specifies that the company will contribute $2 for every dollar that an employee contributes to the plan....
-
The following processes constitute the air-standard Diesel cycle: 12: isentropic compression,23: constant-volume energy addition (T and P increase),34: constant-pressure energy addition (v...
-
What are storage area networks? What flexibility and advantages do they offer?
-
What are the highlights of the popular RAID levels 0, 1, and 5?
-
What characterizes the levels in RAID organization?
-
Jun. 3 Purchased inventory on account with credit terms of 4/10, n/EOM, $2,100. 9 Returned 30% of the inventory purchased on June 3. It was defective. 12 Sold goods for cash, $940 (cost, $564). 15...
-
Jorge and Anita, married taxpayers, earn $151,600 in taxable income and $40,400 in interest from an investment in City of Heflin bonds. Using the U.S. tax rate schedule for married filing jointly,...
-
How does the design of change interventions account for contextual factors such as organizational culture, leadership style, and readiness for change, as they tailor intervention strategies,...
Study smarter with the SolutionInn App