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

Some Tiny College staff employees are information technology (IT) personnel. Some IT personnel provide technology support for academic programs, some provide technology infrastructure support, and some provide support for both. IT personnel are not professors; they are required to take periodic training to retain their technical expertise. Tiny College tracks all IT personnel training by date, type, and results (completed versus not completed). 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 6P
Textbook Problem
25 views

Some Tiny College staff employees are information technology (IT) personnel. Some IT personnel provide technology support for academic programs, some provide technology infrastructure support, and some provide support for both. IT personnel are not professors; they are required to take periodic training to retain their technical expertise. Tiny College tracks all IT personnel training by date, type, and results (completed versus not completed). Given that information, create the complete ERD that contains all primary keys, foreign keys, and main attributes.

Explanation of Solution

Crow’s Foot ER diagrams for Tiny College IT Staffing Solution:

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 primary of “Employee” entity is “Emp_No”.
  • The “Professor”, “Staff” and “Admin” are the subtype entities...

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 is knurling different from other lathe operations?

Precision Machining Technology (MindTap Course List)

You are to write down on a piece of paper how much (to the nearest penny) money you have on you. Your instructo...

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

Provide an overview of the systems design phase.

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

Which of the systems are equivalent to the couple in (a)?

International Edition---engineering Mechanics: Statics, 4th Edition

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

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

Explain how a power supply converts AC current into DC current.

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