Task ⑤ ⇒ relational databases

Fundamentals of a relational database management system

Task

The task will be released as five parts,
one a day,
as we practice Access components.

1. the specs for tables
2. the relationships specs
3. the forms specs
4. and the reports specs
5. the first set of queries
6. finally, the second set of queries

Everything in this task is something we will have demonstrated and/or tried in class.

Condition

You are to create a book database for a private client, not too unlike Mr. Pitt on Seinfeld. The client has his own library and needs you to organize his holdings and be able to order new books for his library when he wants them.

This will require you to create a relational database that will include:

1. a number of related tables to capture the data about the books and the orders
2. a set of queries to pull data from the tables in response to questions about the book holdings
3. some forms to use for adding data to the database
4. some reports to use for presenting the client with a paper copy of results in response to his questions

You may work in teams on this task as you did on the previous tasks. When your team has completed the task, one member of the team will store it in that person's password protected directory. Each of the members of the team will place a hyperlink to it on their respective web sites (the individual storing it will have a relative link to it, the others will have absolute links to the finished task). When it's ready for me to download and grade, send me a note telling me to retrieve it from your websites.

[top]

This is my finished product for this task! .