Bell State University Scenario Draw a detailed ERD with primary keys, foreign keys, and all provided attributes. If none are given in the scenario, provide at least one additional attribute for each entity. Scenario: When a person applies for a staff position Bell State University in the Chicago area, information about that person, including his or her social security number, name, address, and phone is stored. People applying for staff positions do not apply for a specific job, but apply for a job class. For example, a person might apply for a “Java programmer” job class position. Information stored about each job class includes a unique job code, a description, and a pay range. Each job applicant is assigned to an employment rep who processes the application and helps the job applicant with any questions. Information stored about the employment reps include their unique employee numbers, names, and phone numbers. Job applicants are not restricted to applying for a single job class; they may be qualified for several. Bell State University needs to keep track of the date an applicant applied for a specific job class because it deletes applications that are more than a year old. The Bell State has a policy that once it assigns an employment representative to an applicant, that representative will remain assigned to the applicant even if the applicant applies more than once.
Bell State University Scenario
Draw a detailed ERD with primary keys, foreign keys, and all provided attributes. If none are given in the scenario, provide at least one additional attribute for each entity.
Scenario:
When a person applies for a staff position Bell State University in the Chicago area, information about that person, including his or her social security number, name, address, and phone is stored. People applying for staff positions do not apply for a specific job, but apply for a job class. For example, a person might apply for a “Java programmer” job class position. Information stored about each job class includes a unique job code, a description, and a pay range. Each job applicant is assigned to an employment rep who processes the application and helps the job applicant with any questions. Information stored about the employment reps include their unique employee numbers, names, and phone numbers. Job applicants are not restricted to applying for a single job class; they may be qualified for several. Bell State University needs to keep track of the date an applicant applied for a specific job class because it deletes applications that are more than a year old. The Bell State has a policy that once it assigns an employment representative to an applicant, that representative will remain assigned to the applicant even if the applicant applies more than once.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
