Questions on homework 6

A few questions have arisen regarding homework 6:

1. Should we worry about any logical constraints other than the primary and foreign keys?
   
   No.  If you want to try out some additional constraints, you may, but it is not required.
   
   
2. Should we have a use dbname command at the top of the sql files like some of the examples do?
   
   Actually I prefer that you don't have any use statements in your files.  That way, I can try building your tables in a different database if I want, without disturbing your own database.
   
   
3. As far as using the scripts to make tables, with referential constraints sometimes you need to do them in a certain order unless you defer them. Should we?
   
   Yes, you will have to build things in a certain order to avoid violating the referential integrity constraints.  Please put the proper ordering in your README file.
   
   
4. If each table has the same number of rows (8-10) and you have a lot of many-to-one relationships, it's hard to make the data make a lot of sense. Is this expected?
   
   That was just a rule of thumb.  You can violate it where appropriate, but don't go below 5 tuples in any relation.  Most of your relations should have at least 8 rows.