1. Using the following tables: CLIENT, ENROLLMENT, CLASS, TRAINER, QUALIFICATION, and COURSE And answer the following question: a) In what normal forms are these tables (six tables used in this problem)? b) If not in 3NF, then convert them to 3rd normal form. 2. Select problem 1 from assignment 1 and add subtypes: a) For patient treatment add outpatient, admitted patient, emergency room patient b) For Doctors add affiliated or guest doctor c) Do the same for nurses

SUGGESTED RELATIONAL SCHEMA MEMBERSHIP TYPE Code Duration Price Discount MEMBERSHIP Client No Code Date Price Paid CLIENT Client No First Name Last Name Street City State Zip Phone In itial Date ENROLLMENT Client No Reference No Date/Time Fee Paid CLASS Reference No Start Date Room No Employee No | Course Code ROOM Room No Capacity PC Type Connection TRAINER Employee No| First Name Last Name Stree City State Zip Phone E-Mail Address QUALIFICATION Employee No Course Code Date COURSE Course Code Course Name Length Fee Required PC Type ISBN PREREQUISITE Course Code Prerequisite UTILIZATION Course Code | Program Code SOFTWARE Program Code Program Name Publisher Licenses Required OF BOOK AUTHOR. ISEN First Name Last Name BOOK ISBN Title Publisher List Price ORDERLINE ISBN Order No Quantity Actual Price ORDER Order No Order Date Status endor Name VENDOR. Vendor Name Street City State Zip Phone