Assignment: Database Systems Design

Assignment: Database Systems Design

Assignment: Database Systems Design

Permalink: ‎

Plagiarism is the use of someone else’s ideas without giving proper acknowledgment. The term “plagiarism” includes, but is not limited to, the use, by paraphrase or direct quotation, of the published or unpublished work of another person without full and clear acknowledgment. It also includes the unacknowledged use of materials prepared by another person or agency engaged in the furnishing or selling of term papers or other academic materials.

The Modern Language Association’s MLA Handbook for Writers of Research Papers defines plagiarism as follows:

• repeating another’s sentences as your own,
• adopting a particularly apt phrase as your own,
• paraphrasing someone else’s argument as your own,
• presenting someone else’s line of thinking in the development of a thesis as though it were your own.

In short, to plagiarize is to give the impression that you have written or thought something that you have in fact borrowed from another.

Appearance

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.

Please number the pages of your essay (except for the title page).

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.

Final check list

Before handing in your paper, please check the following items:

The pages are numbered.

The paper includes citations and a bibliography.

You have spell-checked, grammar-checked, and proofread the paper.

Part 3 – Queries and Reports

In Week 5, you began working on Parts 1 and 2 of this Assignment. This week you begin working on Part 3. The entire Application (all three parts) is due in or before Day 7 of Week 8.

Instructions – Creating Queries

1. Create a query that displays all patient records for each provider (PROVIDERS and PATIENT RECORDS)
   1. Provide an appropriate query title.
2. Create another query that displays the nurse and patient information for each patient visit listed in PATIENT RECORDS. This query should display the following fields from PATIENT RECORDS, PATIENTS, and NURSES:
   

   Nurse Last Name
   Nurse First Name
   Patient Last Name
   Patient First Name
   Date Admitted
   Chief Complaint

   1. Provide an appropriate query title.
3. Create another query that displays the provider and nurse information for each patient visit listed in PATIENT RECORDS. This query should display the following fields from PATIENT RECORDS, PATIENTS, PROVIDERS, and NURSES:

Provider Last Name
Provider ID
Nurse Last Name
Nurse ID
Medical Record Number
Account Number
Patient Last Name
Date Admitted
Chief Complaint

• 1. Provide an appropriate Query title.

Instructions – Creating Reports

Prepare two (2) reports as follows from queries #2 and #3 created above:

1. Create a report from each customizing the header to “Community Health and Wellness Clinic”

• • Using query #2 create a summary report; group the contents under Nurse Last Name
  • Using the query #3 create a summary report; group the contents under Provider Last Name.