List the title and publisher of all the books that have sold

Assignment Help Computer Engineering

Reference no: EM133360009

Question: BOOK(isbn, title, num-pages, publisher, year, genre, price, aut-id). The first attribute is the primary key; the last one is a foreign key to AUTHOR. 1 - CUSTOMER (customer-id, name, address, city, state, zip, age). The first attribute is the primary key. - SALES(isbn, custid, num-copies, day, month, year, total). The first attribute is a foreign key to BOOK and the second a foreign key to CUSTOMER. The key of this table is the two foreign keys together. - AUTHOR (author-id, name, dob, nationality, address, city, state, zip). The first attribute is the primary key. Attribute dob stands for 'date of birth'. Attribute nationality has values like 'British', 'Australian', etc. Attribute genre has values like 'sci-fi', 'romance', etc. Note that this schema assumes that each book has one and only one author, but it can be sold to different customers at different times. Write the following queries in Relational Algebra:

1. List the title and publisher of all the books that have sold at least 100 copies at any time.

2. List the title and publisher of all the books that have been sold to a customer from the state of Kentucky.

3. Find the name and address of British authors who have written a sci-fi book (recall that 'sci-fi' is one value of genre).

4. List the name and address of authors who have written either a sci-fi book or a romance book (recall that 'sci-fi' and 'romance' are values of genre).

5. List the name and address of authors who have written a sci-fi book and a romance book.

6. List the name and address of authors who have never written a sci-fi book.

7. List the name and address of authors who have written at least two books.

8. List the name and address of authors who have written only sci-fi books (i.e. all the books they have written are sci-fi).

Reference no: EM133360009

Questions Cloud

Why is racism considered a major social justice issue : Why is racism considered a major social justice issue? Can civil policies be housed to enforce social justice? Why or why not?

What would be the recovery : the dog left the site and attacked a ten-year-old child who was walking by the site. Will the contractor be held liable? If so, what would be the recovery

What are the relevant tax issues that need to be considered : He wants Spencer to receive an ownership interest in the business. What are the relevant tax issues that need to be considered? (This question requires you)

Discuss the most important early hindu scriptures : What do you consider to be the most important early Hindu scriptures? What is your reasoning for this choice?

List the title and publisher of all the books that have sold : List the title and publisher of all the books that have sold at least 100 copies at any time. List the title and publisher of all the books that have been

Compute christophers taxable income for the year : Christopher's income consists of wages of $51,300 and a cash prize of $500 from a local TV Station. Compute Christopher's taxable income for the year

What are traditional gender roles-stereotypes in cambodia : What are traditional gender roles and stereotypes in Cambodia and how has globalization changed these?

Identify misconceptions that your friend seems : SCS 2331 University of Toronto Identify misconceptions that your friend seems to have about the auditor's role with respect to the audit of his company

Regional and international population demographics : You with an opportunity to review current data on staff turnover, workforce demographics and local, regional and international population demographics.

User Account

All Pages