The management is afraid of a software audit. The chief systems manager just came from a meeting
Fantastic news! We've Found the answer you've been seeking!
Question:
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
- Review your diagram for the database, making sure that the design is complete and normalized.
- make 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.
- make 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.
Posted Date: