Computer Science: An Overview (13th Edition) (What's New in Computer Science)
13th Edition
ISBN: 9780134875460
Author: Glenn Brookshear, Dennis Brylow
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 28CRP
Program Plan Intro
Relational
The relational database model drafts data in the same way as stored in rectangular tables. The data is called relations. The rows in relation table are called tuples and columns are called attributes.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Convert the following unnormalized relation to fourth normal form using the requirements (many sales reps can represent one customer and one sales rep can represent many customers)
Set up relationships (determining foreign keys) bymapping your ER/EER to relations and showing whatare FK and PK in your relations.
The following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. You may assume the data are representative.
PATIENT ID
PATIENT NAME
PATIENT DOB
CONSULT DATE
ITEM NUMBER
ITEM DESCRIPTION
FEE
PROVIDER NUMBER
DOCTOR NAME
437
REARDON
4/08/1989
19/7/2020
A012
Standard
56
S55768
Leahy
437
REARDON
4/08/1989
20/7/2020
A012
Standard
56
D42433
Meuller
562
BILSTEIN
12/05/2001
20/7/2020
A013
Short
35
S55768
Leahy
361
WILSON
13/08/1997
20/7/2020
A014
Long
75
S55768
Leahy
895
LEMOS
13/10/1952
20/7/2020
A013
Short
35
D42433
Meuller
895
LEMOS
13/10/1952
20/7/2020
A014
Long
75
D42433
Meuller
678
MORTAL
27/02/1969
20/7/2020
A014
Long
75
S55768
Leahy
432
SOAPIER
1/08/1976
21/7/2020
A012
Standard
56
S55768
Leahy
You have been asked to design a…
Chapter 9 Solutions
Computer Science: An Overview (13th Edition) (What's New in Computer Science)
Ch. 9.1 - Identify two departments in a manufacturing plant...Ch. 9.1 - Prob. 2QECh. 9.1 - Summarize the roles of the application software...Ch. 9.2 - Prob. 1QECh. 9.2 - Prob. 2QECh. 9.2 - Prob. 4QECh. 9.2 - Prob. 5QECh. 9.2 - Prob. 6QECh. 9.3 - Prob. 1QECh. 9.3 - What is a persistent object?
Ch. 9.3 - Identify some classes as well as some of their...Ch. 9.3 - Prob. 4QECh. 9.4 - Prob. 1QECh. 9.4 - Prob. 2QECh. 9.4 - Prob. 3QECh. 9.4 - Prob. 4QECh. 9.4 - Prob. 5QECh. 9.4 - Prob. 6QECh. 9.5 - Prob. 1QECh. 9.5 - Prob. 2QECh. 9.5 - Prob. 3QECh. 9.5 - Prob. 4QECh. 9.5 - Prob. 5QECh. 9.5 - Prob. 6QECh. 9.5 - Prob. 7QECh. 9.6 - Prob. 1QECh. 9.6 - Give an additional example of a pattern that might...Ch. 9.6 - Prob. 3QECh. 9.6 - How does data mining differ from traditional...Ch. 9.7 - Prob. 1QECh. 9.7 - Prob. 2QECh. 9.7 - Prob. 3QECh. 9.7 - Prob. 4QECh. 9 - Prob. 1CRPCh. 9 - Prob. 2CRPCh. 9 - Prob. 3CRPCh. 9 - Prob. 4CRPCh. 9 - Prob. 5CRPCh. 9 - Prob. 6CRPCh. 9 - Prob. 7CRPCh. 9 - Prob. 8CRPCh. 9 - Prob. 9CRPCh. 9 - Prob. 10CRPCh. 9 - Prob. 11CRPCh. 9 - Prob. 12CRPCh. 9 - Using the commands SELECT, PROJECT, and JOIN,...Ch. 9 - Answer Problem 13 using SQL. PROBLEM 13 13. Using...Ch. 9 - Prob. 15CRPCh. 9 - Prob. 16CRPCh. 9 - Prob. 17CRPCh. 9 - Prob. 18CRPCh. 9 - Prob. 19CRPCh. 9 - Empl Id Name Address SSN Job Id Job Title Skill...Ch. 9 - Empl Id Name Address SSN Job Id Job Title Skill...Ch. 9 - Prob. 22CRPCh. 9 - Prob. 23CRPCh. 9 - Prob. 24CRPCh. 9 - Prob. 25CRPCh. 9 - Write a sequence of instructions (using the...Ch. 9 - Prob. 27CRPCh. 9 - Prob. 28CRPCh. 9 - Prob. 29CRPCh. 9 - Prob. 30CRPCh. 9 - Prob. 31CRPCh. 9 - Prob. 32CRPCh. 9 - Prob. 33CRPCh. 9 - Prob. 34CRPCh. 9 - Prob. 35CRPCh. 9 - Prob. 36CRPCh. 9 - Prob. 37CRPCh. 9 - Prob. 38CRPCh. 9 - Prob. 39CRPCh. 9 - Prob. 40CRPCh. 9 - Prob. 41CRPCh. 9 - Prob. 42CRPCh. 9 - Prob. 43CRPCh. 9 - Prob. 44CRPCh. 9 - Prob. 45CRPCh. 9 - Prob. 46CRPCh. 9 - Prob. 47CRPCh. 9 - Prob. 48CRPCh. 9 - Prob. 49CRPCh. 9 - Prob. 50CRPCh. 9 - Prob. 51CRPCh. 9 - Prob. 52CRPCh. 9 - Prob. 53CRPCh. 9 - Prob. 54CRPCh. 9 - Prob. 55CRPCh. 9 - Prob. 56CRPCh. 9 - Prob. 57CRPCh. 9 - Prob. 58CRPCh. 9 - Prob. 59CRPCh. 9 - Prob. 60CRPCh. 9 - Prob. 61CRPCh. 9 - Prob. 62CRPCh. 9 - Prob. 1SICh. 9 - Prob. 2SICh. 9 - Prob. 3SICh. 9 - Prob. 4SICh. 9 - Prob. 5SICh. 9 - Prob. 6SICh. 9 - Prob. 7SICh. 9 - Prob. 8SICh. 9 - Prob. 9SICh. 9 - Prob. 10SI
Knowledge Booster
Similar questions
- Relation. Questionarrow_forwardThe following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. Assume the data are representative. PATIENT ID PATIENT NAME PATIENT DOB CONSULT DATE ITEM NUMBER ITEM DESCRIPTION FEE PROVIDER NUMBER DOCTOR NAME 437 REARDON 4/08/1989 19/7/2020 A012 Standard 56 S55768 Leahy 437 REARDON 4/08/1989 20/7/2020 A012 Standard 56 D42433 Meuller 562 BILSTEIN 12/05/2001 20/7/2020 A013 Short 35 S55768 Leahy 361 WILSON 13/08/1997 20/7/2020 A014 Long 75 S55768 Leahy 895 LEMOS 13/10/1952 20/7/2020 A013 Short 35 D42433 Meuller 895 LEMOS 13/10/1952 20/7/2020 A014 Long 75 D42433 Meuller 678 MORTAL 27/02/1969 20/7/2020 A014 Long 75 S55768 Leahy 432 SOAPIER 1/08/1976 21/7/2020 A012 Standard 56 S55768 Leahy Design a relational database for this…arrow_forwardThe following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. Assume the data are representative. PATIENT ID PATIENT NAME PATIENT DOB CONSULT DATE ITEM NUMBER ITEM DESCRIPTION FEE PROVIDER NUMBER DOCTOR NAME 437 REARDON 4/08/1989 19/7/2020 A012 Standard 56 S55768 Leahy 437 REARDON 4/08/1989 20/7/2020 A012 Standard 56 D42433 Meuller 562 BILSTEIN 12/05/2001 20/7/2020 A013 Short 35 S55768 Leahy 361 WILSON 13/08/1997 20/7/2020 A014 Long 75 S55768 Leahy 895 LEMOS 13/10/1952 20/7/2020 A013 Short 35 D42433 Meuller 895 LEMOS 13/10/1952 20/7/2020 A014 Long 75 D42433 Meuller 678 MORTAL 27/02/1969 20/7/2020 A014 Long 75 S55768 Leahy 432 SOAPIER 1/08/1976 21/7/2020 A012 Standard 56 S55768 Leahy Design a relational database for this…arrow_forward
- Using relation below y=y+pow(-x,i)/factorial(i) ;arrow_forwardReview the SaleItem relation below where ItemNumber plus OrderNumber is the primary key. What type of primary key does this relation have? SALEITEM (ItemNumber, OrderNumber, Quantity, Price) Group of answer choices Composite primary key Surrogate primary key Transitive primary key Alternate primary keyarrow_forwardThe following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. You may assume the data are representative. PATIENT ID PATIENT NAME PATIENT DOB CONSULT DATE ITEM NUMBER ITEM DESCRIPTION FEE PROVIDER NUMBER DOCTOR NAME 437 REARDON 4/08/1989 19/7/2020 A012 Standard 56 S55768 Scott 437 REARDON 4/08/1989 20/7/2020 A012 Standard 56 D42433 Mueller 562 BILSTEIN 12/05/2001 20/7/2020 A013 Short 35 S55768 Scott 361 WILSON 13/08/1997 20/7/2020 A014 Long 75 S55768 Scott 895 LEMOS 13/10/1952 20/7/2020 A013 Short 35 D42433 Mueller 895 LEMOS 13/10/1952 20/7/2020 A014 Long 75 D42433 Mueller 678 MORT 27/02/1969 20/7/2020 A014 Long 75 S55768 Scott 432 SOAPIER 1/08/1976 21/7/2020 A012 Standard 56 S55768 Scott You have been asked to design a…arrow_forward
- Describe the differences in meaning between the terms relation and relation schema.arrow_forwardTable_1 below has a primary key of column1. Which column(s) from this relation could be a foreign key in another, related relation? Check all that qualify. Generic Relation column1 column2 column3 column4 100 19.99 cde A 200 23.78 klj D 300 77.43 qnw B Group of answer choices column2 any of the columns in the table could be a foreign key column4 column3 column1arrow_forwardconvert it to relations that are normalizationarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education