Do some data retrieval on their database

Reference no: EM133691660

Database Design and Management

Demonstration and plan

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

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.

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: EM133691660

Questions Cloud

Determine how many characters are in a string : String characters can be manipulated using the charAt() method. You can use the length() method to determine how many characters are in a string.

How do the learning and discussion from the classes : how do the learning and discussion from the classes to date translate to the corporate setting?" based on your own experiences in the workplace

What were two ways that we linked a custom tooltip page : This allowed us to add more context to visual than traditional tooltip would. What were two ways that we linked a Custom Tooltip page to our report in Power BI?

Relationship between federal government and state government : Identify a contemporary issue concerning the relationship between the federal government and state government, and discuss the most likely future scenarios.

Do some data retrieval on their database : Display all employee first names in alphabetical order - it is not possible to find answers to these questions by eye. You are asked to use MySQL

What are two steps that should taken once a report published : What are two steps that should be taken once a report has been published to the DEV environment?

What are some of the benefits of version control : Development & Deployment Whilst having many iterations gives us benefits in terms of speed and agility. What are some of the benefits of version control?

Which true about working with groups for enterprise security : BI Collaboration Azure Active Directory allows us to better manage permission across multiple. Which are true about working with groups for enterprise security?

Analysis of sexual and nonsexual serial murder cases : Rossmo proposed the concept of "hunting pattern" to characterize the methods adopted by offenders in searching for a suitable target and attacking their victim.

User Account

All Pages