Reference no: EM131659961

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)