Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 5, Problem 5P
Explanation of Solution
Crow’s Foot ER diagram for Tiny College:
The following data model shows the solution for the given question.
Explanation:
- In the above data model, the overlapping constraint (o) is used as a category symbol. Here the “Employee” supertype entity has optional subtype entity.
- The “Professor” and “School” are the current data entities which mean the user can get the data from the current
database ...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Observe the table ENROLLMENT:
ENROLLMENT
StudentID
StudentName MajorID MajorName
111
Joe
E
English
222
Bob
H
History
333
Lisa
H
History
Which of the following (regarding the relation ENROLLMENT) represents the deletion anomaly?
O Deleting a major ID may delete the major name
O Deleting a major may delete all information about a student
O None of the answers
O Deleting a student ID may delete a student name
O Deleting a student may delete all information about a major
Observe the table ENROLLMENT:
ENROLLMENT
StudentID
StudentName MajorID MajorName
111
Joe
E
English
222
Bob
H
History
333
Lisa
H
History
Which of the following (regarding the relation ENROLLMENT) represents the modification anomaly?
O If a major name changes, it may have to be changed in more than one record
O If a student decides to use a longer version of his or her name, we cannot accommodate that modification
O If a student ID changes, we may have to change the major ID as well
O If a major ID changes, we may have to change the student ID as well
O All of these answers
I need help with a few steps on tableau please
Can you please show me the steps for these 2 questions:
1. Create a scatter plot between sales price and assessed value for all the records in the data set.
2. Create a scatter plot between sales price and year built.
Chapter 5 Solutions
Database Systems: Design, Implementation, & Management
Ch. 5 - Prob. 1RQCh. 5 - What kinds of data would you store in an entity...Ch. 5 - Prob. 3RQCh. 5 - What is a subtype discriminator? Give an example...Ch. 5 - Prob. 5RQCh. 5 - What is the difference between partial...Ch. 5 - Prob. 7RQCh. 5 - According to the data model, is it required that...Ch. 5 - Prob. 9RQCh. 5 - Prob. 10RQ
Ch. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - When implementing a 1:1 relationship, where should...Ch. 5 - What is time-variant data, and how would you deal...Ch. 5 - Prob. 16RQCh. 5 - Prob. 1PCh. 5 - Prob. 2PCh. 5 - Prob. 3PCh. 5 - Prob. 4PCh. 5 - Prob. 5PCh. 5 - Prob. 6PCh. 5 - Prob. 7PCh. 5 - Prob. 8CCh. 5 - Prob. 9CCh. 5 - Prob. 10C
Knowledge Booster
Similar questions
- Modify the CHARTER table to add the attributes shown in the following table. TABLE P8.37 ATTRIBUTES AND VALUES FOR PROBLEM 37 ATTRIBUTE NAME ATTRIBUTE DESCRIPTION ATTRIBUTE TYPE CHAR_WAIT_CHG Waiting charge for each model (copied from the MODEL table) Numeric CHAR_FLT_CHG_HR Flight charge per mile for each model (copied from the MODEL table using the MOD_CHG_MILE attribute) Numeric CHAR_FLT_CHG Flight charge (calculated by CHAR_HOURS_FLOWN CHAR_FLT_CHG_HR) Numeric CHAR_TAX_CHG CHAR_FLT_CHG tax rate (8%) Numeric CHAR_TOT_CHG CHAR_FLT_CHG + CHAR_TAX_CHG Numeric CHAR_PYMT Amount paid by customer Numeric CHAR_BALANCE Balance remaining after payment Numericarrow_forwardAn EMPLOYEES table was added to the JustLee Books database to track employee information. Display a list of each employee’s name, job title, and manager’s name. Use column aliases to clearly identify employee and manager name values. Include all employees in the list and sort by manager name.arrow_forwardList the changes you would need to make to your answer for Question 11 if the requirements change so that you must store the year and the semester in which a student took a course and received a grade.arrow_forward
- What is a primary key? What is the primary key for each of the tables in the Colonial Adventure Tours database shown in Chapter 1?arrow_forward42. Which quality of the table demonstrates why it is not in first normal form? A: There are only non-key attributes visible B: There is no primary key C: there is data redundancy D: each attribute has multiple valuesarrow_forwardStayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.arrow_forward
- StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.arrow_forwardStayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.arrow_forwardAssignment: a) Is this table in 1NF? Why or why not? b) Describe and illustrate the process of normalizing the data shown in this table, from first to third normal form (1NF-3NF). c) Identify the primary, alternate, and foreign keys in the 3NF relations. StaffBranch Table staffNo name position level salary $1500 Tom Daniels Manager 3 46000 B001 S0003 Sally Adams Assistant 1 30000 B001 S0010 Mary Martinez Manager 5 S3250 Robert Chin Supervisor 1 50000 B002 32000 B002 S2250 Sally Stern Manager 4 48000 B004 S0415 Art Peters Manager 2 41000 B003 503-555-3618 503-555-2727 206-555-8836 206-555-6756 206-555-4112 hours supervisor 45 S0010 36.5 $2250 38 S0415 28 S0010 212-371-3000 37 S2250 branchNo branchAddress 8 Jefferson Way, Portland, OR 97201 8 Jefferson Way, Portland, OR 97201 City Center Plaza, Seattle, OR 98122 City Center Plaza, Seattle, OR 98122 16-14th Avenue, Seattle, OR 98128 14-18th Avenue, New York, NY 10012 telNoarrow_forward
- Convert the accompanying database to an excel table to find: A.the total cost of all orders B.the total quantity of airframe fasteners purchased. C.the total cost of all orders placed with Manley valve.arrow_forwardExamine the table shown below. This table represents the hours worked per week for temporary staff at each branch of a company. (a) The table shown below is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table. Using the data shown in this table, the student should provide examples of how insertion, deletion, and update anomalies could occur.arrow_forwardConsider the data of the following two tables. Department DepartmentID DName ContactNo 1 UIIT 0300-1234567 2 UIMS 0300-4567891 Student RollNo Sname Fname DepartmentID 111 Ali Ahmed 1 112 Sana Waqar 2 113 Afzal Ikram 2 There are only two departments and are already initialized globally, but students can be upto 100 and just defined globally. To maintain how many student’s record have been entered you can use global variable with name as count. Write a C++ program having: Structures, structure definitions and required initializations for the above scenario. Function which takes input data (RollNo, Sname, Fname and DepartmentID) of student from user within the function, then verify that the DepartmentIDexists in Department or not? If exists then copy DName and ContactNo in the student record along with above input, otherwise just display a message that department does not exists. For example the following record…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr