A recruitment firm, uses the Position.xlsx spreadsheet to keep track of all the open positions it needs to fill. Additional information on employers, such as the industry code and location (state/province) of each employer in Position.xlsx, can be found in Employer.xlsx. Descriptions of each industry code and location are available in NAICS.xlsx and Location.xlsx, respectively. Design a database for this firm.
i. To this end, provide an E-R diagram that shows entities, relations, and their cardinalities
Position.xlsx
PositionID int
PositionTitle varchar(50)
EmployerID varchar(5)
Wage Money
HoursPerWeek int
Experience bit
Openings int
Employer.xlsx EmployerID varchar(5) ,EmployerName varchar(50), StreetAddress varchar(50), City varchar(50), StateProv varchar(2), PostalCode varchar(7), Country varchar(50), ContactFirstName varchar(50), ContactLastName varchar(50), Position varchar(50), Phone varchar(10), Website bit, NAICSCode varchar(6), Comments varchar(255), must allow NULL
NAICS.xlsx NAICSCode varchar(6), NAICSDesc varchar(50)
Location.xlsx Abv varchar(2), Location varchar(50)