HIM650 v10R Assignment: Database Schema-SQL Statements

Database Schema-SQL Statements
View Rubric
Due Date: Dec 06, 2017 23:59:59 Max Points: 100
Details:
1) Based on the feedback received on your Topic 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.
Feedback from Data Schema SQL Schema
This ERD/Schema looks great Pamela! Do the arrows represent a one to one relationship?Database Schema
Great start on the data dictionary! You may want to add the constraints for the data. You may want to look at page-42 of your text at table 2-1 and look under MySQL area. These will give you an idea of the data type and you will want to list the constraints. For example, for a Record ID will you allow letters and numbers or just numbers and how many characters will you allow in the space-10, 20, unlimited?
Database Schema-SQL Statements
Nevertheless, this scheme is still incomplete because some of the data that needs to be uploaded and categorized (Amuda, n.d.). Information for billing, insurances, and other promotions are still needed for this schema to be complete. Perhaps, one cause of this difficulty is the fact that this information could encompass a much bigger picture, than the amount of space provided before me.
Pamela, you have a great start and there are a few suggestions that I have made above. The other area you need to discuss is the details concerning the limitations, extensions for this project. You discuss some of your difficulties and this was part of the requirements. You just need to add more details, but overall—Nice job



Database Schema



Data Dictionary

Candidate Keys Definition

Relations Candidate Keys (Primary Keys)

Doctor D_Ssn

Patient P_Ssn

Record Record_id

Diagnosis Diagnosis_id

Prescription Prescription_id

Foreign Keys Definition

D_name The doctor's name

D_SSn, Doctor's Surname

Age Practitioners' age

Phone Na

Address The Doctor's home address

Record ID Codes and/or simple names that pinpoints who is the practitioner in charge

Record Type

Prescription The prescription that your always tell you



The database schema provided above presents a good and concise grasp of the whole process of healthcare provision. Mainly the database shown is more focused on the dissemination of information from the records (history, prescription, and diagnosis) to doctors. The database above, also enables the patient to access every information regarding his condition and treatment. Mainly, these access in this operational relational model, shows that by accessing the database, the patient could easily check on the diagnosis, records, and prescriptions of patients, which is taken beforehand, which is essential for one's recuperation (Nadkarni, 2003). Nevertheless, this scheme is still incomplete because some of the data that needs to be uploaded and categorized (Amuda, n.d.). Information for billing, insurances, and other promotions are still needed for this schema to be complete. Perhaps, one cause of this difficulty is the fact that this information could encompass a much bigger picture, than the amount of space provided before me.



References

Amuda, T. (n.d.). DEVELOPMENT OF A MEDICAL RECORD DATABSE SYSTEM. Retrieved from Academia. edu: https://www(dot)academia(dot)edu/3080257/A_MEDICAL_RECORD_DATABASE_SYSTEM?auto=download

Nadkarni, P. (2003). Generic Design of Web-Based Clinical Databases. na. Retrieved from https://www(dot)google(dot)com(dot)ph/search?rlz=1C1CHBF_enPH763PH763&biw=2133&bih=1082&ei=_ngUWrqANYSj8QWzpr8Q&q=creating+a+database+schema+for+medical&oq=creating+a+database+schema+for+medical&gs_l=psy-ab.3..33i22i29i30k1l4.1846.5476.0.5797.12.12.0.0.0.0.209.1415.1























1

Unsatisfactory

0.00%





2

Less Than Satisfactory

74.00%





3

Satisfactory

79.00%





4

Good

87.00%





5

Excellent

100.00%





100.0 %Module 4 Rubric: Database Schema—SQL Statements





20.0 % SQL Statements



Subject knowledge is not evident.



Little subject knowledge is evident.



Some subject knowledge is evident.



Demonstrate comprehension of subject knowledge in the SQL Statements.



Demonstrate exceptional subject knowledge in the SQL Statements.





20.0 % Database



Database modifications are either not present or not evident.



Database modifications are missing or incorrect. Little subject knowledge is evident.



Database modifications are mostly completed. Some subject knowledge is evident.



Database modifications are clearly completed.



Database modifications are competently completed.





30.0 % Rationale



Includes little knowledge about the topic. Details or thoughts are irrelevant or off topic. Supportive rationale is lacking.



Includes little knowledge about the topic with few supporting details and examples. Supportive rationale is lacking.



Includes knowledge about the topic with some supporting details and examples Rationale is present but lacks detail or may present some ambiguity.



Includes essential knowledge about the topic with supporting details and examples. Rationale is direct, competent, and appropriate. .



Covers topic in-depth with extensive details and examples. Supports rationale in-depth.





15.0 % Comprehension



Content is incomplete or omits most of the requirements stated in the assignment criteria.



Content is incomplete or omits some requirements stated in the assignment criteria.



Content is complete, but somewhat inaccurate and/or irrelevant. Research is inadequate in relevance, quality, and/or timeliness.



Content is comprehensive and accurate, and rationales are clearly stated. Research is adequate, timely, and relevant, and addresses all of the issues stated in the assignment criteria.



Content is comprehensive, accurate, and persuasive; rationales are clearly stated. Research is adequate, timely, and relevant, and addresses all of the issues stated in the assignment criteria.





8.0 % Language Use and Audience Awareness (includes sentence construction, word choice, etc.)



Inappropriate word choice and lack of variety in language use are evident. Writer appears to be unaware of audience. Use of "primer prose" indicates writer either does not apply figures of speech or uses them inappropriately.



Some distracting inconsistencies in language choice (register) and/or word choice are present. The writer exhibits some lack of control in using figures of speech appropriately.



Language is appropriate to the targeted audience for the most part.



The writer is clearly aware of audience, uses a variety of appropriate vocabulary for the targeted audience, and uses figures of speech to communicate clearly.



The writer uses a variety of sentence constructions, figures of speech, and word choice in distinctive and creative ways that are appropriate to purpose, discipline, and scope.





7.0 % Mechanics of Writing (includes spelling, punctuation, grammar, language use)



Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice and/or sentence construction are used.



Frequent and repetitive mechanical errors distract the reader. Inconsistencies in language choice (register), sentence structure, and/or word choice are present.



Some mechanical errors or typos are present, but are not overly distracting to the reader. Correct sentence structure and audience-appropriate language are used.



Prose is largely free of mechanical errors, although a few may be present. A variety of sentence structures and effective figures of speech are used.



Writer is clearly in command of standard, written, academic English