The management is afraid of a software audit. The chief systems manager just came from a meeting where he heard that a school had just been fined $25,000 for illegally installed software. The current tracking system probably couldn't hold up to an audit. It is crucial that this new database be up and running soon. You assure the management that it will be done as soon as is possible, but you want to make sure that it really does what it is supposed to do. If you implement before it is ready, it might make matters worse rather than better.

To Do

1. Review your diagram for the database, making sure that the design is complete and normalized.
2. make 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. make 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.

Transcribed Image Text:

types for each column. Grandfield College The management is afraid of a software audit. The chief systems manager just came from a meeting where he heard that a school had just been fined $25,000 for illegally installed software. The current tracking system probably couldn't hold up. to an audit. It is crucial that this new data- base be up and running soon. You assure the management that it will be done as soon as is possible, but you want to make sure that it really does what it is supposed to do. If you implement before it is ready, it might make matters worse rather than bet- ter. To Do 1. Review your diagram for the data- base, making sure that the design is complete and normalized. 2. Create the database in SQL Server. 3. Create the tables in the new data- base, selecting appropriate data types for the columns, setting a pri- mary key for each table, and setting allow nulls as appropriate. 4. Create a database diagram and cre- ate the relationships among tables. 5. Add some sample data to each table. 6. Documentation: Make a data dic- tionary that lists each table, all the columns for that table, and the data types for each column. WestLake Research | Iospital types for each column. Grandfield College The management is afraid of a software audit. The chief systems manager just came from a meeting where he heard that a school had just been fined $25,000 for illegally installed software. The current tracking system probably couldn't hold up. to an audit. It is crucial that this new data- base be up and running soon. You assure the management that it will be done as soon as is possible, but you want to make sure that it really does what it is supposed to do. If you implement before it is ready, it might make matters worse rather than bet- ter. To Do 1. Review your diagram for the data- base, making sure that the design is complete and normalized. 2. Create the database in SQL Server. 3. Create the tables in the new data- base, selecting appropriate data types for the columns, setting a pri- mary key for each table, and setting allow nulls as appropriate. 4. Create a database diagram and cre- ate the relationships among tables. 5. Add some sample data to each table. 6. Documentation: Make a data dic- tionary that lists each table, all the columns for that table, and the data types for each column. WestLake Research | Iospital