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
Question
Chapter 6, Problem 13RQ
Program Plan Intro
Normalization:
The process used to minimize data redundancy and dependency in a relational
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
When an attribute is included in a composite primary key, it automatically becomes a candidate key for that table.
When an attribute is part of a composite primary key, it is also considered a candidate key for the table.
Answer questions 2.1 to 2.4 based on the following schema. Note that primary keys are in BOLD. Note also that attributes with the same name in different tables are foreign keys. For example, doctorID in the Treatment table is a foreign key that refers to the Doctor table.
Doctor(doctorId:integer, specialtyID:integer, firstName:varchar(20), lastName:varchar(20), salary:numeric(11,2))
Specialty(specialtyID:integer, specialtyName:varchar(20), specialtyCost:numeric(11,2))
Treatment(doctorId:integer, patientSSN:integer, dateTreated:date, costOfTreatment:numeric(11,2))
Patient(patientSSN:integer, firstName:varchar(20), lastName:varchar(20), street:varchar(30), city:varchar(15), Â state:char(2),zipCode:integer(5))
1. Write an SQL statement to increase the cost of all Specialty treatment by 2.5%
2. Write a SQL statement to delete all treatment rows that were done before 2015 and cost less than $500.
Chapter 6 Solutions
Database Systems: Design, Implementation, & Management
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
- For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLESarrow_forwardWhen part of the data in a table depends on a field in the table that isn’t the table’s primary key, it’s known as: transitive dependency partial dependency psychological dependency a foreign keyarrow_forwardAnswer questions 2.1 to 2.4 based on the following schema. Note that primary keys are in BOLD. Note also that attributes with the same name in different tables are foreign keys. For example, doctorID in the Treatment table is a foreign key that refers to the Doctor table. Doctor(doctorId:integer, specialtyID:integer, firstName:varchar(20), lastName:varchar(20), salary:numeric(11,2)) Specialty(specialtyID:integer, specialtyName:varchar(20), specialtyCost:numeric(11,2)) Treatment(doctorId:integer, patientSSN:integer, dateTreated:date, costOfTreatment:numeric(11,2)) Patient(patientSSN:integer, firstName:varchar(20), lastName:varchar(20), street:varchar(30), city:varchar(15),  state:char(2),zipCode:integer(5)) 2.3) Write an SQL statement to increase the cost of all Specialty treatment by 2.5% 2.4) Write a SQL statement to delete all treatment rows that were done before 2015 and cost less than $500. 2.5) Write an SQL statement to select all Specialties where the specialtytName has a null…arrow_forward
- When an attribute is a component of a composite primary key, that attribute is also considered to be a candidate key for the table.arrow_forwardWhat exactly is a main key? How crucial is the main key in establishing a link between tables?arrow_forwardWhen considering creating a join between two tables, how are we demonstrating the concept of "relational" databases? Why is it essential to create the join by finding a unique, unique attribute in at least one table and looking at situations where that attribute has the same value ( is equal ) in both tables?arrow_forward
- When considering creating a join between two tables, how are we demonstrating the concept of "relational" databases? Why is it essential that we create the join by finding a common attribute that is unique in at least one table and look at situations where that attribute has the same value ( is equal ) in both tables?arrow_forwardUsing normalisation, depict the relationship schema of the 2NF tables. State the respective primary keys.arrow_forward1- For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. 3. 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 keyarrow_forward
- An entity's primary key as an attribute creates a Parent-Child connection between tables. B Multiple-to-many tables. C Table network model. D Tables link one-to-many.arrow_forwardWhat exactly are aggregate tables?arrow_forwardExplain why an index is useful only if there is sufficient variety in the values of an attribute?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase 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 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