Discussion: Patient Admission Database

Discussion: Patient Admission Database

Question Description
I’m studying for my Software Development class and need an explanation.

Your Task

Panther Memorial has contracted with you to develop a database based upon an entity relationship
model for a patient admission database. Now that you have developed the model, your task is to use
the instructions and entity relationship diagram to implement the database using Microsoft Access.

Deliverables
A Microsoft Access database that contains your implementation of the entity relationship model that
adheres to the instructions and entity relationship diagram provided.

Individual Work
This assignment will be completed individually without collaboration with other students.

Submission
Submit your Microsoft Access Database file to Canvas. It is your responsibility to correctly submit the entire assignment on time in Canvas and you may want to reopen your uploaded file to confirm the submission.

Instructions
Upon review of the diagram that you delivered, Panther Memorial made a few changes and has
provided some additional guidance for building the database. Use the answer key from Assignment I, the entity relationship diagram, to implement the database. Do not use your diagram, use the answer key.

Then ensure that you follow these instructions to complete the database.

Assign appropriate data types for each and every field.
A patient’s name, date of birth, and address is required to be entered anytime a new patient is
entered.
Any “State” attribute part of an address should be defaulted to “WI” since our hospital operates
in Wisconsin. For provider, default the degree to MD.
Use an input mask for any SSN, date, or zip code.
For dates, utilize the short date format.
Turn the Patient Expired, Degree, Admission Type, Admission Source, Discharge Status fields
into a combo box. Set the Row Source Type to Value List and then determine how to instruct
Access to allow the entry of values provided for each field within the Row Source. Also set Limit
to List to Yes.
Patient Expired has values of Yes, No
Degree has values of MD, DO, DPM, CNM, NP
Admission Type has values of Emergency, Urgent, Elective, Newborn
Admission Source has values of Direct admission, Transfer, Emergency room
Discharge Status has values of Routine/discharged home, Left against medical advice, Discharged/transferred to short-term facility, Discharged/transferred to long-term care
institution, Expired
Email addresses must be null or contain the @ symbol (validation rule). Display the following error message: “Invalid email address format. Please enter an email that contains the @ symbol.”\\
For each table you create, add five rows of test data filling in every field with a value.
Rubric
Assignment II

Assignment II

Criteria Ratings Pts
This criterion is linked to a Learning OutcomeTables and Attributes (-1 per defect)

10.0 pts
Full Marks

0.0 pts
No Marks

10.0 pts

This criterion is linked to a Learning OutcomePrimary Keys (2 points each)

16.0 pts
Full Marks

0.0 pts
No Marks

16.0 pts

This criterion is linked to a Learning OutcomeRelationships and Foreign Keys (2 points each)

18.0 pts
Full Marks

0.0 pts
No Marks

18.0 pts

This criterion is linked to a Learning OutcomeRequired Fields

3.0 pts
Full Marks

0.0 pts
No Marks

3.0 pts

This criterion is linked to a Learning OutcomeDefaulted Values

2.0 pts
Full Marks

0.0 pts
No Marks

2.0 pts

This criterion is linked to a Learning OutcomeInput Mask

9.0 pts
Full Marks

0.0 pts
No Marks

9.0 pts

This criterion is linked to a Learning OutcomeDate Format

6.0 pts
Full Marks

0.0 pts
No Marks

6.0 pts

This criterion is linked to a Learning OutcomeDropdown with value list (3 points each)

16.0 pts
Full Marks

0.0 pts
No Marks

16.0 pts

This criterion is linked to a Learning OutcomeEmail Address Validation

5.0 pts
Full Marks

0.0 pts
No Marks

5.0 pts

This criterion is linked to a Learning OutcomeTest Data

15.0 pts
Full Marks

0.0 pts
No Marks

15.0 pts

Total Points: 100.0

assignment1.pdf

Discussion: Patient Admission Database

You must proofread your paper. But do not strictly rely on your computer’s spell-checker and grammar-checker; failure to do so indicates a lack of effort on your part and you can expect your grade to suffer accordingly. Papers with numerous misspelled words and grammatical mistakes will be penalized. Read over your paper – in silence and then aloud – before handing it in and make corrections as necessary. Often it is advantageous to have a friend proofread your paper for obvious errors. Handwritten corrections are preferable to uncorrected mistakes.

Use a standard 10 to 12 point (10 to 12 characters per inch) typeface. Smaller or compressed type and papers with small margins or single-spacing are hard to read. It is better to let your essay run over the recommended number of pages than to try to compress it into fewer pages.

Likewise, large type, large margins, large indentations, triple-spacing, increased leading (space between lines), increased kerning (space between letters), and any other such attempts at “padding” to increase the length of a paper are unacceptable, wasteful of trees, and will not fool your professor.

The paper must be neatly formatted, double-spaced with a one-inch margin on the top, bottom, and sides of each page. When submitting hard copy, be sure to use white paper and print out using dark ink. If it is hard to read your essay, it will also be hard to follow your argument.

ADDITIONAL INSTRUCTIONS FOR THE CLASS

Discussion Questions (DQ)

Initial responses to the DQ should address all components of the questions asked, include a minimum of one scholarly source, and be at least 250 words.
Successful responses are substantive (i.e., add something new to the discussion, engage others in the discussion, well-developed idea) and include at least one scholarly source.
One or two sentence responses, simple statements of agreement or “good post,” and responses that are off-topic will not count as substantive. Substantive responses should be at least 150 words.
I encourage you to incorporate the readings from the week (as applicable) into your responses.
Weekly Participation

Your initial responses to the mandatory DQ do not count toward participation and are graded separately.
In addition to the DQ responses, you must post at least one reply to peers (or me) on three separate days, for a total of three replies.
Participation posts do not require a scholarly source/citation (unless you cite someone else’s work).
Part of your weekly participation includes viewing the weekly announcement and attesting to watching it in the comments. These announcements are made to ensure you understand everything that is due during the week.
APA Format and Writing Quality

Familiarize yourself with APA format and practice using it correctly. It is used for most writing assignments for your degree. Visit the Writing Center in the Student Success Center, under the Resources tab in LoudCloud for APA paper templates, citation examples, tips, etc. Points will be deducted for poor use of APA format or absence of APA format (if required).
Cite all sources of information! When in doubt, cite the source. Paraphrasing also requires a citation.
I highly recommend using the APA Publication Manual, 6th edition.
Use of Direct Quotes

I discourage overutilization of direct quotes in DQs and assignments at the Masters’ level and deduct points accordingly.
As Masters’ level students, it is important that you be able to critically analyze and interpret information from journal articles and other resources. Simply restating someone else’s words does not demonstrate an understanding of the content or critical analysis of the content.
It is best to paraphrase content and cite your source.
LopesWrite Policy

For assignments that need to be submitted to LopesWrite, please be sure you have received your report and Similarity Index (SI) percentage BEFORE you do a “final submit” to me.
Once you have received your report, please review it. This report will show you grammatical, punctuation, and spelling errors that can easily be fixed. Take the extra few minutes to review instead of getting counted off for these mistakes.
Review your similarities. Did you forget to cite something? Did you not paraphrase well enough? Is your paper made up of someone else’s thoughts more than your own?
Visit the Writing Center in the Student Success Center, under the Resources tab in LoudCloud for tips on improving your paper and SI score.
Late Policy

The university’s policy on late assignments is 10% penalty PER DAY LATE. This also applies to late DQ replies.
Please communicate with me if you anticipate having to submit an assignment late. I am happy to be flexible, with advance notice. We may be able to work out an extension based on extenuating circumstances.
If you do not communicate with me before submitting an assignment late, the GCU late policy will be in effect.
I do not accept assignments that are two or more weeks late unless we have worked out an extension.
As per policy, no assignments are accepted after the last day of class. Any assignment submitted after midnight on the last day of class will not be accepted for grading.
Communication

Communication is so very important. There are multiple ways to communicate with me:
Questions to Instructor Forum: This is a great place to ask course content or assignment questions. If you have a question, there is a good chance one of your peers does as well. This is a public forum for the class.
Individual Forum: This is a private forum to ask me questions or send me messages. This will be checked at least once every 24 hours.

Scroll to Top