Question: Explore the data included in Table 4-9. Assume that the primary key of this relation consists of two components: Author's ID (AID) and Book number

Explore the data included in Table 4-9.

Assume that the primary key of this relation consists of two components: Author's ID (AID) and Book number (BNbr). The relation includes data regarding authors, books, and publishers. In addition, it tells what an individual author's per book royalty amount is in the case of multi-authored books.

Your task is to:

a. Identify the functional dependencies between the attributes.

b. Identify the normal form in which the relation currently is.

c. Identify the errors in the data that have been made possible by its poor structural characteristics.

d. Take the actions (if any) necessary to convert the relation into the third normal form. Identify all intermediate steps.

TABLE 4-9 Author Book Royalties AID ALname AFname Alnst 0 Gold BPublish PubCity wall &Chicago, I BPrice AuthBRoyalty $62.75 $6.28 BNbr BName 106 Javascript 102 Quick Mooile 104 Inrovative 106 JavaScript losh Sleepy Hallow U and HTML!5 Boston, MA $49.95 2.50 24 Shippen ary Green Smith Ca as, TX and Sons Wall & Indianapolis, IN vintage Grey Brothers Gray $158.65 $15.87 Daa Management and HTML5 Data Certers 2.75 S6.00 Boston, NH $50.00 $12.50 ston, MA 122.5 $12.30 Boston, MA $45.00 $2.25 32 0wan Jan Middlestate 126 Neworks and College 180 Server 102 Quck Mobile

Step by Step Solution

★★★★★

3.45 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Authors and their books a Functional dependencies b Current normal form The data has repeating group... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

613-CS-DB (1705).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Assume the Part table has been created, but there are no integrity constraints. Create the necessary integrity constraint to ensure that the only allowable values for the Class field are AP, HW, and...

The purpose of this exercise is to give you an opportunity to create the tables for Bearcat Incorporated. The tables themselves are based on the relations that appear in the following figure. L1:...

Using the assumptions you stated in your answer to question 2.35, what are the determinants of this relation? What attribute(s) can be the primary key of this relation?

================== DATABASE DESIGN PROBLEM. NOTE*: I have to help someone who is not physically here finish his assignment, but I've never learned anything about database. Show me the right way...

Explore the data included in Table 4-9. Assume that the primary key of this relation consists of two components: Authors ID (AID) and Book number BNbr). The relation includes data regarding authors,...

Explore the data included in Table 4-9. Assume that the primary key of this relation consists of two components: Author's ID (AID) and Book number (BNbr). The relation includes data regarding...

Explore the data included in Table 4-9. Assume that the primary key of this relation consists of two components: Authors ID (AID) and Book number (BNbr). The relation includes data regarding authors,...

Assume that the primary key of this relation consists of two components: author ID ( AID ) and book number ( BookNbr ) . Each author has an ID , last name, first name, and teaching institute. Each...

**CONVERT THE RELATION IN THE GIVEN TABLE INTO THE THIRD NORMAL FORM. Assume that the primary key of this table consists of two components: Authors ID (AID) and Book number (BNbr). The table includes...

Assume that the primary key of this table consists of two components: Author's ID (AID) and Book number (BNbr). The table includes data regarding authors, books, and publishers. In addition, it tells...

Find the interest rate for a $7000 deposit accumulating to $9250.64, compounded quarterly for 8 years.

DJ Car Rental wants to estimate the average miles traveled per day by each of its cars rented locally. A random sample of cars is selected with the following results Sample Size =110 Sample Mean =...

why is it important to correctly classify inventory costs ( for example, being sure to exclude expenses not required to bring an item to a salable condition ) ? What could go wrong if we don't?

Figure 2 shows the market for on-campus housing. If a price cap is set at $600 a month, what is the rent and the number of apartments rented?

Consider the following two transactions: T1: read (A); read (B); if A = 0then B: = B + 1; write (B). T2: read (B); read (A); if B = 0 then A: = A + 1; write (A). Let the consistency requirement be A...

Since every conflict-serializable schedule is view serializable, why do we emphasize conflict serializability rather than view serializability?

Consider the precedence graph of Figure is the corresponding schedule conflict serializable? Explain your answer. T2 T1 T4 T5

If you want to be paid from a 1 5 year ordinary annuity with a guaranteed rate of 2 . 3 0 6 % compounded annually, how much should you pay for one of these annuities if you want to receive annual...

The Michner Corporation is trying to choose between the following two mutually exclusive design projects: Cash Flow (1) -$ 91,000 40,900 51,000 31,000 Year 0 1 2 3 a-1. If the required return is 14...

Under the corporate form of business organization the corporation's life is continuous. a shareholder is personally liable for the debts of the corporation. agent of the corporation a shareholder's...