LEARN MORE...

Access Millions of academic & study documents

5 Youre exploring a database and you find some sample data in two

Content type
User Generated
Showing Page:
1/4
5. You\'re exploring a database and you find some sample
data in two tables:
Course
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

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/4
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 it’s 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?

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/4

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 4 pages?
Access Now
Unformatted Attachment Preview
5. You\'re exploring a database and you find some sample data in two tables: Course 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 it’s 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? 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 EN ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Documents

UCLA Design SDLC phase Designing the Human Interface Discussion
Using the guidelines from this discussion and other sources, evaluate the usability of the page design depicted in PE Desi...
SWOT Analysis
Week 5 Assignment - Learning Activity: SWOT AnalysisUsing the same health care organization identified in the first assign...
Japan's rise to power after World War 2, History Assignment Homework help
Please discuss Japan's rise back to power as a first-world country after the Second World War. How did they do it? How far...
Discussion Board
In the B2B environment, the rising complexities of managing a global business network are making channel unification strat...
Simple Data Analysis Project Using SAS, Must have SAS software! Only part 1
Review the attached instructions ( Data Analysis Project ) and complete part 1 of the project at this time. Use the attach...
Brighton High Wk 12 Addressing the Readmission Rates Discussion
You are the director of the ED and in the last 6 months, the readmission rate has increased by 25%. Your staffing numbers ...
Strategic Vision Discussion
The concepts for the future course and operations of the firm are known as strategic visions. They give precise informatio...
Img 20220727 175552
8. Match the items given in Column A with those given in Column B...
Psy 375 module one lab worksheet
Complete this template by replacing the bracketed text with the relevant information. All responses to lab questions shoul...