Name: ________________________________________________ worksheet 08B Suppose an entity must be split into two disjoint groups (e.g. hourly employees and salaried employees, students and faculty, residences and businesses, city residents and county residents). Here is how to do it: create a table for the entity create a table for one of the disjoint groups join this group’s table to the entity table create a table for the other disjoint groups join this group’s table to the entity table Split employees into hourly employees and salaried employees Employee Employee Hourly Monthly Id Name wage salary Split members into students and faculty University Faculty Id Faculty’s Student Id Student’s dept major Split addresses into residents and businesses City Resident’s name Resident’s Business Business address name address Split residents into city and county City Name City Resident’s County Name County Resident’s name name
Name: ________________________________________________ worksheet 08B Suppose an entity must be split into two disjoint groups (e.g. hourly employees and salaried employees, students and faculty, residences and businesses, city residents and county residents). Here is how to do it: create a table for the entity create a table for one of the disjoint groups join this group’s table to the entity table create a table for the other disjoint groups join this group’s table to the entity table Split employees into hourly employees and salaried employees Employee Id Employee Name Hourly wage Monthly salary Split members into students and faculty University Faculty Id Faculty’s dept Student Id Student’s major Split addresses into residents and businesses City Resident’s name Resident’s address Business name Business address Split residents into city and county City Name City Resident’s name County Name County Resident’s name