QuestionQuestion

Transcribed TextTranscribed Text

1. Using examples, explain the differences and similarities between the degree of a relationship and the degree relation 2 Explain. using n example drawn from experience: the concept Integrity and why it is important (your example should illustrate the consequence f not including this type fintegrity constraint) Please SQL Queries Write (outpul & explanation are not required) You have tables with the primary keys shown underlined few sample rows are also listed (please note: the data showni not exhaustive). Assume you own the tables Leave unused clauses blank State Country BirthDate 05-MAR WRITH TotalSales Type BookID AUID BOO BOOKS(TotalSales): quantity sold (not dollar ORDERS(Price) a dollar value unit sold AUTHORS 1. Display the title. total sales. author name(s), country for books that over Format total sales 999,999 Sort the output reverse alphabetically title. SELECT FROM WHERE GROUP BY HAVING ORDER BY Find oldest Canadian author(s) our database Display seathor's name city and birthdate. SELECT FROM WHERE GROUP BY HAVING ORDER BY AUTHORS 3. Fiad books with non than $10,000 worth sales begimingof For such book display: Book ID, book title, (across time), dollar's SELECT FROM WHERE GROUP BY HAVING ORDER BY Please Write Relational Algebra Querkes OR SQL Queries Part 2) AUTHORS 1. Which Authors have written books (and no other type). Display neauthor name, book title, type 2 Which technology books have been shipped using every database)? Display the book ID Title.

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Q1
SELECT BOOKS.BTitle, BOOKS.TotalSales
FROM AUTHORS, BOOKS
WHERE (((BOOKS.TotalSales)>10000))
ORDER BY BOOKS.BTitle DESC;

Q2
SELECT AUTHORS.AuName, AUTHORS.City, AUTHORS.State, AUTHORS.Country, AUTHORS.BirthDate
FROM AUTHORS
WHERE (((AUTHORS.Country)="Canada"))
ORDER BY AUTHORS.BirthDate DESC;

Q3
SELECT BOOKS.BookID, BOOKS.BTitle, BOOKS.TotalSales, ORDERS.Price, [BOOKS]![TotalSales]*[ORDERS]![Price] AS [Revenue $], ORDERS.ODate, Count(ORDERS.Shipper) AS CountOfShipper
FROM BOOKS INNER JOIN ORDERS ON BOOKS.BookID = ORDERS.BookID
GROUP BY BOOKS.BookID, BOOKS.BTitle, BOOKS.TotalSales, ORDERS.Price, [BOOKS]![TotalSales]*[ORDERS]![Price], ORDERS.ODate
HAVING ((([BOOKS]![TotalSales]*[ORDERS]![Price])>10000) AND ((ORDERS.ODate)>=#1/1/2012#));...
$20.00 for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Database Development Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats