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.
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#));...