Prescription information along with patient name

Assignment Help Other Subject
Reference no: EM13847849

PART 1-

Design a database schema for the proposed Database Design Proposal in Module 1.

Identify and list all relevant entities and their relationships:

1) Select no less than five entities.
2) Provide a diagram.
3) Map this to a database schema.
4) Provide a data dictionary for all entity attributes.

Focus on one or two areas of your design that seemed especially difficult to develop and provide a brief assessment of the difficulty you encountered in modeling or mapping to the schema. In addition, provide the rationale for the design chosen, its limitations, and its possible extensions.

Tip: If you do not have access to ER modeling software or a diagramming tool like Visio or OmniGraffle, you can simply create diagrams in a presentation tool like PowerPoint. This is an essential skill which is used in the field.

APA format is not required, but solid academic writing is expected.

This assignment uses a grading rubric. Instructors will be using the rubric to grade the assignment; therefore, students should review the rubric prior to beginning the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment.

This assignment will be utilized again in Modules 4 and 5. Prior to Module 4, review any feedback provided to you by the instructor.

PART 2-

Details: 1) Based on the feedback received on your Module 2 assignment Database Schema, provide SQL statements to create the (revised) database and populate it with sample data (at least four rows per table).

2) Modify the database by adding an additional column ("Deleted_Date") to those tables that represent entities that could contain data which can be deleted and justify your rationale in a short paragraph. In addition, explain what the tradeoffs are in using a marker-column for deletion, as opposed to actually deleting a row from a table?

3) APA format is not required, but solid academic writing is expected.

4) This assignment uses a grading rubric. Instructors will be using the rubric to grade the assignment; therefore, students should review the rubric prior to beginning the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment.

PART 3- SQL QUERIES

Details:

For this assignment, use the following database schema:

1) Patient-PatientID, Name, DOB
2) Doctor-DoctorID, Name, MedLicenseNumber, Phone
3) Medication-MedicationID, BrandName, GenericName
4) Prescription-PrescriptionID, Date, PatientID, PrescriberID, MedicationID

Specify the SQL queries to retrieve:

1) A list of all doctors.
2) The number of patients that were born before 01/01/1994.
3) The patient information along with the ID of any prescribing doctor for each patient.
4) The prescription information along with patient name, DOB, medication brand name, and prescribing doctor name sorted by most recent date.
5) The most prescribed generic medication name.

This assignment uses a grading rubric. Instructors will be using the rubric to grade the assignment; therefore, students should review the rubric prior to beginning the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment.

Reference no: EM13847849

Basic components of a personal computer

The history of computers in healthcare. Basic components of a personal computer. An introduction to the Electronic Health Record. Similarities and differences between the Inte

What are the legal responsibilities and liabilities

Write a persuasive argument defending your position. Cover the following: Assuming the steel cable was not defective in either its design or manufacturing process, does Nati

What reasons might exist for initiating an evaluation

What reasons might exist for initiating an evaluation? When might an evaluation be inappropriate? What steps or activities are involved in planning how to conduct an evaluat

Which specialty area interests you the most and why

Using both the assigned readings and additional research, respond to the following: Which specialty area interests you the most? Why? According to the specialty area, what kno

Research-supported views regarding psychopathology

What kinds of education or experiences might help you address bias and prejudice within yourself? How might you respond to a person who thinks that people with mental health

Does the narrator seem to love or hate her father explain

This week read Sylvia Plath's "Daddy" in our textbook and then go to Youtube and view and listen to Plath herself reading her poem "Daddy." Does the narrator seem to love or

Journal articles related to the topic of workplace ethics

Assignment: Students must locate two peer-reviewed journal articles related to the topic of "Workplace Ethics". The two article must be related and discuss the same topic

Describe the current american culture

Do you believe American's concern for the environment is a stronger value then their materialism? Yes or No and Why? What is a cultural value? Do all members of a culture shar

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd