Data management and analysis by SQL

User Generated

f_n989

Programming

Description

* please Do from Q11 to Q 22 short answer

see the Question in file word

.........................................................................

Unformatted Attachment Preview

Q 11: Q :12 Q 14: Q 16: Q 17: Q 18: A friend shows you his awesome spreadsheet (his words) he uses to track customers for his small business. His spreadsheet shows his customers information, their orders, and other pertinent information. You, after being empowered by this class, notice multiple issues with his spreadsheet. Further, you know this spreadsheet, while "awesome," is a terrible idea for a small business. What would you say to your friend to convince him to use a relational database for his small business? Give him some examples of how his "awesome" spreadsheet could cause trouble for his business in the future. Q 19: You convinced your friend to create a database for his small/medium sized business. He hired you as a database administrator, but now needs you to describe what a database administrator does. Please describe what are the main duties of a database administrator. Q 20: What is the benefit of joining tables using the JOIN syntax? Q 21: Please explain what is ETL and how it deals with databases? Q 22: What is RAID and how does it apply to database systems? What is the difference between RAID Levels?
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hey am through. Check out the correct answers in the attached word file

Q 11:

SELECT * FROM BOOKS
JOIN AUTHORS_BOOKS ON BOOKS.ID = AUTHORS_BOOKS.BOOK_ID
JOIN AUTHORS ON AUTHORS.ID = AUTHORS_BOOKS.AUTHOR_ID
WHERE AUTHORS.NAME LIKE “%JIM%”

Q :12

The statement returns authors’ name and the count of books by each author.

The query will return five columns and two rows.

Q 14:

The SQL Gives the Last Name, First Name the job names of the individuals
Query:
select p.lastname, p.firstname, j.name
from
jobs as j, jobassignment as ja, person as p
where
j.jobid = ja.jobid and
ja.personid = p.personid
AND p.firstname like 'J%'

Query
-----------------select p.lastname, p.firstname
from
person as p
where
p.Shift like 'red%'

Q 16:

1.
2.
3.
4.

Query number 1 returns all the names of publishers who have id of less than four
Query number 2 throws a type conversion error
Query number 3 returns publishers whose id equals to four.
Query number 4 throws a type conversion error

Q 17:

SELECT * FROM BOOKS
JOIN AUTHORS_BOOKS ON BOOKS.ID = AUTHOR...


Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags