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 data regarding authors, books, and publishers In addition, it tells what an individual authors per book royalty amount is in the case of multi authored books 1) Covert the table to a relation if it is not a relation already, 2) Show the functional dependency among all the attributes 3) covert the relation into the third normal form AID ALname AFname Alnst BNbr BName BPublish PubCity BPrice AuthBRoyalty 10 Gold Josh Sleepy Hollow U 106 JavaScript and HTML5 Wall Vintage Chicago, IL $62 75 $6 28 102 Quick Mobile Apps Gray Brothers Boston, MA $49 95 $2 50 24 Shippen Mary Green Lawns U 104 Innovative Data Management Smith and Sons Dallas, TX $158 65 $15 87 106 JavaScript and HTML5 Wall Vintage Chicago, IL $62 75 $6 00 32 Oswan Jan Middlesgate College 126 Networks and Data Centers Gray Brothers Boston, MA $250 00 $12 50 180 Server Infrastructure Gray Brothers Boston, MA $122 85 $12 30 102 Quick Mobile Apps Gray Brothers Boston, MA $49 95 $2 25 THANK YOU

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

Question: **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

**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 data regarding authors, books, and publishers. In addition, it tells what an individual authors per book royalty amount is in the case of multi-authored books.

1) Covert the table to a relation if it is not a relation already,

2) Show the functional dependency among all the attributes

3) covert the relation into the third normal form.

AID	ALname	AFname	Alnst	BNbr	BName	BPublish	PubCity	BPrice	AuthBRoyalty
10	Gold	Josh	Sleepy Hollow U	106	JavaScript and HTML5	Wall & Vintage	Chicago, IL	$62.75	$6.28
				102	Quick Mobile Apps	Gray Brothers	Boston, MA	$49.95	$2.50
24	Shippen	Mary	Green Lawns U	104	Innovative Data Management	Smith and Sons	Dallas, TX	$158.65	$15.87
				106	JavaScript and HTML5	Wall & Vintage	Chicago, IL	$62.75	$6.00
32	Oswan	Jan	Middlesgate College	126	Networks and Data Centers	Gray Brothers	Boston, MA	$250.00	$12.50
				180	Server Infrastructure	Gray Brothers	Boston, MA	$122.85	$12.30
				102	Quick Mobile Apps	Gray Brothers	Boston, MA	$49.95	$2.25

THANK YOU

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 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...

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...

The employee is table, the best candidate for primary key is Select one: a. Department ID b. Employee hiredate c. Employee ID d. Employee salary Question 2 A primary key can be composed of more than...

INFOAP2 Database Design Study Block Project The University Boole Library Database Modelling Project The University Boole Library has approximately 19,000, members, 200,000 book titles, and 500,000...

Briefly describe the following terms: Well-structured relation Normalization Functional dependency Describe conditions which imply a relation is in the third normal form. Below table shows a portion...

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...

Complete the Bits Corporation exercises 1-6 containing red Advisorricum A of y. nasional and that 1. Comment and **. The following spendencies b pendencies that is a ble to an equivalent ie to an...

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

Questions 1 and 2 in this part relate to the ER model given below. The ER model illustrates the entities and relationships for modeling a stock research fine. Assume the firm has two types of staff ?...

Figare 3 Cas Drawer Sommary Sined Restaurant and Catering Services Sally Jones, restaurant manager, supervises 10-20 full- and part-time individuals who provide breakfast, lunch, and light dinner...

The probability of an operator entering alphanumeric data incorrectly into a field in a database is equally likely. The random variable X is the number of fields on a data entry form with an error....

Write a 1 to 2 page essay exploring how personal habits, stress, and health interact; discuss the difference in the medical model's view of health and the view of the biopsychosocial model; and...

3. Fill-In Questions GDP - ____________ = NDP. (LO2)

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

(Appendices) COMPONENTS OF COST OF GOODS SOLD. Annas Corner Store has the following data for a recent year. LO9

(Appendices) TERMS OF SHIPMENT AND ENDING INVENTORY. On December 31, Archive Products had two shipments of merchandise in transit from different suppliers. The first shipment, which arrived on...

(Appendices) PURCHASES, SALES, AND COST OF GOODS SOLD. The following data were available for Jeans Inc., a seller of denim clothing, at January 1 of a recent year: Jeans Inc. records purchases and...