Database Concepts (7th Edition)
7th Edition
ISBN: 9780133544626
Author: David M. Kroenke, David J. Auer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 2, Problem 2.35RQ
Program Plan Intro
Functional dependencies:
The functional dependency is a relationship that exists at the time of one attribute distinctively determines another.
Example:
NoOfBoxes → CookieCost
In the above expression, NoOfBoxes attribute determines CookieCost attribute, left term “NoOfBoxes” refers the determinant, and “→” defines the relationship. That is, the CookieCost is functionally dependent on NoOfBoxes. This expression defines the relationship between NoOfBoxes and CookieCost.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Examine the data in the Veterinary Office List—Version Two in Figure 1-31 (see page 72) and state assumptions about functional dependencies in that table
Examine the data in the Veterinary Office List-Version One in Figure 1-34 (see page 63), and state assumptions about functional dependencies in that table. What is the danger of making such conclusions on the basis of sample data?
Table 1 is the Sales table, which is an unnormalized table. The description of the Sales table are SNUM = salesman number, CNUM = customer number, WNUM = warehouse number, SAMOUNT = sale amount, etc.
a.)Write down four functional dependencies (FDs) that are valid in the Sales table
b.)Write down the Sales table's normalization result that is in the 2NF, but not in the 3NF.Explain why the table is not in the 3NF.
Chapter 2 Solutions
Database Concepts (7th Edition)
Ch. 2 - Prob. 2.1RQCh. 2 - Define the term entity, and give an example of an...Ch. 2 - Prob. 2.3RQCh. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - Prob. 2.7RQCh. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - Define the term unique key and give an example.
Ch. 2 - Prob. 2.11RQCh. 2 - Prob. 2.12RQCh. 2 - Prob. 2.13RQCh. 2 - Describe four uses of a primary key.Ch. 2 - Prob. 2.15RQCh. 2 - Prob. 2.16RQCh. 2 - Prob. 2.17RQCh. 2 - Explain the term foreign key, and give an example.Ch. 2 - Prob. 2.19RQCh. 2 - Prob. 2.20RQCh. 2 - Explain three possible interpretations of a null...Ch. 2 - Give an example of a null value (other than one...Ch. 2 - Prob. 2.23RQCh. 2 - Prob. 2.24RQCh. 2 - Prob. 2.25RQCh. 2 - Prob. 2.26RQCh. 2 - Prob. 2.27RQCh. 2 - Define the term primary key in terms of functional...Ch. 2 - Prob. 2.31RQCh. 2 - Examine the data in the Veterinary Office...Ch. 2 - Prob. 2.33RQCh. 2 - Describe a modification problem that occurs when...Ch. 2 - Prob. 2.35RQCh. 2 - Prob. 2.36RQCh. 2 - Prob. 2.37RQCh. 2 - Apply the normalization process to the Veterinary...Ch. 2 - Prob. 2.39ECh. 2 - Prob. 2.40E
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 meaning of the word "transitive" We know that tables in second normal form can be changed to tables in third normal form, but what is the rule for making this transformation?arrow_forwardYou will need to create the database tables and choose sensible data types for each column.Make sure to maintain entity and referential integrity, and implement all the above constraints.Since other developers work in parallel on other parts of the system, you will need to strictly follow the above specification to correctly implemented in your database. Otherwise, the other software will not be able to use your database. This means, one needs to be able to rely on all constraints being correct, the spelling of table and column names being as given, and that the data types that you chose will allow for sensible data to be added to the database in the future.For testing purposes, you are asked to insert the data specified below into the tables, but no other data except this.In short:1. You will need to create the tables as specified2. You will need to add the data specified Please use the 3.sql and implement your tables using the sketched CREATE TABLE commands. Add the necessary queries…arrow_forwardHow many local descriptor tables can exist?arrow_forward
- Normalization functional dependencies have what characteristics?arrow_forwardA table is in __________ normal form when it is in __________ and there are no transitive dependencies.arrow_forwardDetermine the functional dependencies that exist in the following table and then convert this table to an equivalent collection of tables that are in third normal form. OFFICE (OFFICE NUM, OFFICE NAME, (ADDRESS, SQR FT, BDRMS, FLOORS, MONTHLY RENT, OWNER NUM))arrow_forward
- Determine the functional dependencies that exist in the following table and then convert this table to an equivalent collection of tables that are in third normal form.arrow_forwardWhat does the term "transitive" mean? What is the rule for converting tables in the second normal form to tables in the third normal form?arrow_forwardUsing your knowledge of the college environment, determine the functional dependencies that exist in thefollowing table. After determining the functional dependencies, convert this table to an equivalent collectionof tables that are in third normal form:Student (StudentNum, StudentName, NumCredits, AdvisorNum,AdvisorName, DeptNum, DeptName, (CourseNum, Description,Term, Grade))arrow_forward
- Give a normalized version of the Index_metadata relation, and explain why using the normalized version would result in worse performance.arrow_forwardWhat exactly does it imply to say that something is transitive? It is possible to convert tables that are in the second normal form to tables that are in the third normal form; however, the rule for doing so is not well known.arrow_forwardWhen is denormalization justified?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
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