A physician office (private practice) approached you in an effort to convert their paperwork process into a health information database. The physician provided a copy of the paperwork used in the office to collect patient information. The physician also explained the need to secure patient information according to HIPPA rules and regulations. Additional information will be provided upon request.
The physician would like to add to patient records results from labs and imaging. In addition, the physician would like to link with a list of pharmacies in the area and send patient prescription electronically. As a database expert you will be developing patient database and all required tables using relational database approach.
- Analyze the provided forms below identifying the entities that should be tracked in the system.
- Identify the fields (attributes) associated with each entity, listing possible candidate keys (determinants). Note: you don’t have to list all fields in the form just select the most important 10 fields.
- Based on your analysis and the given forms identify all possible functional dependencies (remember that those functional dependencies will not only assist in creating the proper tables but also will assist in understanding relationships between tables).
- Select a primary key for each entity. If none of the candidate keys is numeric and unique create a surrogate key that suites the entity.