A physician office approached you in an effort to convert their paperwork process into a… 1 answer below »
A physician office approached you in an effort to convert their paperwork process into a… 1 answer below » | savvyessaywriters.org
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.
Requirement:
- 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.
Attachments:
COP4708-Proje….docx
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post A physician office approached you in an effort to convert their paperwork process into a… 1 answer below » appeared first on Affordable Nursing Writers.
