IT 650 Southern New Hampshire University Database Design Worksheet

You have completed the designs for the apartment management database. You reviewed it and all the business rules with the owners, and they are eager to proceed. Now you need to take your design and translate it into an actual database. Once you have done that, you know that you will need to enter data to test the database, to make sure it does, in fact, store all the required data.

To Do

• Review your diagram for the database, making sure that the design is complete and normalized.
• Create the database in SQL Server.
• 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.
• Create a database diagram and create the relationships among tables.
• Add some sample data to each table.
• Documentation: Make a data dictionary that lists each table, all the columns for that table, and the data types for each column.

Part II

Wild Wood Apartments

Now that the basic database is in place, the Wild Wood Apartments managers are eager to see the database in action and see if it meets all their needs and requirements. 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.