𝑻𝑬𝑪𝑯1400 𝑫𝒂𝒕𝒂𝒃𝒂𝒔𝒆 𝑫𝒆𝒔𝒊𝒈𝒏 𝒂𝒏𝒅 𝑴𝒂𝒏𝒂𝒈𝒆𝒎𝒆𝒏𝒕 𝑨𝒔𝒔𝒆𝒔𝒔𝒎𝒆𝒏𝒕 3Assessment 3 InformationSubject Code:TECH1400Subject Name:Database Design and ManagementAssessment Title:SQL Demonstration and analysisAssessment Type:Coding

𝑻𝑬𝑪𝑯1400 𝑫𝒂𝒕𝒂𝒃𝒂𝒔𝒆 𝑫𝒆𝒔𝒊𝒈𝒏 𝒂𝒏𝒅 𝑴𝒂𝒏𝒂𝒈𝒆𝒎𝒆𝒏𝒕 𝑨𝒔𝒔𝒆𝒔𝒔𝒎𝒆𝒏𝒕 3Assessment 3 InformationSubject Code:TECH1400Subject Name:Database Design and ManagementAssessment Title:SQL Demonstration and analysisAssessment Type:Coding task and Video presentationAssessment Length:10Minutes(+/-10%)Weighting:40 %Total Marks:40Submission:Via MyKBSDue Date:Week 13Your TaskTECH1400 Database Design and Management Assessment 3 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 (Part B).TECH1400 Database Design and Management Assessment 3 HelpAssessment DescriptionIn 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.This assessment aims to achieve the following subject learning outcomes:LO1:Investigate the use of Relational Database Management Systems in organisations.LO2:Construct database models.LO4:Create queries to manage data using a database querylanguage.Assessment InstructionsPart A: SQL QueryingAs 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 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: List the departments along with the number of employees in each department. Question 5: Find 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.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?Include your SQL queries in a single .sql file and submit it to Turnitin.TECH1400 Database Design and Management Assignment 1 HelpPart B: Video ExplanationYou should record a video discussing the following: Justify each SQL query in detail, including the syntax, the purpose of the query, and theappropriate 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.Recording and Submission You can record the video presentation using Kaltura and submit the recording after reviewing. Click the below link to learn how to record using Kaltura: https://elearning.kbs.edu.au/mod/scorm/view.php?id=339347 Turn on your webcam so we can see you to assess your presentation skills. You MUST host your video recording file in Kaltura only using MyKBS portal (using any other video hosting platforms will NOT be considered for marking).Important Study InformationAcademic Integrity and Conduct Policyhttps://www.kbs.edu.au/admissions/forms-and-policiesKBS values academic integrity. All students must understand the meaning and consequences of cheating, plagiarism and other academic offences under the Academic Integrity and Conduct Policy.Please read the policy to learn the answers to these questions: What is academic integrity and misconduct? What are the penalties for academic misconduct? How can I appeal my grade?Late submission of assignments (within the Assessment Policy)https://www.kbs.edu.au/admissions/forms-and-policiesLength Limits for AssessmentsPenalties may be applied for assessment submissions that exceed prescribed limits.Study AssistanceStudents may seek study assistance from their local Academic Learning Advisor or refer to the resources on the MyKBS Academic Success Centre page. Further details can be accessed at https://elearning.kbs.edu.au/course/view.php?id=1481Generative AI Traffic LightsPlease see the level of Generative AI that this assessment has been designed to accept:Traffic LightAmount of Generative Artificial Intelligence (GenerativeAI) usageEvidence RequiredThis assessment(✓)Level 1Prohibited:No GenerativeAI allowedThis assessment showcases your individual knowledge, skills and/or personal experiences in the absence of Generative AI support.The use of generative AI is prohibited for this assessment and may potentially result in penalties for academic misconduct, including but not limited to a mark of zero for the assessment.Level 2Optional:You may use GenerativeAI for research and content generation that is appropriately referenced.See assessment instructions for detailsThis assessment allows you to engage with Generative AI as a means of expanding your understanding, creativity, and idea generation in the research phase of yourassessment and to produce content that enhances your assessment. I.e., images. You do not have to use it.The use of GenAI is optional for thisassessment.Your collaboration with GenerativeAI must be clearly referenced just as you would reference any other resource type used.Click on the link below to learn how to reference GenerativeAI.https://library.kaplan.edu.au/referencing-other-sources/referencing-other- sources-generative-aiIn addition, you must include an appendix that documents your GenerativeAI collaboration including all prompts and responses used for the assessment.Unapproved use of generative AI as per assessment details during the content generation parts of your assessment may potentially result in penalties for academic misconduct, including but not limited to a mark of zero for the assessment. Ensure you follow the specific assessment instructions in the section above.✓Level 3Compulsory:You must use GenerativeAI to complete yourassessmentSee assessment instruction for detailsThis assessment fully integrates Generative AI, allowing you to harness the technology’sfull potential in collaboration with your own expertise.Always check your assessment instructions carefully as there may still be limitations on what constitutes acceptable use, and these may be specific to each assessment.You will be taught how to use generative AI and assessed on its use.Your collaboration with GenerativeAI must be clearly referenced just as you would reference any other resource type used.Click on the link below to learn how to reference GenerativeAI.https://library.kaplan.edu.au/referencing-other-sources/referencing-other- sources-generative-aiIn addition, you must include an appendix that documents your GenerativeAI collaboration including all prompts and responses used for the assessment.Unapproved use of generative AI as per assessment details during the content generation parts of your assessment may potentially result in penalties for academic misconduct, including but not limited to a mark of zero for the assessment. Ensure you follow the specific assessment instructions in the section above.