A hospital wants to enhance its database system. They have to manage staff, including doctors, nurses, and administrative employees.
All staff members have common attributes:
• Staff_ID
• Name
• Hire_Date
• Contact_Info
Doctors have extra attributes:
• Specialization
• License_Number
• Years_of_Experience
Nurses have:
• Certification
• Level_and_Skill
• Training
Administrative staff have:
• Department
• Job_Title
Each staff member must belong to one and only one category (doctor, nurse, or admin).
October 27, 2025 2.5K 3
