Question: A relational schema, normalized to at least third normal form ( 3 NF ) EMPLOYEE ( EMPLOYEE _ ID , EMPLOYEE _ FIRSTNAME, EMPLOYEE _

A relational schema, normalized to at least third normal form (3NF)
EMPLOYEE (EMPLOYEE_ID, EMPLOYEE_FIRSTNAME, EMPLOYEE_LASTNAME, EMPLOYEE_SALARY, EMPLOYEE_TYPE, EMPLOYEE_ADDRESS, EMPLOYEE_EMAIL, EMPLOYEE_PHONE)
MANAGER (EMPLOYEE_ID, MANAGER_ID, MANAGER_TYPE, MANAGER_ADDRESS, MANAGER_ZIPCODE, MANAGER_PHONE, NUM_EMPLOYEES)
INSTRUCTOR (EMPLOYEE_ID, INSTRUCTOR_CERTIFICATION, NUM_CLASSES, INSTRUCTOR_ADDRESS, INSTRUCTOR_ZIPCODE, MANAGER_ID)
EQUIPMENT (EQUIPMENT_ID, EQUIPMENT_NAME, EQUIPMENT_SOURCE, SOURCE_EMAIL, EQUIPMENT_COST, EQUIPMENT_NUM, EMPLOYEE_ID)
MEMBER (MEMBER_ID, MEMBER_FIRSTNAME, MEMBER_LASTNAME, MEMBER_AGE, MEMBER_ADDRESS, MEMBER_EMAIL, MEMBER_PHONE, MEMBER_GENDER, MEMBER ZIPCODE, EMPLOYEE_ID)
ENROLLMENT (MEMBER_ID, CLASS_ID, CLASS_ENROLL_DATE)
CLASS (CLASS_ID, CLASS_NAME, CLASS_TIME, CLASS_SIZE, CLASS_DATE, EMPLOYEE_ID)
MEMBERSHIP (MEMBERSHIP_ID, MEMBERSHIP_TYPE, MEMBERSHIP_SIGNDATE, MEMBERSHIP_RENEWAL, MEMBERSHIP_COST, MEMBER_ID)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!