Download the database file appropriate for the database program you\'ll be using

Question

Download the database file appropriate for the database program you'll be using.

Access: https://drive.google.com/open?id=1tRK_n6d_pHJ1WumDGlbC2l3QEPlFMWXb

Base: https://drive.google.com/open?id=1-i-pOvk-4WVA3mJ1izXLZhPIHpM0K_8X

Add at least 2 new authors and 5 new books to the database. See Using the Pet Hospital Database for help with this. Make sure each book has an author, by ID.

Modify the query BooksBefore2000, so that the records are listed in ascending sorted order by book title.

Add at least 3 new queries. The best way is to use the 'Edit Query by Design' feature. You might want to view and run the existing queries to see how they work. You may choose queries from the list below or create your own.

Possible New Queries you can add:

books written by Naomi Novik - display title and year of publication

all books in a series

books in a series by a specific author

books in the specific series

books published in the 60s (or other decade)

the number of books by a specific author

all authors from a specific country

total number of books in a series by a specific author

the first year a specific author was published

When you create the title for each new query, include your name. For example: BarbBookSeries

Grading
/3 - 2 new authors are added
/3 - 5 new books are added
/2 - changed existing query to sort
/4 - first new query different from others, with descriptive name
/4 - second new query different from others, with descriptive name
/4 - third new query different from others, with descriptive name

Explanation / Answer

https://drive.google.com/open?id=1tVh67Kz0jik4PKPRf-layiEjLeFjgppX

Link for access file

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.