Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 2.39E
Program Plan Intro
Candidate Key:
Candidate Key is the set of minimal attribute which can identify the whole set of attributes present in the tuple. It is a set of primary keys and is unique.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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.
Normalize the following given data to 1/2/3 NF. State the relations schema after everynormalization.
convert it to relations that are normalization
Chapter 2 Solutions
Database Concepts (8th 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 - Define the terms candidate key and primary key....Ch. 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 - Apply the normalization process to the Veterinary...
Knowledge Booster
Similar questions
- Decompose the above relation using the Boyce-code normal form decomposition. What is the key relation for the relation Rarrow_forwardDevelop recurrence relations for the last 3 columns of table 1. Use the recurrence relation you developed to complete the table for these months: • Month 59 • Month 60 • Month 61 • Month119 • Month 120 • Month 121 Show your calculations and completed table.arrow_forwardDevelop a set of relations in third normal form. Include a new column with the heading Violation in the appropriate table to explain the reason for each ticket. Values in this column are: expired parking meter (ticket code 1), no parking permit (ticket code 2), and handicap violation (ticket code 3).arrow_forward
- Given the relations a(name, address, title) and b(name, address, salary), show how to express a natural full outer join b using the full outer-join operation with an on condition rather than using the natural join syntax. This can be done using the coalesce operation. Make sure that the result relation does not contain two copies of the attributes name and address and that the solution is correct even if some tuples in a and b have null values for attributes name or address.arrow_forwardConvert the table above to a relation in first normal form. Illustrate the relation with the sample data in the table.arrow_forwardExplain the concept of functional dependencies in the context of normalization.arrow_forward
- Write at least 3 functional dependency from the tablearrow_forwardIf you assume that a relation has no duplicate data, how do you know there is always at least one primary key?arrow_forwardUsing Normalization technique decompose the above un normalized relation to reach the 3NF, clearly showing all the steps involved to reach each Normal Form (NF). CustNo, CustName, Addr, SuppNo, SuppName, SuppTel, (ordNo, orderDesc, QtyOrdrd)arrow_forward
- Q5: Figure 03 represents the database of an agency that focuses on providing the full time/ part time staff to different hotels throughout the country. The attribute NIN refers to the insurance number. NIN is unique for each and every employee of the said Agency. a) Is this table susceptible to update anomalies? If yes then provide example of insertion, deletion and modification anomalies, if exists. b) Normalize the given relation. Make sure that you write each and every step that you perform in order to normalize the given relation. Figure 03 NIN contractNo hoursPerWeek eName hotelNo hotelLocation 113567WD C1024 16 Ahmed Ali H25 ISB 234111XA C1024 24 Bilal ahmed H25 ISB 712670YD C1025 28 Noman H4 RWP Akram 113567WD C1025 16 Ahmed Ali H4 RWParrow_forwardConsider the following relations. The primary keys are underlined. All attributes are of type string if not indicated otherwise. [Hint: Use multi-step and multi-line queries to ease the formulation of queries. Use the rename operator ρ to give intermediate query results a name (some textbooks use the equivalent ‘←’ notation). Aggregate functions as you can find them defined in some textbooks are not allowed, neither in homework assignments nor in exams.] Student(sID , name, degree: integer, dID) Department(dID , name, address) Lecture(lID , name, degree: integer, pID, dID) Professor(pID , name, dID) Register(rID , sID, lID, Semester, score: integer) Relational Algebra Queries: 1. Find the names of students who have registered every lecture of CISE department. 2. Find the students who got the highest score in the lecture ‘DB’ in 2021 Fall semester. Show names and scores together. 3. Find the names of students in CISE department who never received a score less than 80. 4. Find the…arrow_forwardReview FamCation relations and determine if they are all in 3NF. If not, which relations do you need to normalize and how?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 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