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 6, Problem 6.35PAE
Are based on the class scheduling 3NF relations along with some sample data shown in Figure 6-11. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections.
Note that values of the SectionNo column do not repeat across semesters.
Figure 6-11 Class scheduling relations (missing ASSIGNMENT)
The
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
When translating an ER model into database tables
a.) all of the entity attributes become the foreign keys.
b.) the entity attributes become the tables.
c.) for each entity, two tables need to be created.
d.) the entity attributes become the fields of the new table.
The goal of normalization is to, (please select all that apply):
a.) eliminate data duplication.
b.) is create only 1:N relationships.
c.) to create as few as possible tables to promote efficiency between the tables.
d.) construct tables so that each table has a single topic or theme.
Suppose, for a Salat management system, you have the following information:
Person Name, Gender , Age, Date, Time, Prayed Rakats, Ontime/Offtime, Time to pray
Identify the associated updation/deletion anomalies if the data is stored as it is in a single table
Identify functional dependences/ transitive dependencies that can be used to normalize
Normalize the database into constituent tables
Develop an ER diagram for Salat management system
Use MS Visio to create relational data schemas and data dependency diagrams for all entities (tables). Start out with listing all data attributes in 1NF, then label partial dependencies and potential transitive dependencies.
For this Data.
A database for payment and bookings for a Virginia Beach hotel.
A guest can check into a hotel.
A hotel can have many guests.
A hotel can keep a record of a guest’s activities.
A record can contain many notes.
Possible tables might include: Guests, Notes, Room Type, Charges.
Possible Primary keys might include: GuestID, NoteID, RoomID, ChargeCode.
Possible attributes might include: CustName, Room#, ChargeType.
Chapter 6 Solutions
Modern Database Management (12th Edition)
Ch. 6 - Prob. 6.1RQCh. 6 - Prob. 6.2RQCh. 6 - Contrast the following terms: a. base table; view...Ch. 6 - Prob. 6.4RQCh. 6 - Prob. 6.5RQCh. 6 - Prob. 6.6RQCh. 6 - List six potential benefits of achieving an SQL...Ch. 6 - Prob. 6.8RQCh. 6 - Distinguish among data definition commands, data...Ch. 6 - Prob. 6.10RQ
Ch. 6 - Prob. 6.11RQCh. 6 - Prob. 6.12RQCh. 6 - Prob. 6.13RQCh. 6 - Drawing on material covered in prior chapters,...Ch. 6 - Explain and provide at least one example Of how to...Ch. 6 - Prob. 6.16RQCh. 6 - What is the difference between COUNT, COUNT...Ch. 6 - What is the evaluation order for the Boolean...Ch. 6 - If an SQL statement includes a GROUP BY clause,...Ch. 6 - Prob. 6.20RQCh. 6 - Prob. 6.21RQCh. 6 - Prob. 6.22RQCh. 6 - Explain why SQL is called a set-oriented language.Ch. 6 - When would the use of the LIKE key word with the...Ch. 6 - Prob. 6.25RQCh. 6 - Prob. 6.26RQCh. 6 - In what order are the clauses of an SQL statement...Ch. 6 - Within which clauses of an SQL statement can a...Ch. 6 - Prob. 6.29RQCh. 6 - Prob. 6.30RQCh. 6 - Prob. 6.31RQCh. 6 - Explain the difference between the WHERE and...Ch. 6 - Prob. 6.33RQCh. 6 - Prob. 6.34PAECh. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Prob. 6.36PAECh. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Prob. 6.40PAECh. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Prob. 6.42PAECh. 6 - Prob. 6.43PAECh. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Prob. 6.45PAECh. 6 - Prob. 6.46PAECh. 6 - Prob. 6.47PAECh. 6 - Prob. 6.48PAECh. 6 - Prob. 6.49PAECh. 6 - Prob. 6.50PAECh. 6 - Prob. 6.51PAECh. 6 - Prob. 6.52PAECh. 6 - Prob. 6.53PAECh. 6 - Modify the Product_T table by adding an attribute...Ch. 6 - Prob. 6.55PAECh. 6 - Add an order to the Order_T table and include a...Ch. 6 - Use the Pine Valley database to answer the...Ch. 6 - Prob. 6.58PAECh. 6 - Prob. 6.59PAECh. 6 - Prob. 6.60PAECh. 6 - Prob. 6.61PAECh. 6 - Prob. 6.62PAECh. 6 - Prob. 6.63PAECh. 6 - Prob. 6.64PAECh. 6 - Prob. 6.65PAECh. 6 - Prob. 6.66PAECh. 6 - Prob. 6.67PAECh. 6 - Prob. 6.68PAECh. 6 - Prob. 6.69PAECh. 6 - Prob. 6.70PAECh. 6 - Prob. 6.71PAECh. 6 - Prob. 6.72PAECh. 6 - Prob. 6.73PAECh. 6 - Prob. 6.74PAECh. 6 - Prob. 6.75PAECh. 6 - Prob. 6.76PAECh. 6 - Prob. 6.77PAECh. 6 - Prob. 6.78PAECh. 6 - Prob. 6.79PAECh. 6 - Prob. 6.80PAECh. 6 - Prob. 6.81PAECh. 6 - Prob. 6.82PAECh. 6 - Prob. 6.83PAECh. 6 - Prob. 6.84PAECh. 6 - Prob. 6.85PAE
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
- Combine the views of the student enrolment in the Enrollment Record and Assessment Forms and represent the unnormalized integrated enrolment record (together with the assessment) using relational notation. Perform normalization to convert the enrolment record to 3NF, showing all intermediate stages (i.e. 1NF and 2NF). Represent the normalized relations using relational notation. Document all assumptions that you make about the data model.arrow_forwardUse the database shown in Figure P3.10 to work Problems 10-16. Note that the database is composed of four tables that reflect these relationships: An EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEES. An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEES. Note also that the M: N relationship has been broken down into two 1: M relationships for which the BENEFIT table serves as the composite or bridge entity. For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. Create the ERD to show the relationship between EMPLOYEE and JOBarrow_forwardA list of normalized relations (using the notation from class) that is based on your ER diagram.Be sure to include foreign keys, etc. and Prepare a MySQL script that creates your database, tables, and inserts a small sampling of madeup data. Test it out in MySQL before submissionarrow_forward
- With suitable example, explain what is Data Redundancy. Consider the relation Treatment with the schema Treatment (doctorID, doctorName, patientID, diagnosis) and functional dependencies; doctorID doctorName patientID diagnosis D001 Mohan PAT123 Fever D002 Vijay PAT110 Allergy D003 Jenifer PAT112 Fever D002 Vijay PAT121 Cold Describe the three (3) types of anomaly that can arise for this table with example records.arrow_forwardI need you solve this question (Based on the Un-Normalized database table below, create a data model for a Rental Caragency by normalizing them with 2nd and 3rd normal forms.) i need you to complete just like the second image in hand writtenarrow_forwardDatabase normalization is needed. 1NF, 2NF, 3NF, BCNF and 4NF. If some steps can be skipped, please expain why. ex) BCNF is not needed because .... Each relation (table) represents a single subject. For example, a COURSE table will contain only data that directly pertain to courses. Each row/column intersection contains only one value and not a group of values. No data item will be unnecessarily stored in more than one table (tables have minimum controlled redundancy). All nonprime attributes in a relation (table) are dependent on the primary key - the entire primary key and nothing but the primary key. Each relation (table) has no insertion, update, or deletion anomalies, which ensures the integrity and consistency of the data.arrow_forward
- 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.arrow_forwardUsing Laravel 8, make a scenario that college, student and department have relationship, define attributes in database schema and define models. Also provide route page coding, model page, migrations page, factory page coding and controller page coding. This scenario should in codingarrow_forwardExplain the concept of database normalization. What are the different normal forms, and why is normalization important in data modeling?arrow_forward
- What would need to be done to fix an issue with a chasm trap? Create a direct link between the two tables rather than depend on the middle relationship. The entire database design needs to be re-evaluated. Create a foreign key for each primary key in the relationships. Remove the middle table and connect the tables directly.arrow_forwardWhat are multivalued attributes, and how can they be handled within the database design? Questions 17-20 are based on the ERD in Figure Q4.17arrow_forwardSUBJECT: DATABASE MANAGEMENT SYSTEM QUESTION NO 1: Suppose you assigned a task to design relational schema by consider the domain of Bahria University and consider the information of student, employee, campuses, departments, and programs and then normalize these relations up to third normal form QUESTION NO 2: Suppose you assigned a task to design relational schema by considering the domain of product manufacturing company by considering the information of clients, branches, employee, products, and human resource then identify sample dependencies(if any) associated with BCNF and 4th Normal form and then remove those dependencies in order to transform the schemas into BCNF and 4th Normal Form also.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY