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

### Database Systems: Design, Implemen...

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

Chapter
Section

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

Find more solutions based on key concepts
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)