Question
Transcribed 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 Preview
These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.
Q1SELECT 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#));...
By purchasing this solution you'll be able to access the following files:
Solution.docx.
Return to homework library