Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 3, Problem 14P
Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Do the tables exihibit referential integrity.Answer yes or no, and then explain your answer.Write NA if the table does not have a foreign key.
Do the tables exihibit referential integrity.Answer yes or no, and then explain your answer.
The option for referential integrity between the Owner table and the Pet table is cascade and an attempt is made to update the row for Owner 005 in the Owner table (OwnerNum = 005) to have a new OwnerNum of 500. What is the result? (Use only the data in the question. Do not assume other data exists if it is not present in the tables below.) The primary keys are underlined. These are the OwnerNum column in the Owner table and the PetNumber in the Pet table. The foreign key is italicized. This is the OwnerNum column in the Pet table.
Owner Table
OwnerNum
LastName
FirstName
Address
City
State
Zip
005
Smith
Jim
100 Main
Dune
FL
37465
009
Jones
Jane
3245 West
Sanford
FL
32773
012
Johnson
Frank
2 Century
Easton
FL
37256
020
Doe
Sally
101 Basel
Orange
FL
30998
Pet Table
PetNumber
PetName
DOB
Species
OwnerNum
100
Fido
1/1/2005
Canine
009
200
Ajax
12/3/2003
Canine
020
300
Sunshine
6./12/2004…
Chapter 3 Solutions
Database Systems: Design, Implementation, & Management
Ch. 3 - What is the difference between a database and a...Ch. 3 - Prob. 2RQCh. 3 - Prob. 3RQCh. 3 - What are the requirements that two relations must...Ch. 3 - Which relational algebra operators can be applied...Ch. 3 - Explain why the data dictionary is sometimes...Ch. 3 - A database user manually notes that The file...Ch. 3 - Prob. 8RQCh. 3 - Prob. 9RQCh. 3 - Prob. 10RQ
Ch. 3 - Prob. 11RQCh. 3 - Prob. 12RQCh. 3 - Use Figure Q3.13 to answer Questions 1317. FIGURE...Ch. 3 - Create the table that results from applying a...Ch. 3 - Write the relational algebra formula to apply an...Ch. 3 - Create the table that results from applying an...Ch. 3 - Using the tables in Figure Q3.13, create the table...Ch. 3 - Prob. 18RQCh. 3 - Prob. 19RQCh. 3 - Prob. 20RQCh. 3 - Identify and describe the components of the table...Ch. 3 - Identify the primary keys. FIGURE Q3.22 THE...Ch. 3 - Identify the foreign keys. FIGURE Q3.22 THE...Ch. 3 - Create the ERM. FIGURE Q3.22 THE CH03_THEATER...Ch. 3 - Create the relational diagram to show the...Ch. 3 - Prob. 26RQCh. 3 - What would be the conceptual view of the INDEX...Ch. 3 - Prob. 1PCh. 3 - Prob. 2PCh. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Describe the type(s) of relationship(s) between...Ch. 3 - Prob. 5PCh. 3 - Prob. 6PCh. 3 - Prob. 7PCh. 3 - Prob. 8PCh. 3 - Create the relational diagram to show the...Ch. 3 - Prob. 10PCh. 3 - Prob. 11PCh. 3 - Create the relational diagram to show the...Ch. 3 - Prob. 13PCh. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Prob. 15PCh. 3 - Prob. 16PCh. 3 - For each table, identify the primary key and the...Ch. 3 - Prob. 18PCh. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Identify the TRUCK tables candidate key(s). FIGURE...Ch. 3 - For each table, identify a superkey and a...Ch. 3 - Prob. 22PCh. 3 - Prob. 23PCh. 3 - Prob. 24PCh. 3 - Create the ERD. (Hint: Look at the table contents....Ch. 3 - Prob. 26PCh. 3 - Prob. 27PCh. 3 - Prob. 28PCh. 3 - Create the table that would result from applying...Ch. 3 - Create the table that would result from applying...Ch. 3 - Create the table that would result from applying a...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- The option for referential integrity between the Owner table and the Pet table is cascade and an attempt is made to delete the row for owner number 012 in the Owner table. What is the result? (Use only the data in the question. Do not assume other data exists if it is not present in the tables below.) The primary keys are underlined. These are the OwnerNum column in the Owner table and the PetNumber in the Pet table. The foreign key is italicized. This is the OwnerNum column in the Pet table. Owner Table OwnerNum LastName FirstName Address City State Zip 005 Smith Jim 100 Main Dune FL 37465 009 Jones Jane 3245 West Sanford FL 32773 012 Johnson Frank 2 Century Easton FL 37256 020 Doe Sally 101 Basel Orange FL 30998 Pet Table PetNumber PetName DOB Species OwnerNum 100 Fido 1/1/2005 Canine 009 200 Ajax 12/3/2003 Canine 020 300 Sunshine 6./12/2004 Feline 009 400 King…arrow_forwardThe option for referential integrity between the Owner table and the Pet table is restrict and an attempt is made to update the row for owner 012 (OwnerNum = 012) in the Owner table to become 120 (OwnerNum = 120). What is the result? (Use only the data in the question. Do not assume other data exists if it is not present in the tables below.) The primary keys are underlined. These are the OwnerNum column in the Owner table and the PetNumber in the Pet table. The foreign key is italicized. This is the OwnerNum column in the Pet table. Owner Table OwnerNum LastName FirstName Address City State Zip 005 Smith Jim 100 Main Dune FL 37465 009 Jones Jane 3245 West Sanford FL 32773 012 Johnson Frank 2 Century Easton FL 37256 020 Doe Sally 101 Basel Orange FL 30998 Pet Table PetNumber PetName DOB Species OwnerNum 100 Fido 1/1/2005 Canine 009 200 Ajax 12/3/2003 Canine 020 300 Sunshine…arrow_forwardYou have the following tables: APARTMENTS (ADDRESS, CITY, STATE, RENTER_ID, RENTER_LAST_NAME) RENTERS (RENTER_ID, FIRST_NAME, LAST_NAME) What is the primary key for the APARTMENTS table? (It may be a composite key involving 2 or more fields) What are the foreign keys, if any? What is the primary key for the RENTERS table? What are the foreign keys, if any? What field in RENTERS can be eliminated so that the RENTERS table is normalized?arrow_forward
- Write SQL code for To Extend the code in ( Perform a LEFT OUTER JOIN between the tables Wicketkeeping and Batting. You may select any column(s). Look at the result and state how many wicketkeepers have not played as batsmen (no need to write code for this part) To show the name of the wicketkeeper(s) who have not played as a batsman. (syntax to check a NULL value in a column is: WHERE ColumnName IS NULL ) ?arrow_forwardDoes a foreign key have to refrence all the primary key fields of another table?arrow_forwardIn Sql Oracle Application ,Amend the previous statement to not suppress duplicates and examine the output. How many extra rows did you get returned and which were they? Sort the output by employee_id to make it easier to spot.arrow_forward
- Not all versions of this database include referential integrity constraints for all foreign keys. Use whatever commands are available for the RDBMS you are using, investigate if any referential integrity constraints are missing. Write any missing constraints and, if possible, add them to the associated table definitions.arrow_forwardExplain Disallow null keys in fact tables?arrow_forwardUsing the corrected code from Step 28, include the Select into a temporary table named temptable. Prove your creation by run running a list from temptable where the title includes the characters eng. Hint: wildcard characters needed on your where clause. corrected code from step 28: select last_name, first_name, title, max(t.to_date), dept_name from employees e join titles t on e.emp_no = t.emp_no join dept_emp de on e.emp_no = de.emp_no join departments d on de.dept_no = d.dept_no group by e.emp_no order by last_name, first_name;arrow_forward
- How many inner joins are possible in the attached scenario? write a query for inner join, left join, and right join?arrow_forwardThe option for referential integrity between the Owner table and the Pet table is restrict. An attempt is made to delete the row for owner number 012 in the Owner table. What is the result? (Use only the data in the tables below. Do not assume other data exists if it is not present in the tables below.) The primary keys are underlined. These are the OwnerNum column in the Owner table and the PetNumber in the Pet table. The foreign key is italicized. This is the OwnerNum column in the Pet table. Owner Table OwnerNum LastName FirstName Address City State Zip 005 Smith Jim 100 Main Dune FL 37465 009 Jones Jane 3245 West Sanford FL 32773 012 Johnson Frank 2 Century Easton FL 37256 020 Doe Sally 101 Basel Orange FL 30998 Pet Table PetNumber PetName DOB Species OwnerNum 100 Fido 1/1/2005 Canine 009 200 Ajax 12/3/2003 Canine 020 300 Sunshine 6./12/2004 Feline 009 400 King…arrow_forwardProduce a list of all customer names in which the first letter of the first and last names is in uppercase and the rest are in lowercase. (refer to the tables in the JustLee Books database.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher: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
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka; Author: edureka;https://www.youtube.com/watch?v=zbMHLJ0dY4w;License: Standard YouTube License, CC-BY