Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 4, Problem 4.40PAE
Transform Figure 2-15a, attribute version, to 3NF relations. Transform Figure 2-15b, relationship version, to 3NF relations. Compare these two sets of 3NF relations with those in Figure 4-10 What Observations and conclusions do you reach by comparing these different sets of 3NF relations?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Using the relations ATTACHED, normalize your relations into first, second, and third normal forms.
First, KINDLY describe the changes required to your relations to meet the standard of the first 1NF and then 2NF and lastly 3NF.
Then, you should provide an Entity Relationship diagram that is in 3NF. All attributes, entities, keys, and relationships should be included and labelled.
Hint: Remember that in the hospital software system, the “Patient” relation includes the “medicines” attribute and the “Appointment” relation includes the “allergies” attribute. Allergies describe a list of any known allergies and medicines describe a list of medicines prescribed for a patient.
Please add:
Define or describe the changes required to get the relations into the 1st normal form.
Define or describe the changes required to get the relations into the 2nd normal form.
Include an Entity Relationship diagram in the 3rd normal form.
The primary and foreign keys, at a minimum, are defined for each…
Part 2: Relational data model. Take a subset of the ideas from the conceptual model you constructed in Part 1 and design a simple relationship model similar to the ones we discussed in Module 2, Video 4
Your model should have at least 5 tables
You should include at least 20 attributes, or fields, in your model (20 total across all tables, not per table)
Your model should be normalized
Identify the primary key in each table, and state whether it is a natural or surrogate key
For each relationship between tables, identify any foreign keys needed to define the relationship
For each table, identify what type of system or systems you think the data might come from, like those we discussed in Module 1, Video 6.
Create an ER model related to the following entities and relationships: Department, Student, Professor, Course, Section, Grade, Major. (For attributes inside each table, you only need to insert several reasonable attributes. No need to have a comprehensive list. For many-to-many relationship, you also need to insert one extra table to handle the many-to-many relationship. The final database design will have more tables than the number of entities listed above.)
A given department can offer many courses.
A given course can be offered by only one related department.
A given course can have many related sections.
A given professor can teach many sections.
A given section can only be related to one course and taught by one professor.
A given professor can have appointment with different departments
A given department can have many professors.
A given department can offer several majors.
A given major can be offered by only one related department.
A given student can have several majors.
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
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
- Consider each of the takes and teaches relations as a fact table; they do not have an explicit measure attribute, but assume each table has a measure attribute reg_count whose value is always 1. What would the dimension attributes and dimension tables be in each case. Would the resultant schemas be star schemas or snowflake schemas?arrow_forwardI need the answer as soon as possiblearrow_forwardExplain the usage of attributes and the generic name for attribute in the relationship model.arrow_forward
- Use the technique of normalization to validate the structure of your relational schema. Demonstrate that each of your relations is in third normal form (3NF) by displaying the functional dependencies between attributes in each relation. Note, if any of your relations are not in 3NF, this may indicate that your ER model is structurally incorrect or that you have introduced errors in the process of deriving relations from your model.arrow_forwardAn ERD has m number of entities (strong, weak, parent, child all combined) and n number of relationship types (of all possible kinds). When transformed to the relational schema, Database designer come up with a solution which contained more than m+n relations. What could possibly be the reason? If you think the designer did a mistake then you can say that in your answer. Explain your answer if you think that will help. Answer:arrow_forwardPart II: For the given ER diagram, construct the relational schema by specifying the resulting relations, their attributes, keys, and foreign keys. SSN ESSN address Dependent name N Branch-name CUSTOMER name 1 Cust-banker EMPLOYEE Employment-length 1 type Start-date manager worker Branch-city Phono name BRANCH borrower 1 Works for N N assets Paymente Loan-branch N LOAN 1 Loan-payment N PAYMENT Paymont date Loan number amount Payment amountarrow_forward
- Consider the given ER Diagram for Notown database in Figure 2. You have been tasked to recommend that Notown use a relational database system to store company data. Show the Structured Query Language (SQL) statements for creating relations corresponding to the entity sets and relationship sets in your design. Identify any constraints in the ER Diagram that you are unable to capture in the SQL statements and briefly explain why you could not express them.arrow_forwardPart 3: Denormalization – Pick one of the three common relationship types that often give an opportunity for denormalization (one-to-one; many-to-many with non-key attributes; reference data (1:N)), and make up a possible scenario that would fit it. Provide the normalized relations that represent your scenario. Now, show the resulting relation(s) if you were to denormalize what you provided above. Explain the advantages and disadvantages to what you did in (b). Or, if you were not able to denormalize, justify why it was not possible.arrow_forwardRegards to the diagram below (figure 4.12), answer the following questions using the multiple-choice listed under each question. How is of_type modeled? Not modeled into any relationship relation foreign key for "relationship" relation relation and n foreign keys relation and foreign key with single attribute value relation with owning entity primary key participating in primary key one atomic attribute relation and two foreign keys set of simple component attributes How do you model Stored_in? Not modeled into any relationship relation foreign key for "relationship" relation relation and n foreign keys relation and foreign key with single attribute value relation with owning entity primary key participating in primary key one atomic attribute relation and two foreign keys set of simple component attributes In person, if address was a composite attribute, consisting of first name, last name, and middle initial, how would you model that attribute? Not modeled into any…arrow_forward
- Please read this carefully and Draw an EER diagram for a database of a hospital following these requirements: create Four to five regular strong entities. A union One 1:1, one 1:N, and one N:M relationship – of which at least one relationship should be partial and one full. One overlap relationship and one disjoint relationship. Other notes: Do not emphasize on too many attributes for the entities. Two to three attributes for each entity will be enough. Make sure to include a primary key for each entity.arrow_forwardplease answer within 30 minutes.arrow_forwardQ1 Extract and write down the DB Schema for the following E-R Diagram. You need to write the name, attributes, and keys (need to be underlined) for each relation in your schema. co de result Exam sin description pfname (0, N) (0, N) Patient UnderTakes cost plname (0, N) sex start_date end_date (1, N) (0, N) Hosted By doctorld start_date tel (1, 1) (1, N) rooms office Doctor Worksin Clinic cname dfname diname (1, 1) (1, 1) Manages specialty 00arrow_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
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY