it203 Lab 1.2
Human
* Researchers * Doctors * Patients * Drug Type * New Drug * Prozac * Interview * Symptoms * Side effects * Date and Time
The Westlake Research Hospital will be testing new drugs. The facility is will be undergoing a new drug test on a new depression medication. The hospital is currently looking for a database that will include Doctor's notes, interactions, patient’s access, and the ability to keep the blind test confidential.

Lab 1.3

Software * Software version * license agreement * machine * machine location * install date * software requests * availability * software location * access level

Grandfield college needs a database to tack faculty and staff and all of the computers , to know how has access to the computers and the software to help track what is install on each computer to help troubleshoot faster.

Lab 1.4 1. You store the same information in several places, such as: Customer Names, Product Information, Order Information and Employee Information. When you update these items, it is time consuming to find all of the places they occur and type in the same information over and over. Will you be completely sure that all copies are the same? Is there a risk of deleting important data, then finding that there were no backup copies

2. A relational database is different from a flat file format such as those created by a spreadsheet or a word processor. Flat file are easy to set up, but difficult to manage. Problems that arise with flat files can be resolved with a properly constructed relational database

3. Data Inconsistency, Less security, Slow for big database

4. Properly designed relational database stores each item in only one table and includes data validation and business rules for verifying data so that mistyped or inconsistent entries are caught before they are saved in your database.