1. Review your diagram for the database, making sure that the design is complete and normalized.
2. Create the database in SQL Server.
3. Create the tables in the new database, selecting appropriate data types for the columns, setting a primary key for each table, and setting allow nulls as appropriate.
4. Create a database diagram and create the relationships among tables.
5. Add some sample data to each table.
6. Documentation: Make a data dictionary that lists each table, all the columns for that table, and the data types for each column.

The research program is almost ready to begin. Westlake is in the process of interviewing potential patients and doctors. It is important that the database be ready soon. It is also important that it does what it is supposed to do. It is time to look at the business rules and test them with some SQL. Look at the business rules you developed previously, and design some SQL queries to test them.

Documentation: Set up a test plan. List the rule, the SQL you wrote, and the results. Also, note whether the database passes or fails the test. Your queries should include the following:

• Two or three simple SELECTs with various WHERE criteria.
• Two or three queries using aggregate functions.
• At least two queries that use joins.
• Two or three INSERT statements.
• One or two UPDATEs and/or a DELETE.