Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transactions On Large Scale Data And Knowledge Centered Systems Vi Special Issue On Database And Expert Systems Applications Lncs 7600

Authors: Abdelkader Hameurlain ,Josef Kung ,Roland Wagner ,Stephen W. Liddle ,Klaus-Dieter Schewe ,Xiaofang Zhou

2012th Edition

3642341780, 978-3642341786

More Books

Students also viewed these Databases questions

Question

7. List behaviors to improve effective leadership in meetings

Answered: 1 week ago

Question

6. Explain the six-step group decision process

Answered: 1 week ago