Homework is due at class-time on Wednesday (9/22). Submit either a hardcopy or email it to me.
We finished talking about the basics of the relational database model (beginning of chapter 2, chapter 4 (Integrity Rules), chapter 5 (functional dependencies and keys).
For the following homework you will need Microsoft Access, you can find it in the labs, or get a free license and software at https://my.cdm.depaul.edu/resources/msdnaa.asp. Microsoft offers introductory tutorials on Access 2007.
1. [Henry Books, database schema, 15pt] Draw a diagram with the relational schemas and foreign keys for the Henry Books database (Author, Wrote, Book, Publisher, Branch, Inventory).
Your diagram should be similar to the diagrams we saw in class; for another example, see the company miniworld (2nd page has the diagram; it's for the company database which we will see next week). In particular:
2. [Database Schema, 15pt] You are designing a small customer database. We'll simplify a bit and say you for every customer you want only their first name, last name, address and any credit card (store number, type, expiration date) they care to use.
3. [Integrity Constraints, 15pt] For each of the following types of constrains, give an example of what type of action would violate it. Choose your example for the Henry Books database.
Hint: Example: the functional dependency Publisher Name → City would be violated by inserting records (PGNY, Penguin, New York) and (PGLN, Penguin, London) into the Publisher table.