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.41PAE
The Public Safety office at Millennium College maintains a list of parking tickets issued to vehicles parked illegally on the campus. Table 4-6 shows a portion of this list for the fall semester. (Attribute names are abbreviated to conserve space.)
- Convert this table to a relation in first normal form by entering appropriate data in the table. What are the determinants in this relation?
- Draw a dependency diagram that shows all functional dependencies in the relation, based on the sample data shown.
- Give an example of one or more anomalies that can result in using this relation.
- Develop 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).
- Develop an E-R diagram with the appropriate cardinality notations.
Expert Solution & Answer
Learn your wayIncludes step-by-step video
schedule07:49
Students have asked these similar questions
What is the link between a relation's main key and the functional dependencies among all of its attributes?
For 1 through 4, state whether the statements are True or False (Do not provide any explanation or comment but only an answer of either True or False)
A composite attribute is an attribute that is composed of several attributes.
A derived attribute is an attribute whose value is calculated and not permanently stored in adatabase.
Every table is a relation.
Referential integrity constraint is a rule stating that no primary key column can be optional.
Design the database as a single relation called Movie. It should contain an ID, Title, Year Released, Genre (e.g., sci-fi, comedy, thriller, etc.), Rating (e.g., G, PG, R, etc.), Format (e.g., VHS, DVD, MP3, etc.), a free-form Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own:
Title: Star Trek
Year: 2009 Genre: Sci-Fi
Rating: PG
Format: DVD
Director: J. J. Abrams
Starring: Chris Pine (Capt. Kirk), Zachary Quinto (Mr. Spock) Zoe Saldana (Uhura), Karl Urban (Bones McCoy)
Draw your corrected design as a logical ERD showing attributes and multiplicities (suggest you use IE Notation in Oracle Data Modeler). No need to include physical data types. Modify the sample data from step 1 in a new page to match this design
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
Following the bit-level floating-point coding rules, implement the function with the following prototype: / Co...
Computer Systems: A Programmer's Perspective (3rd Edition)
In the array declaration double score(5); state the following: a. The array name b. The base type c. The declar...
Problem Solving with C++ (10th Edition)
Rewrite both the 1istFi1e and removeFi1e methods in MusicOrganizer so that they use your validIndex method to c...
Objects First with Java: A Practical Introduction Using BlueJ (6th Edition)
What does the following program print? 1. // Exercise 4.25: Mystery2.java 2. public class Mystery2 { 3. public ...
Java How to Program, Early Objects (11th Edition) (Deitel: How to Program)
To find the cube root (the third root) of a number, raise it to the power of 1/3. To find the fourth root of a ...
Starting Out with C++: Early Objects (9th Edition)
Porter’s competitive forces model: The model is used to provide a general view about the firms, the competitors...
Management Information Systems: Managing the Digital Firm (15th Edition)
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
- Indicate dependences and their type.arrow_forwardDesign the database as a single relation called Movie. It should contain an ID, Title, Year Released, Genre (e.g., sci-fi, comedy, thriller, etc.), Rating (e.g., G, PG, R, etc.), Format (e.g., VHS, DVD, MP3, etc.), a free-form Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own: Title: Star Trek Year: 2009 Genre: Sci-Fi Rating: PG Format: DVD Director: J. J. Abrams Starring: Chris Pine (Capt. Kirk), Zachary Quinto (Mr. Spock) Zoe Saldana (Uhura), Karl Urban (Bones McCoy)arrow_forwardWhy do the functional dependencies among a relation's attributes have to do with the primary key of the relation in the first place?arrow_forward
- Write the SQL statements to create all of the necessary tables to represent the above diagram, representing as many constraints as possible. Note: you do not need to worry about specifying types for the fields, but you do need to provide suitable foreign key option(s). When playing a game, the home team name should be stored in attribute htname and the away team name should be stored in atname.arrow_forwarddatabase Assume that you have the following relation; R(a,b,c) a b c ---------- 1 A F 2 B M 3 T F 4 R M 5 A F And S is a relation with one attribute called c and has one tuple with the value 'F". Then the cardinality of R divided by S will be = ----- Select one: a. Non of the mentioned b. 2 c. 1 d. 3arrow_forwardThe properties of the relation object can be used to implement the master-detail functionality which most appropriate for your application. You can delete a master-detail relation by selecting it in the Object Navigator and choosing Navigator => Delete. Discuss the Deletion of Relations in detail.arrow_forward
- An suitable hybrid merge-join technique should be created for the case when both relations are not physically sorted but both have an index on the attributes that are being merged.arrow_forwardExplain the constraint between two attributes?arrow_forwardWhat is the connection between a relation's primary key and the functional relationships between all of its attributes?arrow_forward
- What constraint is imposed on am attribute that is declared as Primary Key? What bemefit does that constraint provide?arrow_forwardA relation may not have a super key. (a) True (b)Falsearrow_forwardWhat are three advantages of using a surrogate key rather than the main key to access a relation instead?arrow_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