I have this so far but I\'m not sure. should I make two blocks for Administrator

Question

I have this so far but I'm not sure. should I make two blocks for Administrators?

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 A large hospital has different types of employees. An employee belongs to one and only one of the following categories: Doctors, Nurses, or Administrators. Administrators are classified as staff or technical personnel, or both All employees have common attributes - ID, first and last name, and address. In addition, employees have unique characteristics. The list of such attributes includes but is not limited to the following: the area of specialization (doctors), the number of years of experience (nurses), and the title (administrators). Also, the hourly rate for staff employees and classification level for technical personnel must be recorded Each employee creates one record in the HR COMMENT table that contains HR interview comments for an employee. Each record in the HR COMMENT table is related to one employee

Explanation / Answer

Hi, your ERD is very well implemented. It will fetch you good marks, as per the admin block is concerned see the below impementation. Admin type has been added to seggregate amins based on the category. this category is only for administrators hence added a new admin_type cloumn.

Also you missed the Rate module.

Administrator

FK PK Emp_id

Tile

admin_type

Rate

Rate_id

Rate_amount

Fk Type

Type will be the foreign key to emp_type and admin_type.

I have solved your question. Please do not forget to give a positive like to the answer. Thank you.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---