STEP 1: create a new database and name it with a name composed of your surname and UCD student number (example: smith123456). Do not use either capital letters or any special character (e.g., apostrophes).
STEP 2: your database will represent the following scenario: “Departments in a company advertise vacant positions which require specific skills (e.g., administrative, managerial, etc.). Candidates may be invited to interviews for the positions”.
Your database must include the following information and may include any other information that you consider necessary for representing the concepts and implementing the queries listed below:
• Candidate details: candidate identifier, firstname, surname, address, telephone number, skills.
• Department details: department identifier, department name, address, telephone number.
• Position details: position identifier, department offering the position, type of position, skills required.
• Interview details: you must decide what information should be used to best represent this
concept based on the constraints and information provided below.