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
Question
Chapter 5, Problem 5.37PAE
Program Plan Intro
The opportunities for denormalization in the given normalized relation of sports league and the information needed to make an informed denormalization.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Task Description: consider the following relations for a university:
Student
(sid: integer, sname: string, GPA: real, dateOfBirth: date)
Department (did: integer, dname: string, capacity: integer)
Course
(cid: integer, cname: string, credit: integer)
Enroll
(studentID: integer, courselD: integer, departmentID: Integer, enrollmentDate: date)
studentlD, courselD, and departmentID in Enroll are foreign keys referencing the primary keys of the
student, course, and department relations, respectively.
Employee:
(EID, Name, City, Address)
Department:
(DID, Department_Name, City, budget)
Works_IN:
(EID, DID, Annual_Salary, Start_Date)
Manages:
(ManagerID, DepartmentID, rank)
DID and EID in Works_IN relation are foreign keys referencing the primary keys of the Department and Employee
relations respectively. Manager_ID and Department_ID in the Manages relation are foreign keys referencing the
primary keys of the Employee and Department respectively.
From the relational schemas illustrated above, use the different relational algebra operators and operations (p, o, n,
n, U, -, M) discussed in class to build the following queries:
1. Display employees (by name and address) from "Chicago" and with an annual salary between 60000
(included) and 90000 (excluded) then rename the output as "ChicagoEmployees"
2.
For each employee, who works in the “Design" department since January 2009, display the employee's
name and the employee's annual salary
3.
Find the name and rank of the manager who…
Employee:
(EID, Name, City, Address)
Department:
(DID, Department_Name, City, budget)
Works IN:
(EID, DID, Annual_Salary, Start_Date)
Manages:
(ManagerID, DepartmentID, rank)
DID and EID in Works_IN relation are foreign keys referencing the primary keys of the Department and Employee
relations respectively. Manager_ID and Department_ID in the Manages relation are foreign keys referencing the
primary keys of the Employee and Department respectively.
From the relational schemas illustrated above, use the different relational algebra operators and operations (p, o, n,
N, U, -, A) discussed in class to build the following queries:
1. Display employees (by name and address) from "Chicago" and with an annual salary between 60000
(included) and 90000 (excluded) then rename the output as "ChicagoEmployees"
2. For each employee, who works in the "Design" department since January 2009, display the employee's
name and the employee's annual salary
3. Find the name and rank of the manager who…
Chapter 5 Solutions
Modern Database Management (12th Edition)
Ch. 5 - Prob. 5.1RQCh. 5 - Prob. 5.2RQCh. 5 - Prob. 5.3RQCh. 5 - Prob. 5.4RQCh. 5 - Prob. 5.5RQCh. 5 - Prob. 5.6RQCh. 5 - Prob. 5.7RQCh. 5 - Prob. 5.8RQCh. 5 - Explain why you sometimes have to reserve much...Ch. 5 - Why are field values sometimes coded?
Ch. 5 - Prob. 5.11RQCh. 5 - Prob. 5.12RQCh. 5 - Explain why normalized relations may not comprise...Ch. 5 - Prob. 5.14RQCh. 5 - List three common situations that suggest that...Ch. 5 - Explain the reasons why some experts are against...Ch. 5 - Prob. 5.17RQCh. 5 - Prob. 5.18RQCh. 5 - Prob. 5.19RQCh. 5 - Prob. 5.20RQCh. 5 - Prob. 5.21RQCh. 5 - State nine rules of thumb for choosing indexes.Ch. 5 - One of the strongest recommendations regarding...Ch. 5 - Explain why an index is useful only if there is...Ch. 5 - Indexing can clearly be very beneficial. Why...Ch. 5 - Consider the following two relations for...Ch. 5 - Prob. 5.28PAECh. 5 - Prob. 5.29PAECh. 5 - Prob. 5.30PAECh. 5 - Prob. 5.31PAECh. 5 - Suppose you are designing a default value for the...Ch. 5 - When a student has not chosen a major at a...Ch. 5 - Prob. 5.34PAECh. 5 - Prob. 5.35PAECh. 5 - Consider the relations in Problem and Exercise...Ch. 5 - Prob. 5.37PAECh. 5 - Prob. 5.38PAECh. 5 - Prob. 5.39PAECh. 5 - Prob. 5.40PAECh. 5 - Prob. 5.41PAECh. 5 - Consider the relations specified in Problem and...Ch. 5 - Prob. 5.43PAECh. 5 - Prob. 5.44PAECh. 5 - Prob. 5.45PAECh. 5 - Prob. 5.46PAECh. 5 - Prob. 5.47PAECh. 5 - Problems and Exercises 8-65 through 8-68 refer to...Ch. 5 - Refer to the large Pine Valley Furniture Company...Ch. 5 - Problems and Exercises 8-65i5 through 8-68 refer...Ch. 5 - Refer to Figure 4-5 0. For each of the following...
Knowledge Booster
Similar questions
- Task Description: consider the following relations for a university: Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer) Department (did: integer, dname: string(30 chars), capacity: integer) Course (cid: integer, cname: string(50 chars), credit: integer) Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real) studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the primary key of the department relation. Using SQL, develop and execute the following queries: 1- For each student with GPA between 2.5 (included) and 3.5 (included), display the student’s name, GPA,and his/her department ID. Sort the results by the students’ IDs in descending order. 2- For each student who joined the Computer Science department between 2018…arrow_forwardwrite the schema that descibes the following relations: 1- The course relation course id title dept.name credits Intro. to Biology Biology Biology Biology Comp. Sci. Comp. Sci. Comp. Sci. Comp. Sci. Comp. Sci. Elec. Eng. BIO-101 4 BIO-301 BIO-399 CS-101 CS-190 CS-315 CS-319 Genetics 4 Computational Biology Intro. to Computer Science Game Design Robotics 3. 4. 4 Image Processing Database System Concepts Intro. to Digital Systems Investment Banking World History Music Video Production CS-347 ЕЕ-181 FIN-201 3 3 Finance HIS-351 MU-199 PHY-101 History Music Physical Principles Physics 4arrow_forwarda) Put the following relation in BCNF: STUDENT_ACTIVITY STUDENT_ACTIVITY (StudentID, StudentName, Activity, ActivityFee, AmountPaid) StudentID StudentName Activity ActivityFee AmountPaid 1 100 Jones Golf 65.00 65.00 2 100 Jones Skiing 200.00 0.00 3 200 Davis Skiing 200.00 0.00 4 200 Davis Swimming 50.00 50.00 5 300 Garret Skiing 200.00 100.00 6 300 Garrett Swimming 50.00 50.00 7 400 Jones Golf 65.00 65.00 400 Jones Swimming 50.00 50.00 b) Put the following relation in BCNF: Student(SSN, sName, address, HScode, HSname, HScity,GPA, priority) Assuming a student can attend more than one high school, and priority is determined by GPAarrow_forward
- 18. The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called a. Referential relation b. Referencing relation c. Referenced relation d. Referred relationarrow_forwardentities: Residential students which fields like student id, Student name, exam papersTransfer students with fields like student id, transferred school, exam papers etc.Exam papers with fields like subjects, total marks, invigilator, checkers.Exam center with fields like Center Id, location, seating capacity etc. -Create an ER Diagram using the enumerated entities.arrow_forwardDraw an Entity Relationship Diagram (ERD) based on the flat files that have been supplied. Your ERD must incorporate all the entities and attributes supplied, as well as establishing the relationships between the entitiesarrow_forward
- Write relationship and cardinality constraints which is in list. You need to make any assumptions I need querryarrow_forward1. The table shows a class list for the XYZ UNIVERSITY, convert this user view to a set of 3NF relations. Assume the following: a. An instructor has a unique code. b. Astudent has a unique course. C. A course has a unique description. XYZ UNIVERSITY First Semester, SY 2020-2021 Course No. : COE 412 Description : Operating Systems Instructor Code : 0001 Instructor Name : Mr. X ID NUMBER STUDENT NAME COURSE 38214 BRIGHT BSCPE 40875 CORTEZ BSECE 51893 EDWARD BSITarrow_forwardType ISBN eBook RelationName2 (AttrName1) Primary key {AttrName1) Price Book N Order Hardcopy Date Quantity RelationName1 (AttrName1, AttrName2) Primary key {AttrName1} Foreign key {AttrName2} references RelationName2 (AttrName1) M CoverStyle Customer Id Date Name Has Convert the following E-R diagram to a collection of relations. Determine all the primary and foreign keys. Use the following format to answer the question: Payment Noarrow_forward
- A college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?arrow_forwardLook at the 4 entities below and assume that customer_id is the key common to all tables. • Customer: An entity that describes a customer. An instance occurs for unique customers only using name, date of birth, and login name as customer_id primary key. • Online: An entity that describes a customer purchasing activity online. An instance occurs when the customer completes the transaction. Customers can purchase more than once. • Visits: An entity that describes a customer purchase in a physical store. An instance occurs if a customer makes or purchase or checks-in using an app. Customers can visit more than once per day. • Satisfaction: An entity that represents data from a recent customer satisfaction survey. An instance occurs when a customer takes the survey. A customer is tracked by login name and can only take the survey one time. Use the information to match the following relationships. Answers can be reused more than once. The relationship between Customer and Online The…arrow_forward3. In mathematical term Row is referred as a. Relation b. Attribute c. Tuple d. Domainarrow_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