Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 4, Problem 4.9RQ
Fill in the blanks in each of the following statements:
- A relation that has no partial functional dependencies is innormal form.
- A relation that has no transitive dependencies is innormal form.
- A relation that has no multivalued attributes is in normal form.
Expert Solution & Answer
Learn your wayIncludes step-by-step video
schedule03:42
Students have asked these similar questions
TRUE or FALSE - Generalization (is-a) is the relationship established between entities to show that sub-entities that are derived from the generalized entity.
Select one:
a. TRUE
b.FALSE
Identify the normal form it is in. Please make sure to provide explanations to support your answer. Convert it to BCNF.
1.GRADES (S#, C#, sem, year, F#, FName, Sname, Cname, grade, crHrs)
a) Write down the following functional dependencies:
S# -->
C# -->
F# -->
b) Which normal form is the above relation in?
c) Convert it to BCNF:
2.TEACHES (C#, sem, year, F#, Fname, Foffice)
a) Write down the functional dependency for F#:
F# -->
b) Which normal form is the above relation in?
c) Convert it to BCNF
3. R (a,b,c,d,e,f,g)
Given that: d --> a
e --> f,g
a) Which normal form is the above relation in?
b) Convert it to BCNF:
Exercise 4:
R1 = {(a, b) E R² | a > b}, the “greater than" relation,
R2 = {(a, b) E R² | a > b}, the “greater than or equal to" relation,
R3 = {(a, b) E R² | a < b}, the "less than" relation,
R4 = {(a, b) E R² | a
Chapter 4 Solutions
Modern Database Management
Ch. 4 - Define each of the following terms: determinant...Ch. 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 - Prob. 4.39PAECh. 4 - Transform Figure 2-15a, attribute version, to 3NF...Ch. 4 - The Public Safety office at Millennium College...Ch. 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
What is the value of the program counter in the Vole immediately after executing the instruction 0xB0CD?
Computer Science: An Overview (13th Edition) (What's New in Computer Science)
What Ada construct provides support for abstract data types?
Concepts of Programming Languages (11th Edition)
Practice Problem 8.5 (solution page 797) Write a wrapper function for sleep, called snooze, with the following ...
Computer Systems: A Programmer's Perspective (3rd Edition)
When displaying a Java applet, the browser invokes the _____ to interpret the bytecode into the appropriate mac...
Web Development and Design Foundations with HTML5 (8th Edition)
Write Python code that prompts the user to enter his or her height and assigns the user's input to a variable n...
Starting Out with Python (3rd Edition)
For each of the following activities, give a PEAS description of the task environment and characterize it in te...
Artificial Intelligence: A Modern Approach
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
- What is the difference between a weak and a strong group of entities?arrow_forwardRandom Hospital Example ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality. Random Hospital Example A hospital has 10 wards, each containing up to 20 patients. Patients have only one doctor allowed to prescribe drugs for them. Doctors do their rounds once a day and prescribe drugs by…arrow_forwardProblem 4: Supplementary question 2 Analyze the following relation, a) write the types of functional dependencies;___ c) perform the normalization to 2NF; then b) point out which normal forms it violates, and d) normalization to 3NF. STICK TO the GIVEN dependencies; Do NOT create your own State GynrD GvntName St. Flower City MayorID MaxorName CityHallAddr MayorPhone Functional dependencies - logic GIVEN: (next page) Repeat: STICK TO GIVEN dependencies; Do NOT create your ownarrow_forward
- What does the Weak Entity set entail?arrow_forwardDatabases: Regular entity type is transformed to a relation.arrow_forwardQuestion 17 Which of the following is another term for a recursive relationship? Group of answer choices ternary relationship binary relationship supertype relationship subtype relationship unary relationshiparrow_forward
- How do you know whether to convert a relationship to an associative entity type?arrow_forwardHouseSale (houseID, agentID, dateSold, commissionRate, interestRate) Where: dateSold interestRate agentID → commission Rate houseID →dateSold What is the highest normal form that the above relation satisfies? Decomposition into BCNF:arrow_forward. Students(stulD, lastName, firstName, major, credits) Faculty (facID, name, deptName, rank) • Classes(classNumber, facID, schedule, room) • Enrolls(stulD, classNumber, grade) The primary keys are underlined. The referential integrity constraints are as follows: . the column facID of relation Classes that references table Faculty, . the column stulD of relation Enrolls that references table Students, and the column classNumber of relation Enrolls that references table Classes. The following query is intended to retrieve the number of all classes taught by John Smith in the CST department. However, this query does not work properly. There are at least two faculty members who share the name, John Smith. Briefly explain and show the corrected SQL query_ why. SELECT classNumber FROM Classes WHERE facID= (SELECT facID FROM Faculty WHERE name='John Smith' AND deptName='CST');arrow_forward
- The term "interpolation of attributes" is a little vague.arrow_forwardB. Art Museum Database Draw an EER diagram to keep track of information for an art museum. Assume that the following requirements were collected: (10 marks) The museum has a collection of art objects. Each art object has a unique ID, a year (when it was created, if known), a title, and a description. Art objects must be categorized based on their type. There are three main types: painting, sculpture, plus another type called other to accommodate objects that do not fall into one of the two main types. A painting has a paint type (oil, watercolor, etc.), material on which it is drawn on (paper, canvas, wood, etc.), and style (modern, abstract, etc.). A sculpture has a material from which it was created (wood, stone, etc.), height, weight, and style. An art object in the other category has a type (print, photo, etc.) And style. The museum keeps track of artist information, if known: name, date born (if known), date died (if not living), country of origin, epoch, main style, and…arrow_forwardQ1: All the following statements about weak and strong entity sets are True, Except: Select one: a. The weak entity set depends on the existence of the strong entity set b. PK of the strong entity set is not explicitly stored with the weak entity set c. An entity set that does not have a primary key is referred to as a weak entity set d. In ER-Diagram, the identifying relationship of a weak entity in represented as a double diamond e. The PK of the weak entity set is only formed by the primary key of the strong entity set Below are two pictures, each with a second and third questionarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education