Sql demonstration and analysis assessment

Assignment Help PL-SQL Programming

Reference no: EM133877399

Assessment - SQL Demonstration and analysis

Coding task and Video presentation

Task

This assessment evaluates your SQL querying proficiency and your ability to justify and explain query logic. You will receive a database schema, data, and a scenario. You can use Gen AI tools for specific tasks only. The assessment consists of a SQL query task (Part A) and a detailed video explanation

Assessment Description

In this assessment, you will use a case study provided as a supplementary document. Your task is to retrieve data on the given database using MySQL to find answers to the questions in the Assessment Instructions. The database contains thousands of rows of data, making it impractical to find answers manually.

Learning outcome 1: Investigate the use of Relational Database Management Systems in organisations.
Learning outcome 2: Construct database models.
Learning outcome 3: Create queries to manage data using a database query language.

Assessment Instructions

Part A: SQL Querying

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. In addition, you can use Gen AI tools to get an idea about how to answer Questions (1 - 10) only, and responses to the SQL queries should be restricted to only the clauses used in workshop materials.

Question 1: Display the first names of all employees who work in the department located in Sydney in alphabetical order.

Question 2: Show employees who have worked at the University the shortest amount of time. Question 3: Display the names of all employees whose age is a palindrome.

Question 4: Create a procedure to list the departments along with the number of employees in each department.

Question 5: Create a function that finds the average salary of employees in each department. Question 6: Find the names and salaries of employees who are older than 40 years.

Question 7: Show the employee details and their department names for those employees who have a "Lecturer" title.

Question 8: Display employees' first and last names and work out the original salary for all employees and their new salary after their (10%) bonus is applied. Hire best assignment help and experienced tutors now!

Question 9: Add a new attribute called "EmployeeInitials" to the Employees table.

Question 10: Write a query that populates "EmployeeInitials", based off the existing stored names.

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

Part B: Video Explanation
You should record a video discussing the following:

Justify each SQL query in detail, including the syntax, the purpose of the query, and the appropriate output.
Ensure your video is clear and audible.
Show your SQL queries and the database schema while you explain.
Keep your explanation concise and focused within a 9-minute to 11-minute timeframe.

Reference no: EM133877399

Questions Cloud

Create a safe and neutral environment : Create a Safe and Neutral Environment: Encourage open communication where both feel heard without judgment. Understand Each Perspective.

Discuss ethical use of social media in clinical practice : A practitioner shared a humorous clinical anecdote on social media. While the post did not mention client names, it raised important ethical concerns.

Which statements by a student indicate they may experiencing : A school nurse is serving on the crisis team to care for group. Which statements by a student indicates they may be experiencing posttraumatic stress disorder?

Which type of discipline did she use : Justin's mother asked Justin to put away. After asking him for a third time, she took the cell phone away for three days. Which type of discipline did she use?

Sql demonstration and analysis assessment : SQL Demonstration and analysis Assessment - evaluates your SQL querying proficiency and your ability to justify and explain query logic.

Why do counselors do a dsm-5-tr assessment on clients : Why do counselors do a DSM-5-TR assessment on clients?

Consider that one is constructing a test for test anxiety : Consider that one is constructing a test for test anxiety? What would you include in a assessment of an individuals level of test anxiety?

Characteristics that could point to lifelong symptoms : Identify the characteristics that could point to lifelong symptoms when a personality disorder is suspected.

Analysis uses information in your risk management plan : Management plan to discuss the impact to the business, incident response and recovery plan which to bring the business back to normal conditions

User Account

All Pages