Database Systems: Design, Implementation, & Management
11th Edition
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
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 5, Problem 4P
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 “Employee” is the supertype entity of “Staff”, “Admin” and “Professor” subtypes and the primary key of “Employee” entity is “Emp_No”. The primary and foreign key of these subtypes are “Emp_No”. Another foreign key of “Professor” entity is “Dept_Code”.
- The overlapping constraint (o) is used as a category symbol. Here the “Employee” supertype entity has optional subtype entity.
- The “Student” table contains the details of students and every student is get advices from the “Staff” table...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
In Chapter 4, you saw the creation of the Tiny College database design, which reflected such business rules as "a professor may advise many students" and "a professor may chair one department." Modify the design shown in Figure 4.35 to include these business rules:
An employee could be staff, a professor, or an administrator.
A professor may also be an administrator.
Staff employees have a work-level classification, such as Level I or Level II.
Only professors can chair a department. A department is chaired by only one professor.
Only professors can serve as the dean of a college. Each of the university's colleges is served by one dean.
A professor can teach many classes.
Administrators have a position title.
Given that information, create the complete ERD that contains all primary keys, foreign keys, and main attributes.
In Chapter 4, you saw the creation of the Tiny College database design. That design reflected such business rules as “a professor may advise many students” and “a professor may chair one department.” Modify the design shown in Figure 4.36 to include these business rules:
An employee could be staff or a professor or an administrator.
A professor may also be an administrator.
Staff employees have a work level classification, such a Level I and Level II.
Only professors can chair a department. A department is chaired by only one professor.
Only professors can serve as the dean of a college. Each of the university’s colleges is served by one dean.
A professor can teach many classes.
Administrators have a position title.
Given that information, create the complete ERD containing all primary keys, foreign keys, and main attributes.
**Link to previous source acceptable
1. Create an EER diagram to show the following information about a university database:
Professors have an SSN, a name, an age, a rank, and a research specialty.
Projects have a project number, a sponsor name (e.g., NSF), a starting date, anending date, and a budget.
. Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S.or Ph.D.).
. Each project is managed by one professor (known as the project’s principalinvestigator).
. Each project is worked on by one or more professors (known as the project’s co-investigators).
. Professors can manage and/or work on multiple projects.
. Each project is worked on by one or more graduate students (known as the project’sresearch assistants).
. When graduate students work on a project, a professor must supervise their work onthe project. Graduate students can work on multiple projects, in which case they willhave a (potentially different) supervisor for each one.
. Departments have a department number, a department…
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
- Consider the following information about a university database: ▪ Professors have an SSN, a name, an age, a rank, and a research specialty. ▪ Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. ▪ Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). ▪ Each project is managed by one professor (known as the project’s principal investigator). ▪ Each project is worked on by one or more professors (known as the project’s co-investigators). ▪ Professors can manage and/or work on multiple projects. ▪ Each project is worked on by one or more graduate students (known as the project’s research assistants). ▪ When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. ▪ Departments have a department number, a department…arrow_forwardConsider the following business rule:An employee can manage multiple customers. A customer can be managed by multiple employees. How does this business rule(s) affect the database design? a.) The business rules define that there isn't a need for a relationship between the EMPLOYEE and CUSTOMER entities, as the relationship isn't a strong one. b.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:M relationship between those two entities. c.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and an M:N relationship between those two entities requiring a bridge table. d.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:1 relationship between those two entities.arrow_forwardDevelop an EER model for the following situation using EER notation, as specified by your instructor. An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules: • Room is identified by Building ID and Room No and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called Board Type. • Media is identified by MType ID and has attributes of Media Type and Type Description. Note: here we are tracking type of media (such as a DVD, projector, etc.), not the individual piece of equipment. Tracking of equipment is outside of the scope of this project. • Computer is identified by CType ID and has attributes of Computer Type and Type Description, Disk Capacity, and Processor Speed. Please note: as with Media Type, we are tracking…arrow_forward
- Consider the following information about a university database: • Professors have an SSN, a name, an age, a rank, and a research specialty. • Projects have a project number, a sponsor name, a starting date, an ending date, and a budget. • Graduate students have SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). • Each project is managed by one professor (known as the project’s principal investigator). • Each project is worked on by one or more professors (known as the project’s coinvestigators). • Professors can manage and/or work on multiple projects. • Each project is worked on by one or more graduate students (known as the project’s research assistants). • When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. • Departments have a department number, a department name, and a main office. • Departments…arrow_forwardConsider the following information about a university database: Professors have an SSN, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or PhD.). Each project is managed by one professor (known as the project’s principal investigator). Each project is worked on by one or more professors (known as the project’s coinvestigators). Professors can manage and/or work on multiple projects. Each project is worked on by one or more graduate students (known as the project’s research assistants). When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. Departments have a department number, a department name, and a main office.…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
- 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
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
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