Write a query to display all male and female employees

Assignment Help Database Management System

Reference no: EM133512205 , Length: word count:1500

Database Design and Management

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.

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

Questions Cloud

Social work intervention from the micro level dimensions : From the Amandi case study, identify at least three issues for social work intervention from the Micro Level dimensions

Identify some themes that may emerge around it failures : Identify the 2 most significant challenges you would see as being important to IS managers in the current environment (you can talk about this from any

How will these practices improve a patients outcomes : Write a 1 to 2 pages paper about some of the Best Practices you have learned about during this course. How will these practices improve a patient's outcomes?

What is risk management initiative in healthcare : What is a risk management initiative in healthcare? What is the impact of the initiative has on creating a culture of safety?

Write a query to display all male and female employees : TECH1400 Database Design and Management, Kaplan Business School - Show employees who have worked at the University the shortest amount of time

Write your feeling about josie and culture of hiding mistake : Write your feelings about Josie and the culture of hiding mistakes and the approximately 98,000 persons that die each year in America because of medical errors.

Face-to-face and voice-to-voice communication in workplace : The use of digital communication has overtaken face-to-face and voice-to-voice communication in the workplace.

Determine the nature of communications occurring : determine the nature of communications occurring between the source and destination endpoints (or IP addresses). What differentiates the DNSquery from the TCP

Consider before entering the new market : If the company's top management decides to go international, what are some of the things to consider before entering the new market?

User Account

All Pages