Display how many employees will not receive a performance

Assignment Help Database Management System
Reference no: EM133638124 , Length: word count:2000

Database Design and Management

Assessment - Demonstration and analysis

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 questions 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.

Chris Taverly, the member of the leadership team at UoA was impressed with your previous work and has approached you for a second time, asking you more questions. Chris has asked you for to retrieve more data from the database and has also asked you to examine the integrity of the database. 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: Add a new attribute called "EmployeeInitials" to the Employees table

Question 2: Display the first names of all employees who work in the department located in Sydney

Question 3: Display employee first and last names and work out the original salary for all employees and their new salary after their (10%) bonus is applied

Question 4: Display how many employees will not receive a performance bonus

Question 5: Write a query that returns the employees with initials that are a palindrome and also return employees without palindrome initials, but output 'not a palindrome!'

Question 6: Write a query that populates EmployeeInitials, based off the existing stored names

Question 7: Which joins did you use in your queries and why? Would other joins have worked?

Question 8: Write 250 words explaining the integrity of this database. Is it up to standards? If yes, explain why and how. If no, what is wrong with the database's integrity?

Attachment:- Database Design and Management.rar

Reference no: EM133638124

Questions Cloud

What are the ways you can foster a high-performance culture : What are some of the ways you can foster a high-performance culture focused on teamwork and success within your new business venture?
Political era-reforms era and community policing era : The political era The reforms era, and Community policing era. Each of the historic era has its unique developments as will be discussed in this presentation.
What will be your businesss organizational structure : You will also have to decipher what will be your business's organizational structure, and how it will help develop and build a high-performance culture.
Explain the difference between fixed and variable costs : Explain the difference between fixed costs and variable costs. Discuss at least three ways Ford can use CVP analysis for managerial decision making.
Display how many employees will not receive a performance : Display employee first and last names and work out the original salary for all employees and their new salary after their (10%) bonus is applied
American affordable care act : Reflect on the implications of the public's lack of awareness regarding American Affordable Care Act (Obama Care)
The interests of national security : The interests of national security Topic Description This act allowed government censorship of the mails and imprisonment of those who interfered with the draft
How tvm principles are relevant to accounting practices : Define the Time Value of Money (TVM) and its significance in financial decision-making. Explain how TVM principles are relevant to accounting practices.
Constitution establishes branches of federal government : The Constitution establishes three branches of the federal government, with each have its own individual responsibilities and powers.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd