Understanding Databases: Exercises
Type your answers into this Word document. Save when completed and submit as a file upload.
You are a manager of an HIM department and you want to track how many charts each of your employees scanned and indexed. This is the data you found.
On Monday, John did 10 charts, Sue did 25 charts, and Maria did 20 charts.
On Tuesday, John did 12 charts, Sue did 22 charts, and Maria did 20 charts.
On Wednesday, John did 11 charts, Sue did 24 charts, and Maria did 19 charts.
On Thursday, John did 12 charts, Sue did 26 charts, and Maria did 21 charts.
On Friday, John did 10 charts, Sue did 25 charts, and Maria did 20 charts.
Choices: Account ID, Patient ID, Provider ID, Diagnosis Code
Choices: One to one, One to Many, or Many to Many
#. Primary key in the following tables are :-
Patient Table - patient ID
Visit table - account ID
Physician table - provider ID
Provider ID will be primary key in the physician table and it will be foreign key in patient table .
#. A) is one to one because patient will get separate bills for everyday visit and the type of services he got .
B) One to one ,because every patient has individual ID and record number
C) One to many ,because Mary Johnson has multiple diseases like hypertension, hypercholesterolemia,and migraine
D) One to one , because every disease and it's sub parts has its own individual ICD-10 code .
E) Many to many, because she had paid multiple times for the overall three bills
Understanding Databases: Exercises Type your answers into this Word document. Save when completed and submit as...
In your own words, explain the difference between a flat file and a relational database. (5 points) Review the example Hospital Physician Data Dictionary as found in your Lecture this week. Create a similar Data Dictionary for Patients, using the same format. Include at least 5 field names you think should be included in a Patient Data dictionary. Remember to use different data types for dates, text, and numbers. I have given you two examples to start. (10 points) Field...
4. If a survey question asks an open-ended question what type of data is collected? a. Quantitative b. Ratio c. Interval d. Qualitative 5. What data quality characteristic ensures that data supports the reason for the collection of the data? a. Precision b. Currency c. Constancy d. Definition 6. HCUP is a family of databases maintained by: a. CMS b. HHS c. AHRQ d. CDC 7. The fact that there is missing data would be identified in _____. a. Data...
Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database, the first question users should ask themselves is O A. How much information is going to be stored in this database? B. Where should this database be stored? O C. Who is going to use this database? O D. What questions should this database be able to answer? Question 2 of 38 When linking two tables in a relational database, a user will use...
You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with Mom and Pop to discuss their...
For your Project, you will develop a simple battleship game. Battleship is a guessing game for two players. It is played on four grids. Two grids (one for each player) are used to mark each players' fleets of ships (including battleships). The locations of the fleet (these first two grids) are concealed from the other player so that they do not know the locations of the opponent’s ships. Players alternate turns by ‘firing torpedoes’ at the other player's ships. The...
Question 1 An array is NOT: A - Made up of different data types. B - Subscripted by integers. C - A consecutive group of memory chunks. D - None of the choices. Question 2 How many times is the body of the loop executed? int i=1; while(true) { cout << i; if(++i==5) break; } A - Forever B - 4 C - 5 D - 6 E - 0 Question 3 What is wrong with the following piece of...
Use program control statements in the following exercises: Question 1 . Write pseudocode for the following: • Input a time in seconds. • Convert this time to hours, minutes, and seconds and print the result as shown in the following example: 2 300 seconds converts to 0 hours, 38 minutes, 20 seconds. Question 2. The voting for a company chairperson is recorded by entering the numbers 1 to 5 at the keyboard, depending on which of the five candidates secured...
The following are screen grabs of the provided files Thanks so much for your help, and have a nice day! My Java Programming Teacher Gave me this for practice before the exam, butI can't get it to work, and I need a working version to discuss with my teacher ASAP, and I would like to sleep at some point before the exam. Please Help TEST QUESTION 5: Tamagotchi For this question, you will write a number of classes that you...
Assignment Overview In Part 1 of this assignment, you will write a main program and several classes to create and print a small database of baseball player data. The assignment has been split into two parts to encourage you to code your program in an incremental fashion, a technique that will be increasingly important as the semester goes on. Purpose This assignment reviews object-oriented programming concepts such as classes, methods, constructors, accessor methods, and access modifiers. It makes use of...
please Identify the key points and main thesis of the article 2. Describe the skills you will need to develop to manage the hospital of the future. use critical analysis doing these questions Suggestion for writing assignmemnt make believe the reader has never read the article -what are the key points you would want the reader to know in order to understand the hospital of the future. In addition, managers, executives do not have time to read--so again what key...