Assignment on multiple tables, keys and indexes

Problem #1. You work in a university and you have received several grants to do some development work. You need to keep track of each grant and when it starts, when it ends, how much money, who is working on it etc. You have set up the following relational tables in third normal form.

Grant table includes grantid, grant name, source of grant, date received, date terminated, amount of grant.
Employees working on grant table included empid, emp name, pay per hour
Work done on grant table includes empid, grantid, date worked, hours worked

Assignment

Problem #1: Set up the tables and include primary keys and foreign keys to link the tables together

Problem #2: Using the table from #1, I want you to use the check constraint and the unique constraint. Explain the problem with using the not null constraint after the table has been populated.

Problem #3: Using the foreign keys from #1, explain how foreign keys are created and how they can be added to a table after it is created. Explain the relationship between primary and foreign keys.

Problem #4: Using the tables from #1, try to create a record that would put on a record with a dupicate primary key. Try to add a record that would be caught by the check or and try to add a record that would be caught by the unique.

Problem #5: Create an index for the first table and explain.