Database Assignment

You will use the same textbooks as in the spreadsheet assignment. In your database (star office base or access (if you want to use another database ask)

• you will create a table called texts with only these fields: textbookName, authorName, and ISBN. The ISBN should be the primary key.
• You will also create a table called statistics with only these fields: ISBN (primary key) , pages, price. Price should be formatted as currency, pages as an integer.
• You will create a report from the texts table.
• You will create a query called totals on statistics that returns the total number of pages and total of the prices.
• You will create a report for the totals query.
• You will create a query called pages that gives each textbooks’: name, author, and pages only (no other fields). You will have to tell the query about the relationship between the ISBN’s in each table.
• You will also create a query called prices that gives each textbooks’: name author and price only (no other fields).
• You will create a form for the pages and prices queries that shows nicely the fields on each textbook.