Database Project Database Administrator Position . Starting date 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 r a. Create and Name the database DP_ITE120 YourastnameFirstname. (5points) (Lee John) Create two tables: Candidates, and IobQnenings. Create the fields for each table using fbelow.(70 points for each table: 140 points total) b. the suggested fields below. Populate the tables with records indicated in e and c. Include a field to rank each candidate on a scale of 1 to 5 (5 is highest) d. Set the table relationship between Candidates and IobQnenings. Enforce the referential integrity. (45 points) Add 10 candidates - yourself and 9 other students in your class in the Candidates table. (Can be any name) Add the Database Administrator job and four (4) other sample jobs in the e. f. 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. (10 points) g. h. Close the database. Submit it in Blackboard in the Database Project dropbex link in the Database Project folder under Projects/Study Guides tab Candidates tab Candidate ID (to be used as primary key) First Name Middle Name . Last Name Address .Zip code State Gender Rankin Highest degree Field of study Job Number (to be used as foreign key) . tabl Job Number (to be sued as primary key) . Title escription . Yearly Wage