Can anyone please help me with this project ( step by step) . Thank you You arri
ID: 3856413 • Letter: C
Question
Can anyone please help me with this project ( step by step) . Thank you
You arrive at Secure Systems, Inc., for a database administrator position interview. After meeting the Human Resources coordinator, you are given a test to demonstrate your skills in Access. You are asked to create a database from scratch to keep track of all the candidates for the positions currently open at Secure Systems. (We assume that a given candidate can be interviewed for one job opening/position only, and for a given job opening/position many candidates can be interviewed.)
Use these requirements using Microsoft Access:
Create and Name the database DP_ITE120_YourLastnameFirstname.
b.Create two tables: Candidates, and JobOpenings. Create the fields for each table using the suggested fields below. Populate the tables with records indicated in e and f below.
Include a field to rank each candidate on a scale of 1 to 5 (5 is highest).
Set the table relationship between Candidates and JobOpenings. Enforce the referential integrity.
Add 10 candidates – yourself and 9 other students in your class in the Candidates table.
Add the Database Administrator job and four (4) other sample jobs in the JobOpenings table.
Create a query that lists all the database Administrator interviews with a ranking of 4 or 5. Add the last name and first name of the candidate to the query design. Run and save the query. Choose a name for the query.
Suggested fields for the Candidates table:
Candidate ID (to be used as primary key)
First Name
Middle Name
Last Name
Address
Zip code
State
Gender
Ranking
Highest degree
Field of study
Job Number (to be used as foreign key)
Suggested fields for the JobOpenings table:
Job Number (to be sued as primary key)
Title
Description
Yearly Wage
Starting date
Explanation / Answer
Below are the Candidate and Job openings tables for the database DP_ITE120:
Candidate Table
Candidate ID
First Name
Middle Name
Last Name
Address
Zip code
State
Gender
Ranking
Highest degree
Field of study
Job Number
501
Kavita
Rani
Padala
Vizag
500048
AP
F
5
BTech
ECE
1
502
Syamala
Devi
Buddaraju
Hyderabad
500048
Telangana
F
3
BTech
CSE
2
503
Leela
Padmaja
Tallapudi
Vizag
500048
AP
F
3
BCom
IT
3
504
Shruthi
Vancha
Hyderabad
500048
Telangana
F
3
BTech
CSE
4
505
Kiran
Kumar
Padala
Hyderabad
500048
Telangana
M
4
BTech
ECE
5
506
Kalyan
Akasam
Vizag
500048
AP
M
5
BCom
IT
4
507
Vara
Cheekati
Hyderabad
500048
Telangana
F
2
MTech
Electronics
2
508
Rajesh
Kumar
Jinaga
Vizag
500048
AP
M
1
BTech
CSE
1
509
Pallavi
Akasam
Hyderabad
500048
Telangana
F
3
BTech
ECE
5
510
Priya
Kranthi
Pallam
Hyderabad
500048
Telangana
F
3
MTech
Electronics
1
Job Openings Table
Job Number
Title
Description
Yearly Wage
Starting date
1
Database Administrator
Database Administrator
6000$
30/05/17
2
Network Security
Network Security
5500$
03/06/17
3
Software Analyst
Software Analyst
6500$
12/06/17
4
System Architect
System Architect
7000$
25/07/17
5
Technical Analyst
Technical Analyst
5000$
30/05/17
Create a query that lists all the database Administrator interviews with a ranking of 4 or 5:
SELECT TITLE, STARTING DATE
FROM JOB OPENINGS
WHERE JOB NUMBER =
(SELECT JOB NUMBER
FROM CANDIDATE
WHERE RANKING > 3)
Candidate ID
First Name
Middle Name
Last Name
Address
Zip code
State
Gender
Ranking
Highest degree
Field of study
Job Number
501
Kavita
Rani
Padala
Vizag
500048
AP
F
5
BTech
ECE
1
502
Syamala
Devi
Buddaraju
Hyderabad
500048
Telangana
F
3
BTech
CSE
2
503
Leela
Padmaja
Tallapudi
Vizag
500048
AP
F
3
BCom
IT
3
504
Shruthi
Vancha
Hyderabad
500048
Telangana
F
3
BTech
CSE
4
505
Kiran
Kumar
Padala
Hyderabad
500048
Telangana
M
4
BTech
ECE
5
506
Kalyan
Akasam
Vizag
500048
AP
M
5
BCom
IT
4
507
Vara
Cheekati
Hyderabad
500048
Telangana
F
2
MTech
Electronics
2
508
Rajesh
Kumar
Jinaga
Vizag
500048
AP
M
1
BTech
CSE
1
509
Pallavi
Akasam
Hyderabad
500048
Telangana
F
3
BTech
ECE
5
510
Priya
Kranthi
Pallam
Hyderabad
500048
Telangana
F
3
MTech
Electronics
1