1. Using examples, explain the differences and similarities between the degree of a relationship and the degree
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
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
BOOKS(TotalSales): quantity sold (not dollar
ORDERS(Price) a dollar value unit sold
Display the title. total sales. author name(s), country for books that over
Format total sales 999,999 Sort the output reverse alphabetically title.
Find oldest Canadian author(s) our database Display seathor's name city and birthdate.
Fiad books with non than $10,000 worth sales begimingof For such book
display: Book ID, book title, (across time),
Please Write Relational Algebra Querkes OR SQL Queries
1. Which Authors have written books (and no other type). Display neauthor
name, book title, type
Which technology books have been shipped using every database)? Display the book ID
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.
SELECT BOOKS.BTitle, BOOKS.TotalSales
FROM AUTHORS, BOOKS
ORDER BY BOOKS.BTitle DESC;
SELECT AUTHORS.AuName, AUTHORS.City, AUTHORS.State, AUTHORS.Country, AUTHORS.BirthDate
ORDER BY AUTHORS.BirthDate DESC;
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#));...