Question: You're exploring a database and you find some sample data in two tables: courseNum credits textbookTitle author COP4710 4 Database Systems Jones COP4711 4 Database

You're exploring a database and you find some sample data in two tables:

courseNum credits textbookTitle author
COP4710 4 Database Systems Jones
COP4711 4 Database Systems Jones
COP4720 4 Data Algorithms Jones
MAT1001 3 College Algebra Watson
MAT1002 4 College Algebra Watson
ENG4267 4 Materials Smith
ENG4280 3 Materials Smith

Textbook

title author qty price
Database Systems Jones 10 125.99
Data Algorithms Jones 6 75.50
College Algebra Watson 21 60.00
Materials Smith 9 74.25
Materials Edwards 3 99.99

The Textbook table uses a natural key, the combination of title and author.

The same combination of columns is in the Course table where its a foreign key.

(a) Since (title, author) is the primary key of Textbook and a foreign key in Course, is the repeated paring of title and author in the Course table a redundancy?

(b) If the Textbook table had a surrogate key instead of a natural one, do you think it would improve the Course table, or would it make no difference?

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!

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

What are the methodology and findings of used in this article? 1204 Y. JIA, L. VAN LENT, AND Y. ZENG within a sample of men." Pound, Penton-Voak, and Surridge [2009] also report that circulating...

Q:

CUSTOMER RELATIONSHIP MANAGEMENT: ITS DIMENSIONS AND EFFECT ON CUSTOMER OUTCOMES Frederick Hong-kit Yim, Rolph E. Anderson, and Srinivasan Swaminathan Despite the rapidly growing customer...

Q:

Jim Watanabe, assistant director of IT for Petrie Electronics, and the manager of the No Customer Escapes customer loyalty system project, was walking down the hall from his office to the cafeteria....

Q:

Jim Watanabe, assistant director of IT for Petrie Electronics, and the manager of the No Customer Escapes customer loyalty system project, was walking down the hall from his office to the cafeteria....

Q:

Jim Watanabe, assistant director of IT for Petrie Electronics, and the manager of the No Customer Escapes customer loyalty system project, was walking down the hall from his office to the cafeteria....

Q:

Jim Watanabe, assistant director of IT for Petrie Electronics, and the manager of the No Customer Escapes customer loyalty system project, was walking down the hall from his office to the cafeteria....

Q:

Jim Watanabe, assistant director of IT for Petrie Electronics, and the manager of the "No Customer Escapes" customer loyalty system project, was walking down the hall from his office to the...

Q:

A physical query plan is like a routine that the DBMS follows to assemble the requested query results from the underlying base tables. Different queries will have different physical plans. in fact,...

Q:

129 CHAPTER 2 Introduction to Structured Query Language James Morgan owns and operates Morgan Importing, which purchases antiques and home furnishings in Asia, ships those items to a warehouse...

Q:

Five Years Ago Leslie Had $23460 In Her Saving Account Today She Deposited An Additional $6,000 She Plans To Deposit Another $6,000 Into This Account Next Year How Much Money Will She Have In Her...

Q:

Kevin operates a floral retail store as a sole proprietorship. During the tax year 2018, he had a net profit of $150,000. What is the correct amount of his self-employment tax?

Q:

Which of these shows the inflows and outflows of cash for a business? Group of answer choices income statement revenue statement cash flow statement balance sheet

Q:

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

Q:

___ 23. I have been most fulfilled in my career when I have solved seemingly unsolvable problems or won out over seemingly impossible odds.

Q:

___ 15. I will feel successful in my career only if I face and overcome very difficult challenges.

Q:

___ 16. I dream of a career that will permit me to integrate my personal family and work needs.