Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 4, Problem 4.54PAE
Explore the data included in Table 4-9.
Assume that the primary key of this relation consists of two components: Author's ID (AID) and Book number (BNbr). The relation includes data regarding authors, books, and publishers. In addition, it tells what an individual author's per book royalty amount is in the case of multi-authored books. Your task is to:
- Identify the functional dependencies between the attributes.
- Identify the normal form in which the relation currently is.
- Identify the errors in the data that have been made possible by its poor structural characteristics.
- Take the actions (if any) necessary to convert the relation into the third normal form. Identify all intermediate steps.
Expert Solution & Answer
Learn your wayIncludes step-by-step video
schedule05:17
Students have asked these similar questions
Q3: Define a relation prereq depth(course id, prereq id, depth) where the attribute depth indicates how many levels of intermediate prerequisites there are between the course and the prerequisite. Direct prerequisites have a depth of 0. Note that a prerequisite course may have multiple depths and thus may appear more than once.
Explain the connection between a relation's primary key and the functional dependencies that exist between all of the characteristics in the relationship in question.
What is the connection between a relation's primary key and the functional relationships between all of its attributes?
Chapter 4 Solutions
Modern Database Management (12th Edition)
Ch. 4 - Prob. 4.1RQCh. 4 - Prob. 4.2RQCh. 4 - Prob. 4.3RQCh. 4 - Describe the primary differences between the...Ch. 4 - Summarize six important properties of relations.Ch. 4 - Describe two properties that each candidate key...Ch. 4 - Describe the three types of anomalies that can...Ch. 4 - Demonstrate each of the anomaly types with an...Ch. 4 - Fill in the blanks in each of the following...Ch. 4 - What is a well-structured relation? Why are...
Ch. 4 - Prob. 4.11RQCh. 4 - Describe how the following components of an E-R...Ch. 4 - Prob. 4.13RQCh. 4 - Prob. 4.14RQCh. 4 - Briefly describe four typical problems that often...Ch. 4 - Prob. 4.16RQCh. 4 - Explain how each of the following types of...Ch. 4 - Prob. 4.18RQCh. 4 - Prob. 4.19RQCh. 4 - Prob. 4.20RQCh. 4 - Prob. 4.21RQCh. 4 - What is the relationship between the primary key...Ch. 4 - Prob. 4.23RQCh. 4 - Explain what can be done with primary keys to...Ch. 4 - Prob. 4.25RQCh. 4 - Explain three conditions that suggest a surrogate...Ch. 4 - Prob. 4.27RQCh. 4 - For each of the following E-R diagrams from...Ch. 4 - Prob. 4.29PAECh. 4 - Prob. 4.30PAECh. 4 - For your answers to the following Problems and...Ch. 4 - Figure 4-3212 shows a class list for Millennium...Ch. 4 - Prob. 4.33PAECh. 4 - Prob. 4.34PAECh. 4 - Prob. 4.35PAECh. 4 - Prob. 4.36PAECh. 4 - Prob. 4.37PAECh. 4 - Prob. 4.38PAECh. 4 - For your answers to the following Problems and...Ch. 4 - Transform Figure 2-15a, attribute version, to 3NF...Ch. 4 - Prob. 4.41PAECh. 4 - Prob. 4.42PAECh. 4 - Prob. 4.43PAECh. 4 - Prob. 4.44PAECh. 4 - For your answers to Problem and Exercise 3-33 from...Ch. 4 - Prob. 4.46PAECh. 4 - Prob. 4.47PAECh. 4 - Figure 4-38 includes an EER diagram for a...Ch. 4 - Prob. 4.49PAECh. 4 - Prob. 4.50PAECh. 4 - Prob. 4.51PAECh. 4 - Prob. 4.52PAECh. 4 - Figure 4-40 shows an EER diagram for a university...Ch. 4 - Explore the data included in Table 4-9. Assume...Ch. 4 - Prob. 4.55PAECh. 4 - Prob. 4.56PAECh. 4 - Prob. 4.57PAECh. 4 - Prob. 4.58PAE
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
State whether each of the following is true or false. If false, explain why. The remainder operator (%) can be ...
Java How To Program (Early Objects)
Consider the adage Never ask a question for which you do not want the answer. a. Is following that adage ethica...
Experiencing MIS
Write a program that starts with the string variable first set to your first name and the string variable last ...
Absolute Java (6th Edition)
Which of the following are correct? a. False |= True. b. True |= False. c. (A B) |= (A B). d. A B |= A B. e...
Artificial Intelligence: A Modern Approach
Each repetition of a loop is known as a(n) a cycle ________. a. cycle b. revolution c. orbit d. iteration
Starting Out with Python (3rd Edition)
This type of method does not return a value. a. null b. void c. empty d. anonymous
Starting Out with Java: From Control Structures through Objects (7th Edition) (What's New in Computer Science)
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
- Why do the functional dependencies among a relation's attributes have to do with the primary key of the relation in the first place?arrow_forwardDefine the connection between a relation's main key and the functional relationships between all of its attributes.arrow_forwardInformally describe the conditions to be met for a relation to be in Second Normal Form. In terms of functional dependency, describe why the following CUSTOMER_PURCHASE relation is not in second normal form. This table describes every instance of an individual Customer purchasing a Product. How would this relation suffer from Update Anomalies? CUSTOMER_PURCHASE (CUSTOMER_ID, PRODUCT_ID, PURCHASE_DATE, PURCHASE_AMT, PRODUCT_DESCRIPTION, CUSTOMER_NAME) Note the relation’s primary key is underlinedarrow_forward
- What are three signs that a surrogate key should be generated for the primary key of a relation instead of using the main key?arrow_forwardNORMALIZATION The table above displays snippet of the monthly loan application report send by all banking institutions to the Bank Negara. Based on this report, answer the following questions:1. Identify the functional dependencies (primary, partial, and transitive if any) in the relation above based on the information given to you. Specify whether it is primary, partial, or transitive. 2. Perform normalization process to this relation based on the following steps; 1st Normal Form, 2nd Normal Form and finally the 3rd Normal Form. Your answers are the final relations or tables created after you have performed all three Normal Form. Please indicate the primary keys or/and foreign key(s) for all the relations. 3. Using your findings in Question 2, draw an ERD to reflect the properly decomposed normalized tables. Show all the relationships, attributes, primary key, foreign key, and multiplicities.arrow_forward# Question 1. Please select the correct statement(s) regarding a key constraint for a relation. An attribute or set of attributes satisfies a key constraint if there is no duplication of value(s) for such attribute(s) in the relation. A set of attribute(s) S is a key (super key) for a relation R if every pair of tuples in R must disagree on all the values for all attributes in S. A set of attribute(s) S is a key (super key) for a relation R if every pair of tuples in R disagree on at least one value for the attribute(s) in S. None of the above.arrow_forward
- Discuss the differences between the candidate keys and the primary key of a relation.arrow_forwardCreate an unnormalized relation using student and class entities.arrow_forwardQuestion: Consider a relation named as BOOK that contains data about the books in a library. BOOK relation was initially created with the attributes BookID (an id that library assigns), ISBN, CopyNr (used to differentiate copies of the same book), Title, PublYear, Author, and AuthorBornYear. Primary key: BookID, CopyNr and Author Candidate key: ISBN, CopyNr and Author Below you see dependencies of attributes: Dependency 1 (D1): ISBN, Title, PublYear, AuthorBornYear were dependent on BookID, CopyNr, and Author Dependency 2 (D2): Title and PublYear were dependent on BookID, CopyNr Dependency 3 (D3): AuthorBornYear was dependent on Author First determine which normal form (1NF, 2NF, 3NF, or BCNF) the above relation is, and why. Then, if necessary, convert the above relation to the highest normal form (BCNF). Write any assumptions that you make Subject: MYSQLarrow_forward
- For developing our queries, we will be using the following relational schema: Student(SID, name, username, major) Course(cname, description, department, weight) Offering(OID, cname, year, term, duration) Enrolled(SID, OID, grade) A course relation is the generic description of a course which is offered by a department. The offering relation is the specific instance of a course being taught in a given term, and is the entity which will be associated with the student enrollment. Students are enrolled in these offerings and achieve a mark. Express each of following queries in Relational Algebra: | Write a relational algebra query which will list the cname and description of all the courses which are being offering in the Fall 2018 term. 2 Write a relational algebra query which will list the name of all the students who have earned 60% in both 'COSC2P12' and 'COSC2P13'.arrow_forward39 Refer to the following ER diagram to answer the question below: PK Student SSN Name Year GPA How are keys used in these relations? PK PK Registration CampusID SSN EnrollmentDate Graduation Date PK O The CampusID attribute in the Registration relation is a candidate key. O The SSN and CampusID attributes in the School and Student relations areforeign keys. The CampusID and SSN attributes in the Registration relation are foreign keys. O The SSN attribute in the Registration relation is a candidate key. School CampusID Name Address X PERHIarrow_forwardPrimary key identifies a unique tuple of a relation, true or false?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 Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning