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)           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 (2.5 marks)  Question 2: Display the first names of all employees who work in the department located in Sydney (10 marks)  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 (10 marks) Question 4: Display how many employees will not receive a performance bonus (12.5 marks) 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!’ (15 marks) Question 6: Write a query that populates EmployeeInitials, based off the existing stored names (15 marks) Question 7: Which joins did you use in your queries and why? Would other joins have worked? (15 marks) 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? (20 marks)

Global Business Assignment Portfolio Brief Please include the following in the portfolio; A. Individual Notes 1(400words)Conduct an online research on The European Union(EU). What are the pros and cons of the EU? B. Individual Notes 2(1,600words)Critically discuss the reasons why Multinational Corporations (MNC) internationalize and the typical challenges they encounter. C. Individual Report (1,200words)Select an

A critical evaluation of an infection prevention and control practice, procedure, or policy Description A critical evaluation of an infection prevention and control practice, procedure, or policy Critically assess an infection control practice, procedure or policy in your work area. Synthesising your infection control knowledge, safety and cost effectiveness & where appropriate, the need to respect cultural

OUTLINE FOR THESIS Introduction: ·       Education and training are essential to create a living and future for yourself in the United States. ·       The U.S growth model is designed for a skilled workforce through education or training, but instead of funding this type of workforce the government has placed the burden on the student. By

Create a SOAP note for disease prevention, health promotion, and acute care of the patient in the clinical case. Your care plan should be based on current evidence and nursing standards of care. In addition, consider visiting government sites such as the CDC, WHO, AHRQ, Healthy People 2020. Provide a detailed scientific rationale justifying the

DIRECTIONS  To successfully complete this assignment, you need to have completed the following activities in Session 4: ·        Textbook readings ·        H5P activities ·        Watched the following video: o   “The danger of a single story”   ASSIGNMENT REQUIREMENTS   ·       This assignment is to be completed and submitted during Session 4. ·       Save the document

The paper should capture the individual’s most important contributions to Philadelphia and (if possible) America’s life and society, along with critical events that prepared, led up to, or otherwise qualified that individual by training, employment, or experience, for a place on the public stage. Be creative. Writing “profile pieces” is something of an art: It

GDECE 103 Language and Literacy in the Early Years: Assessment 3 Rubric Task description: Develop two sequences of learning activities around picture books appropriate for 2-3 year olds and 4-5 year olds. Base each sequence on a quality text, analysis of the texts’ affordances for early years literacy and understanding of childhood development in the

Module Code: QHO320 Module Title: Understanding Finance Assessment Title: Budget Report Assessment Scenario Gaia Ltd is an established vehicle manufacturer operating across the UK and Europe. The directors of Gaia Ltd are considering expanding manufacturing of their new Electric Vehicle (EV), named the Gaia Niche, over the next 12 months. PART A (35% weighting)                                       The

Create a 3-5 page submission in which you develop a PICO(T) question for the diagnosis you worked with in the first two assessments and evaluate the evidence you locate, which could help to answer the question. PICO(T) is an acronym that helps researchers and practitioners define aspects of a potential study or investigation. It stands