Log out Go to App
Go to App

Learning Materials

Features

Discover

Chapter 7: Problem 34

What problems arise if one makes the supervises relationship mandatory for either the supervising employee or the employee who is supervised?

Short Answer

Expert verified
Making the 'supervises' relationship mandatory for either the supervising employee or the supervised employee can lead to problems due to the hierarchical nature of most organizations. For the supervising employee, it can result in inaccurate data as not every employee supervises others. For the supervised employee, high-level employees such as CEOs who do not have supervisors could be misrepresented.

Step by step solution

01

Understanding Supervision in an Organizational Structure

In an organizational structure, there are employees who supervise other employees. This hierarchical supervision can be represented in a database by a 'supervises' relationship between two employees.
02

Problems with Mandatory Supervision for Supervising Employee

If the supervises relationship is made mandatory for the supervising employee, that means every employee must supervise someone else. This is problematic because in most organizations, not all employees supervise others. For example, junior or new employees might not supervise anyone. This could lead to inaccurate or incomplete data in the database.
03

Problems with Mandatory Supervision for Supervised Employee

If the 'supervises' relationship is made mandatory for the supervised employee, that means every employee must be supervised by someone else. This may also result in issues because in some organizations there are employees at the top of the hierarchy such as CEOs who do not typically have direct supervisors.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Start your free trial

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

In some large organizations where there are several buildings and floors we see room numbers that encode information about the building, floor, and room number. For example in case the room 3C13 stands for room 13 on the third floor of the Centennial building. Suppose we need to include Room in an ERD. How would you represent the room number given that you must include atomic attributes only?

Consider a marriage entity type and attributes marriage date, marriage location, husband, wife. Each marriage will only have one value for each of these attributes. Illustrate the marriage entity and its single-valued attributes in an ERD .

A college or university will keep track of several addresses for a student, but each of these can be named differently: for example, consider that a student has a mailing address and a home address. Create an ERD for a student entity type with two composite attributes for student addresses where each comprises several single-valued attributes.

Consider a library and the fact that books are loaned out to library members. Dates could be used heavily for the date a book was borrowed, the date the book was returned, and the due date for a book. Consider an entity type Loan that has attributes book identifier, member identifier, date borrowed, date due, date returned. What combination of attributes would be a key? Which attributes are key attributes? Which attributes are non-key attributes?

Consider an educational environment where the institution tracks the performance of each student. Often this is called the students overall average, or overall grade point average. Is such an attribute a derived attribute? How is its value determined?
See all solutions

Recommended explanations on Computer Science Textbooks

Functional Programming

Read Explanation

Data Representation in Computer Science

Read Explanation

Problem Solving Techniques

Read Explanation

Game Design in Computer Science

Read Explanation

Computer Systems

Read Explanation

Data Structures

Read Explanation
View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free