Show employees who have worked at the university

Assignment Help PL-SQL Programming

Reference no: EM133618434 , Length: word count:1000

Database Design and Management Kaplan Business School

Assessment - Demonstration and plan

Your Task

This demonstration assessment is to be completed individually.
You will be given a database schema, data, and a scenario.
You are to carefully analyse the database, ensuring you understand the stored data.
You must write an SQL query for each question below.
You must also answer the additional question at the end of the assessment.

Assessment Description

University of Australia (UoA) is a university with 24 departments located all across Australia. These departments act as the work-space for each student and employee, with a total of 20,000 employees working at UoA.

You have been hired by UoA as a Database Administrator to do some data retrieval on their database. You have been given the database schema and data, as seen below.

160_Database schema.jpg

Employees(EmployeeID, DepartmentID, SalaryID, Title,
EmployeeFirstName , EmployeeLastName, Gender, yearHired,
birthyear, PerformanceBonus)
Departments(DepartmentID, DepartmentName, Location)
SalaryClass(SalaryID, Salary)
DepartmentEmployee(EmployeeID, DepartmentID)

A member of the leadership team at UoA, Chris Taverly, is interested in the data stored in this database and has asked you a variety of questions. As there are thousands of rows of data in this database, it is not possible to find answers to these questions by eye. You are asked to use MySQL to find the answers to the questions below.

Data Files

Once found on MyKBS, you must download the following files:

Assessment_Database.sql Assessment_Employee_Data.sql Assessment_Data.sql

Assessment Instructions

As an individual, you must download the database and data files and load them into MySQL. Once loaded, you must develop queries for the following questions:

Note: You should include a comment above each query, specifying which question you are answering.

Question 1: Show the first five thousand employees in the employees table

Question 2: Display all employee first names in alphabetical order

Question 3: Show employees who have worked at the University the shortest amount of time

Question 4: Display the names of all employees whose age is a palindrome

Question 5: Write a query to display all male and female employees who were not born in 1993 and who will not receive a performance bonus

Question 6: Is there anything in this database that you would improve? If no, explain why. If yes, what would you change and why? (200 words) You must include this in your .sql file as a comment)

Reference no: EM133618434

Questions Cloud

Efforts of one group to eradicate opposing groups : Is the term used to describe the efforts of one group to eradicate opposing groups by such activities as murder, rape,

Continually recruiting more revolting enslaved people : It was able to evade Roman tracking units by confusing its route. It was continually recruiting more revolting enslaved people, which made it harder to defeat.

Genocide is so reprehensible and indefensible : Genocide is so reprehensible and indefensible that it is difficult to read the perspectives of the perpetrators as you have here.

Hobbies bridge act authorizes modification of bridges : The Hobbies Bridge Act authorizes the modification of certain bridges over navigable waters of the United States,

Show employees who have worked at the university : Database Design and Management - Write a query to display all male and female employees who were not born in 1993 and who will not receive a performance

Significantly influences women religious practices : create a title for my thesis "In South Africa, marital status significantly influences women's religious practices, with single, married, divorced,

Discuss how anti-black prejudice : Drawing from the film, Ethnic Notions, discuss how anti-Black prejudice in America has been intentionally produced historically by white society

Perform routine business activities in alignment : Illustrate how information systems are used to perform routine business activities in alignment with business strategies

Fair Labor Standards Act : With the passage of the Fair Labor Standards Act in 1938 the Federal Government for the first time guaranteed what?

User Account

All Pages