#Question11

[punjabassignmenthelpaus]

TECH1400 Database Design and Management

Assessment 3 Information

Subject 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:Week13

Your 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 (Part B).

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 My SQL 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 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 (110)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.

Question2: 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.

Question5: 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.

Question8: Display employees’ first and last names and workout the original salary for all employees and their new salary after their (10%) bonus applied.

Question9: Add a new attribute called “Employee Initials” to the Employees table.

Question 10: Write a query that populates “Employee Initials”, based off the existing stored names. Question11:Write250wordsexplainingtheintegrityofthisdatabase. 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 via MyKBS.

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 to11-minute time frame.

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 Information

Academic Integrity and Conduct Policy

MY KBS 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)

Length Limits for Assessments

Penalties may be applied for assessment submissions that exceed prescribed limits.

Study Assistance

Students may seek study assistance from their local Academic Learning Advisor or refer to their sources on the MyKBS Academic Success Centrepage. Further details can be accessed at https://elearning.kbs.edu.au/course/view.php?id=1481

Generative AI Traffic Lights

Please see the level of Generative AI that this assessment has been designed to accept:

Traffic Light

Amount of Generative Artificial Intelligence (Generative AI) usage

Evidence Required

This assessment

(✓)

Level1

Prohibited:

No Generative AI allowed

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

Level2

Optional:

You may use Generative AI for research and content generation that is appropriately referenced.

See assessment instructions for details

This assessment allows you to engage with Generative AI as a means of expanding your understanding, creativity, and idea generation in the research phase of your assessment and to produce content that enhances your assessment. I.e., images. You do not have to use it.

The use of Gen AI is optional for this assessment.

Your collaboration with Generative AI must be clearly referenced just as you would reference any other resource type used.

Click on the link below to learn how to reference Generative AI.

https://library.kaplan.edu.au/referencing

-other-sources/referencing-other-sources-generative-ai

In addition, you must include an appendix that documents your Generative AI 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.

✓

Level3

Compulsory:

You must use Generative AI to complete your assessment

See assessment instruction for details

This assessment fully integrates Generative AI, allowing you to harness the technology’s full 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 Generative AI must be clearly referenced just as you would reference any other resource type used.

Click on the link below to learn how to reference Generative AI.

https://library.kaplan.edu.au/referencing

-other-sources/referencing-other-sources-generative-ai

In addition, you must include an appendix that documents your Generative AI 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.

[thereluctantbadger]

Christmas countdown question11. Your hosting a Christmas dinner you can invite any 10 celebrities dead or alive. Who do you invite?

Again, so sorry I'm late for these!

Ooo this is a tricky one. Not sure if I could think of ten, but I'll do my best!

Charles Dickens (because why not invite him to a Christmas dinner??)

Abraham Lincoln

My great grandfather on my dad's side (immigrated from Romania and from what I hear he was a very interesting man)

My great grandmother on my dad's side (same reason)

Betty White

[ask-me-a-question11]

Best

“You’re the best,” he says,

but am I?

because you always want the best,

and yet you don’t want me.

-ask-me-a-question11

[flapper-dai]

Aquarius 髙橋大輔の踊る全力クイズ！Question11  [ Speed Skating ]

[adlermorgann]

kaplan-university AC 551 Unit 4 Assignment Questions NEW

 Check this A+ tutorial guideline at

 http://www.uopassignments.com/ac-551-kaplan-university/ac-551-unit-4-assignment-questions-recent

 For more classes visit

http://www.uopassignments.com/

 Question 8. Does the Codification contain all GAAP authorities? Explain Question11. What are the SEC accounting authorities? Where are they located?   Questions 12. Does the Codification contain SEC authorities? If so, what authority does the Codification have over SEC content?   Exercise 3. Use the topical categories in the left navigation panel of the Codification to identify the first three subtopics within the general topic of Presentation Codification) governing each of the followings: Exercise 19. Use the codification to find which expenditures qualify as a research and development cost (be sure to cite where you found the answer within the Codification).

[lanamay1980]

Welcome to the Comfort Zone

I mentioned in Question #10 that comfort can create stagnation in life. So, this question today has me thinking about how the question could be phrased better. There was a song by Vanessa Williams in the early 90s called Comfort Zone, and that was where I got the inspiration for the title of this blog post. Yes. Vanessa Williams. Her album entitled Comfort Zone was bloody brilliant back in the day. 

Question 11: What or who gives me comfort?

I keep repeating this question in my head because I mentioned the safety I feel in my beloved's arms. This security is also a form of comfort. I don't solely rely on him for comfort though because that is a heavy burden to carry.  All my thoughts and fears. It's just too much. 

It gives me comfort to know that I survived living another month of life, bills and all. 

It gives me comfort knowing my family members are healthy and safe. 

It gives me comfort to know that I have a man who loves me regardless of my flaws. 

It gives me comfort to know that life could be much worse. 

It gives me comfort to eat a good home-cooked meal. 

It gives me comfort to eat some chocolate when I'm PMSing.

It gives me comfort to receive a hug from a loved one. 

I suppose that anything familiar brings me comfort. 

[getmeaflightoutofhere]

You’re having lunch with three people you respect and admire. They all start criticizing a close friend of yours, not knowing she is your friend. The criticism is distasteful and unjustified. What do you do?

Mention that I know the person and that we are friends to see if they retract their comments. If they still stand by what they said I would just explain that I disagreed. 

[bunnys-many-obsessions]

#11 Do I ever count my steps when I walk.

When I was a child I did it all the time when shopping with my people. Sometimes I do it now when I'm bored.

[writemein-blog]

What do you think about the authority figures in your life?

Answer.