Computer Science: An Overview (13th Edition) (What's New in Computer Science)
13th Edition
ISBN: 9780134875583
Author: BROOKSHEAR
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 solution
Students have asked these similar questions
According to the given table, who is the secretary in the accounting department with experience in the personnel department?
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…
In the figure below, STUDENT relation has a composite primary key contains Stud_ID and Course_ID. This relation is
STUDENT
Stud ID
Name
Course ID
Units
101
Lennon
MSI 250
3.00
101
Lennon
MSI 415
3.00
125
Johnson
MSI 331
3.00
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
- Consider the following database with the below relations: customer-street 12 Alma St. 4 North St. 3 Main St. 123 Putnam Ave. 100 Main St. 175 Park Ave. 72 North St. (a) The customer table customer-id customer-name N192-83-7465 Johnson 019-28-3746 Smith 677-89-9011 Hayes 182-73-6091 Turner 321-12-3123 Jones 336-66-9999 Lindsay 019-28-3746 Smith account-number A-101 A-215 A-102 balance 500 700 400 350 900 A-305 A-201 A-217 750 A-222 700 (b) The account table a 34 customer-city Palo Alto Rye customer-id 192-83-7465 192-83-7465 019-28-3746 677-89-9011 182-73-6091 321-12-3123 336-66-9999 019-28-3746 Harrison Stamford Harrison Pittsfield Rye account-number A-101 A-201 A-215 A-102 A-305 A-217 A-222 A-201 (c) The depositor table What is the difference between SQL and relational algebra? ( In SQL Environment, what is the difference between DDL and DML ( Write the Relational algebra expressions (using the relational algebra operators: p, σ, TT, ▷, X) for each of the following queries ( a. List…arrow_forwardWhat’s the difference between correlated and uncorrelated subqueries?arrow_forwardBased on the above Relations/Tables, write description of violations of each of the 3-constrains in the table given below: Just answer without explanation please.arrow_forward
- Find the relation algebra query based on the SQL given.arrow_forwardpart a please fastarrow_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
- Question Consider the following Customers table and express in relational algebra each of the questions below: Customers customerNO Name Address City Zip 100 Salma Amri Street freedom Muscat 213 101 Ayman Zawamri Street 11 September Nizwa 210 102 Said Raafit Street 13 October Salalah 211 103 Salem Samri Street Yasamine Sur 205 List the names of customers who are from the city of “Muscat”. List the details of customers who are not from “Nizwa”. List the names and addresses of customers having the numbers 101 or 103.arrow_forwardWhat distinguishes correlated subqueries from uncorrelated ones, and how can I identify the difference?arrow_forwardIn the Summary sheet, calculate average and median sales and commissions. Use the named ranges shown in cells A23:B26. In cell B5, enter a formula to calculate the average annual sales for all sales associates. Use the named range AnnualSales.arrow_forward
- The relational database below contains two related tables - “Supplier” and “Product”: “Product” table: Primary key = Prod-code, Foreign key = Supp-code Prod-code Prod -name Prod -desript Prod -stocktype Prod -stocklevel Prod -expireDate Supp-code 10010 aaa qwert 615 123445677 2017-11-14 501 10011 bbb asdfgg 615 234567899 2017-11-16 501 10012 ccc zxxcvv 234 345678900 2017-11-13 502 10013 eee ytuytu 234 454577777 2017-10-13 503 10014 jjj werewr 231 436436885 2017-10-23 503 10015 sdg rtyrtyry 275 676446322 2017-10-30 504 10016 ewt erterter 789 232317879 2017-12-30 501 “Supplier” table: Primary key = Supp -code, No Foreign key Supp -code Supp -lname Supp -fname Supp -Initial Supp -areacode Supp -phone 501 xxx qwert F 615 123445678 502 yyy asdfgg B 615 234567890 503 zzz zxxcvv X 234 345678901…arrow_forwardThe relational database below contains two related tables - “Supplier” and “Product”: “Product” table: Primary key = Prod-code, Foreign key = Supp-code Prod-code Prod -name Prod -desript Prod -stocktype Prod -stocklevel Prod -expireDate Supp-code 10010 aaa qwert 615 123445677 2017-11-14 501 10011 bbb asdfgg 615 234567899 2017-11-16 501 10012 ccc zxxcvv 234 345678900 2017-11-13 502 10013 eee ytuytu 234 454577777 2017-10-13 503 10014 jjj werewr 231 436436885 2017-10-23 503 10015 sdg rtyrtyry 275 676446322 2017-10-30 504 10016 ewt erterter 789 232317879 2017-12-30 501 “Supplier” table: Primary key = Supp -code, No Foreign key Supp -code Supp -lname Supp -fname Supp -Initial Supp -areacode Supp -phone 501 xxx qwert F 615 123445678 502 yyy asdfgg B 615 234567890 503 zzz zxxcvv X 234 345678901…arrow_forwardWhat is a relation?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr