menu
bartleby
search
close search
Hit Return to see all results
close solutoin list

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.

BuyFindarrow_forward

Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900
Chapter 5, Problem 4P
Textbook Problem
124 views

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.

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...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 5 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
add

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
How would you define artificial intelligence?

Fundamentals of Information Systems

Which security protocols are used to protect e-mail?

Principles of Information Security (MindTap Course List)

What is the role of the US-CERT organization?

Fundamentals of Information Systems

List and describe three popular job-finding Web sites.

Principles of Information Systems (MindTap Course List)

Briefly define a taper.

Precision Machining Technology (MindTap Course List)

Discuss in detail at least two methods or procedures that can be employed by airline companies to pick up your ...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Provide three examples each of closed-ended. open-ended, and range-of-response questions.

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

Define valve margin.

Automotive Technology

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

Differentiate among the features of the Android, iOS, and Windows Phone mobile operating systems.

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

How can the ends of a pipe be beveled?

Welding: Principles and Applications (MindTap Course List)