Question

Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows:

• In a small IT company, each assignment is related to performing a tech check up or working on a new project. All assignments share common attributes such as the assignment code and the description. In addition, unique attributes are used to describe each type. The list of such attributes includes but is not limited to the following: the total number of hours spent on the check up procedures (tech check up) and project requirements (new project).
• Working on a new project assumes either developing a new software system or implementing a hardware solution. Both categories have unique attributes.
• Each assignment is managed by one employee. One employee can manage one assignment only.