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.