#Question8

[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 question8. Favourite Christmas ornaments?

How on Earth did I forget this one yesterday???

Favorite ornaments: rustic/natural looking ones. Ones with pine cones and earthy tones. But I also like the older looking ornaments from like the 20s.

[flapper-dai]

Aquarius 髙橋大輔の踊る全力クイズ！Question8  [ Freestyle skiing ]

[joshuajmadrid]

Merino wool clothing manufacturer

Unitex is a one of the best merino wool clothing manufacturers & exporters who specialized in Merino Wool knits & hosiery in East Asia. Unitex’s merino wool clothing main products include 100% wool knitted underwear(made from the imported high micron Australian natural Merino virgin wool) , running garments and outwearing jersey, woolen shirts and coats, wool scarves, wool gloves and wool socks etc.

Unitex also supplies various types of merino wool fabrics include merino jersey fabrics,merino interlock fabrics and merino rib fabrics and etc.Unitex can also produce pure merino wool fabric with wet transferring printed designs for outdoors hunting purpose(such as Military Camouflage,Shrubby & Oak trunk and leaf patterns etc.)  We believe that merino wool clothing will surprise you with their super qualities and our competitive prices. Not only the qualities could be guaranteed, but also the delivery time could be promised by 1000-2000pcs output per day which is increasing for the developments and expansion of our factory. Merno Wool Yarns & fabrics have been sent to the tests and obtain the certificates year by year such as OEKO-TEX STANDARD 100, WOOLMARK, GB/TI9001—2000,and other environmental protection standard etc.

Merino wool fabric.

Merino wool clothing is made of merino wool fabric. There is different wool content for merino wool fabric. The wool blend fabric such as merino wool+nylon, merino wool+polyester, merino wool+tencel, merino wool+coolmax and etc. And most of the merino fabrics are made of the 17.5micron and 18.5 micron merino wool fibers. Normally the lighter weight the merino wool clothing need to be, the less merino fiber value need to be. Unitex has the merino wool fabric whose weight from 150gsm to 400gsm. And according to the merino fabric structure, we have the wool interlock fabric, wool rib fabric, wool jersey fabric and etc.

Questions about how to custom orders with the merino wool clothing manufacturers?

Question1: Are you a factory or OEM?

Answer: Yes, we are a factory with our own seamless knitting,cutting & sewing machines.

Question 2: Can the leadtime more shorter if urgent order needed?

Answer: Yes, pls contact us urgent to check all your details.

Question 3: What is your MOQ? Can I mix styles?

Answer:Our normal MOQ is 500pcs per style, and it also depends on your quality and other requirements.

Question 4: What is your good price?

Answer: It depends on what type of materials , fabric weights, order quantities and package trims etc. When you are making an inquiry, please let us know your order details as well, thanks.

Question 5: What is the delivery time?

Answer: Color lab dip requires 7 days. The bulk production time is around 30 to 50 working days after confirmed PPS (pre-production sample). It depends on the quantities and styles you order as well.

Question 6: Can we make our logo on the merino wool clothing?

Answer: Yes. We can do logo as your requirements as well as your design project. Usually the logo can be do on neck inside the garment, or any other place can meet your need.

Question 7: What is your packing?

Answer: Each piece into polybag or printed box and then pack into master carton.

Question8: This is my first buying overseas, how to place order for merino wool underwear with the merino wool clothing manufacturers?

Answer: Pls follow the below steps. Step 1: We need information like pictures,size specs,composition ,weight,quanitity… , then we will quote you good price accordingly .We can arrange sampling according to your requirements. Step 2: Confirm other details such as lead time, payment, shipment. Step 3: You need to pay the deposit. Step 4: After bulk finished, we can send you bulk samples if you have such requirements. Step 5: You arrange to pay the balance payment. We will arrange shipment and related documents. Step 6: When you receive the goods well, please tell us your comments then we can keep doing better next time.

[rose-red-ink]

OC tag game!

Thanks to @rainbow-writers for tagging me <3 This was lots of fun!

I’ll tag @inthedarkwedancetogether and @whywritewhenyoucansleep

1. If you could go to one of your oc’s bachelor/bachelorette party, which would you choose (also: who would have the wildest one???)

So Kaia would have the wildest one, and since I’m not one for wild parties, I’d probably go for Risty. I’m picturing it being some light alcohol, chicken nuggets and Mario Party. She’d keep it lowkey, how I like it <3

2. What’s your favorite time of day to write?

Generally, I write mid-afternoon, right after classes. I can’t go straight from lectures to homework, so I write or watch a little Netflix before getting to work. 

3. What’s your favourite ship in your WIP? (platonic or romantic, I get ya)

That...is a spoiler ;) 

Let’s just say that Risty is too caught up in her own issues to see the romance blooming between two of her friends 

4. How far are you into your WIP?

I am 30 pages into Shadows and Thrones, aka 6,791 words. 

5. If you were stuck in a broken elevator for twelve hours, which oc would you choose to be stuck in there with you? (note: you have to be in there for the twelve hours!!! no houdini escape!!!)

I feel like Cax’Lee or Astera would be fairly calm and collected in that situation, which would be comforting. (They’re 2 of my DnD characters, but they count as OCs for me <3)

6. What’s your favourite colour? (generic, I know)

Turqiouse! Like a rich blue with a hint of green. 

7. Where would one of your oc’s propose to the other? (if this question isn’t up your alley, replace “propose to” with “surprise attack hug”)

Ugh, I wish I could answer this, but spoilers! Read Shadows and Thrones if you wanna know!

8. Which oc is most like you?

Okay, so...this is an interesting question. I’m going for my Dungeons and Dragons characters, because, in hindsight, I see that I’ve put pieces of my personality and struggles in each. 

Astera left her home for the betterment of her people; I made her when I first left for college and felt disconnected from home. 

Relika trusts few and was grumpy and secretive, hostile when questioned. I made her when I felt alone and was struggling deeply with anxiety and depression. 

Cax’Lee has had a lot of heartbreak and doesn’t want to let people in, and this semester, I’ve been trying to accept that I’m not an annoying burden in my friend’s lives. 

And they’ve learned to be better as I have. Astera started to become confident in her life outside her island, and I felt that confidence. Relika learned to open her world to new people, and was rewarded with friends who will always have her back. 

Cax’Lee and I are working together to learn to depend on others and to share burdens with people who genuinely care. 

So yeah, they’ve all got a piece of my heart, my struggles, and have been doing a great job of helping me out. 

9. Do you prefer writing with ambient noise, music (if so, with or without lyrics), or in silence?

I generally go for movie and videogame soundtracks, or music I’ve heard a lot, and can tune out the lyrics. 

10. If you suddenly got the power of teleportation, where in the world would you go first? (this can extend to planets, I kinda wanna yeet myself into the sun)

I’m German, so I’d love to go to Germany. And Greece!

[mathsteacher01]

Number Systems Exercise 1.3 Q8 Mathematics Class 9 CBSE Number Systems Exercise 1.3 Question8 Mathematics Class 9 CBSE

[nicholasrossis]

This post was originally posted on the Azure Fire Publishing website.

Creating The Perfect Newsletter

For many authors, the Perfect Newsletter is like the alchemist’s philosophical stone: if we get it right, we can turn our books to gold! The newsletter is our way to reach our readers, create with them a long-standing relationship, make our books known, and even make some friends through the process. We authors love writing and connecting, and the newsletter combines both aspects in one. It should be considered one more hot trend to publishing!

So we spend time creating and putting together newsletters, and our hearts ache when someone unsubscribes. But just what is it that readers are looking for in a newsletter?

Jackie Weger of eNovel Authors At Work recently ran a survey looking for the answer to just that. She had hundreds of responses, and I had the opportunity to look at her data. So, here is what appeals to readers and what turns them off in a newsletter.

Things that appeal to the readers

Most of the things that appeal to readers in a newsletter have to do with newsletter content:

Keep a friendly tone and use your humor. Readers appreciate when an author is open, honest and friendly. A little humor goes a long way.

Talk about your new releases. Your new or upcoming book is by far what readers want mostly to know about. Provide some book updates, either about new books, work in progress, or information about your existing books.

Include offers, deals, or freebies. Try to include a good deal for your readers in every newsletter. According to the survey results, 73% of the subscribers prefer newsletters offering giveaways and 89% subscribe to Bookbub.

Ebook offers are the best. Only a tiny minority of people (about 1% of the participants) prefer free books to be hardcopy instead of e-books. They also asked for giveaways to be made available to readers outside the USA. Unfortunately, this is hardly feasible, for cost reasons as well as for legal ones.

Inform readers about signature events, ARCs, cover selection. Your most dedicated readers love to interact with you. The high participation in this survey proves it! So give them the opportunity to meet you or to get somehow involved in the edition of your next book.

Things that turn readers off

Things that turn people off in a newsletter have to do with how easy it is to read, like:

Too long and disorganized: This is the most important complain about newsletters. Readers receive many newsletters from a variety of sources and have limited time to read them (see figures). They appreciate a newsletter not longer than one page at maximum, clean and easy to read. So for each newsletter, focus on 2-3 themes. Also, consider that, although short excerpts, teasers, and sneak-peeks of upcoming books are appealing to readers, long ones have the opposite effect.

Too frequent newsletters: Anything more than one newsletter per week is considered overkill. Even a weekly newsletter is too much for most. While 98% of the survey participants are comfortable with receiving a newsletter once or twice a month, only 56% would feel comfortable with a weekly newsletter. Content repetition is also a pet-peeve for readers, which is connected to high frequency: they like a newsletter that they have not read before. So, if you want people to actually read your newsletter, make them wait for it and make it interesting.

Too pushy. Obviously, newsletter subscribers know that your newsletter is a marketing tool. However, they don’t appreciate when it’s “in their face”. They still expect a friendly, informational communication. Avoid being pushy with “BUY NOW” titles and don’t look too desperate to sell.

Small or weird fonts, bad grammar, too many CAPS, acronyms and !!!: People want to be able to read your newsletter. Don’t use small fonts to keep it short in size; reduce your text. Use readable, clean fonts and easy-to-the-eye colors. Avoid sensationalism.

Text only, not interesting and ugly layouts: readers will be discouraged by a long newsletter that is all text. Make your newsletter visually appealing by including a nice layout and some book-covers or an interesting photo. Make sure that the photos load quickly enough by optimizing them for web use.

Sex and profanity: Keep in mind that your readers will probably open their newsletter in an environment where other people will also be present. No-one wants to open a newsletter with naked models while taking a break at the office or in front of family members. Keep it clean.

Too many links and clicks: following a link is ok, but having to click on an endless list of links is too much. Keep your links under control and make sure they work.

Striking the right balance

Image: Jackie Weger, #eNovAaW

Image: Jackie Weger, #eNovAaW

Image: Jackie Weger, #eNovAaW

Image: Jackie Weger, #eNovAaW

Image: Jackie Weger, #eNovAaW

Image: Jackie Weger, #eNovAaW

Maybe the most important thing about your e-mail is finding the right balance on some important features of your newsletter:

The personal approach

A vast majority of readers love not only books, but their authors too. They are eager to hear about your life as a writer, your work in progress, what inspires you, and some personal information. Being friendly and providing some interesting backstage information figures among the top features that readers appreciate in a newsletter.

However, if you go overboard and provide too much information, you may turn this big “do” into a big “don’t”. So go ahead and write a short personal greeting, but:

Keep it short and pleasant.

Keep the personal life update (family and children) sparse.

Don’t brag about your achievements or your wonderful life. Avoid information that might be provocative to lower-income readers.

Never ever whine or rant about low sales, other authors being undeservedly successful, bad reviews etc. Keep your newsletter drama-free.

Opinions about photos of your pets are split – half love them and half hate them. So go ahead and include one from time to time, but not in every single newsletter.

Recommending other authors

Here is another fine balance to achieve. According to the survey results, 85% of the participants actually enjoy having an array of books by selected authors to choose from in a newsletter. Readers love when you recommend other authors because a) they see it as a sign of humility and fair play on your part, b) they like what you write so they trust that they will also like what you read.

However, there were also many complaints about recommending other authors:

Readers do want to know that you have read what you recommend. If you recommend too many books from other authors they consider it as advertisement and may not care about it.

Many don’t like it when you recommend too many titles, especially if they are outside of your genre.

Pricey books from other authors are not appreciated.

Yes to contests, but…

Although many readers like contests as a means to interact with you, they appreciate them less when participation rules are too complicated (e.g. You need to go on one site, two social media, click like and leave a comment). Again, keep it simple.

[tweetthis]Creating The Perfect Newsletter[/tweetthis]

  Creating The Perfect Newsletter This post was originally posted on the Azure Fire Publishing website. Creating The Perfect Newsletter…

[cathartic-knavery]

Laughing so hard at these c3 Kate question eight jokes so much right now and didn't even sit the fucking exam.

[lanamay1980]

Believe in Something

Everyone believes in something. Even the strongest Atheists believe in something. I don’t care what you believe in, but I do think that your values determine the kind of person you are. Whatever your priorities might be are it is important to think about this question often to gauge where you are in your life path. Determining how it changes throughout the years is even more important as we are always growing and changing as part of the human condition.

Question 8: What are my values? What do I believe in?

Answer: I believe that one person can change the world. I believe in integrity and honesty in all things. I believe in the laws of attraction and that what you put out into the world will come back to you ten-fold. I believe in my students and fighting for the rights of individuals with disabilities, those suffering from poverty, and trying my best to leave the world a little bit better than it was when I got here. 

[bobbyashe]

My favorite youtuber answered my question in his newest video and sent me an email!!!!

I'm so fucking happy right now!!

[tacticaldonut]

CS 101 Problem Set 1: Question 8

# Assume text is a variable that

# holds a string. Write Python code

# that prints out the position

# of the second occurrence of 'zip'

# in text, or -1 if it does not occur

# at least twice.

# For example,

#text = 'all zip files are zipped' 

# >>> 18

# text = 'all zip files are compressed'

# >>> -1

text = "all zip files are zipped" 

#ENTER CODE BELOW HERE

first = text.find('zip')

second = text.find('zip' , first + 1)

print (second)

[jessicaburkhart]

View this post on Instagram

A post shared by Jessica Burkhart (@thejessburkhart)

#question8

[writemein-blog]

Describe your physical and emotional state when you are extremely tired.

Answer.

[avemaraiahhh-blog]

Question # 8 - Describe mo sarili mo bilang estudyante.

im not a perfect student. pumasok ako magulo buhok haha asa! ano ba seryoso na ko :D haha makulet pasaway pero misan gc ako :D honor student pla ako :D haha nade-depress ako pag mababa score ko sa test , pero kahit honor student ako makulet pdin ako haha bsta makulet ako sa school haha :D