In reference to your proposed Database Design Proposal, consider a situation where you want to track (and ultimately reduce) the occurrences of a risk incident within the environment you selected.

2) Identify and select an incident in which you are interested. An example of an incident could be that which is acquired or occurred during hospital stays.

3) Develop a 750–1,000 word proposal from the perspective of the Health Information Manager, which includes a specification of the requirements, the proposed solution, the database design and/or modifications to existing databases, and a breakdown of responsibilities among staff to collect, analyze, and disseminate the information.

make any changes to the schema of your proposed db, make them and then start writing the scripts that you would need to write to create the DB, Create the tables, and statements to insert sample data.