Final Exam

Read Answers to Recent Questions

Question: In Question 8 II, did you mean to claculate the frequency and importance weights for data we calculated from the previous question (8I), that will include the new rank we added. This will feed into the last question 8IV, in order not to have missing data for some of the intitials which don't have a frequency weight or importance weight. For example, if we only used the rank in the frequency table, then for initial "LK" there isn't an available rank for it in the frequency table, this will result in a missing network score in question 8IV. Answer: Yes these questions are set up so that output of one could be the input to another

Question: I am stuck again! What exactly is the cutoff value and how is it calculated?(VI)? Answer: It is a number calculated as 2/31

Question: In Q7/VII I came with a mass number of records, could that be?Thanks Q7/VIII I don't quite understand what does it want? Answer: I do not think. It is possible that you are including all combination of diagnoses. Retrict the analysis to one client and see if the combination you are looking at corresponds to what you expect

Question: In Q7/3,the score are #'s are in one table correct, also in 7/VI are we to have a table with #'s or just the diagnosis.Thanks Answer: You can have more information than requested in a table as long as it helps you

Question: When you say in Q7I&2 use the datediff and put the dates, are we to use the actual dates are in the fields or fields names.Also in Q7V the first diagnosis are we only to see one field or more than one in the result.Thanks Answer: Of course in an expression you use field names and not the dates themselves. Regarding question 7V use as many fields as you see fit. Obviously you want the date field and you want the diagnoses name field.

Question: Do we get a lesser grade for turning it in late Answer: No, you will not be penalized for late work as long as you do the exam and get the right answers

Question: I can't seem to get the TimeBeween, I finished part V, but the score depending on it, I am getting now expression too complicated, expression contain too many complicated elements, the >0 I tried it under the criteria it's still not working. Answer: I am not sure what is the question. You may find it easier to do things in separate queries. Calculate the time between in one query and then in a separate query select the positive time betweens. This is not necessary in the end but it might help you.

Question: I have completed the project and question 8 but am having difficulty with Q7. I see in "Answers to Recent Questions" that someone else may be in the same boat and were given to Monday to turn in the exam as long as they came in to do the course eval Friday at 4:30. I would like to do this as well. I can email it to you Monday morning or drop it by on my way to work as I pass the GMU everyday. Thank you for considering this request! Answer: I thought I answered this but if not please know that this is ok

Question: Dr. Alemi, I have completed the project and question 8 but am having difficulty with Q7. I see in "Answers to Recent Questions" that someone else may be in the same boat and were given to Monday to turn in the exam as long as they came in to do the course eval Friday at 4:30. I would like to do this as well. I can email it to you Monday morning or drop it by on my way to work as I pass the GMU everyday. Thank you for considering this request! Answer: This is fine with me but I ask that you complete the course evaluation this Friday please. Also if you need extension beyond Monday you can have an incomplete.

Question: Can you clarify how we obtain the first diagnosis? I can retrieve the "Max" date but not for each individual client Answer: If you group the clients ID and look for minimum of the date of diagnosis, you will be able to do this

Question: Can I have more time? Can I hand this in by Monday? Answer: Yes you can. All I ask is that you come at 430 on Friday and evaluate the course. You can hand in your exam on Monday.

Question: I have use the >0 as you have mentioned but it's not working out, I keep getting you may have entered a comma without a preceding value or identifier. Answer: Make sure that you enter the criteria under the field for time between and check to see if the syntax is correct

Question: So I understand that we don't use the similarity Query in obtaining the timebetween, we have to use the not restricted one,not within 30 days.Thanks Answer: Yes.

Question: I have more than one diagnosis for each patient and picking just the first diagnosis is the problem I have now. Would I say Max(encounter.diagnosis) Answer: You want to find the diagnosis that has occured first. This means that you need to select the minimum of the dates so that you find the diagnosis that occured first. Your current formulation selects the maximum of diagnosis names -- which makes no sense.

Question: With the TimeBetween is it suppose to be within 30 days like 7i Answer: No. Here we are not restricted to 30 days any longer

Question: Is this statement correct: TimeBetween: Abs(DateDiff("d",[Encounter.Date],[Encounter_1.Date])) Answer: This is a correct way of calculating time in between for two copies of the encounter table, one called enounter and the other called encounter_1 But I do not understand why you are taking the absolute value. This will lead to double counting of the data. The better approach is to calculate it without absolute value and select all timebetweens that are positive by putting the command > 0 in the criteria box.

Question: With 7V what expression do you use to assign first diagnosis for each patient to Episode1 Answer: Find the first diagnosis by using a maximum function

Question: With 7V are we suppose to create a new encounter table and make the changes required. Thanks Answer: I would use a query for this purpose.

Question: In question no. 7vii, the question ask to find unclassified diagnosis. Is it NOT of classified diagnosis? Answer: Yes

Question: In the time between I didn't use two tables, but only used the function in the query, and still came with data, did I do it wrong then.Thanks Answer: Do one by hand and see if your answers are correct and makes sense. Do you have the right two dates?

Question: Can you please explain 7IV for me I dont understand what the question wants. Thanks Answer: This is merely saying that Cutoff value is 2/31. You do not need to do anything about this here but in other sections when you are comparing a value to cutoff you need to compare it to 2/31

Question: With the problem 7 on TimeBetween. I am having a problem running the query. It ask me to enter parameter value for d(days)and it is just not working..Please if you can help in directing me as to what I am doing wrong I will really appreciate that. Thanks Answer: Make sure that you have two tables and not one and see if putting d within quotes helps.

Question: Everytime I try to datediff for time between I am coming up with a blank database what should I do? Do I have to use the encounter table twice in order to be sucessful? Should it be the same as question 7I without the co occurances? Please help? Answer: Yes of course. When you use the table twice it will give you the combination of diagnosis with every diagnosis in the other table.

Question: I too am having major trouble with question 7. I calculated the number of times two diagnoses co-occur as it is presented in the complex query section, however, I am still having trouble with the rest of it. I used the datediff code and keep getting errors. Should I be adding the datediff to the new co-occurring diagnoses query? Answer: You should add the encounter table twice, then select the date of diagnosis from one table and date of diagnosis from another and use the datediff function to calculate the difference of the two dates. Do this by hand first and then on Access. Make sure that you understand what is being done. Datediff function is provided in the functions under date functions. The syntax is provided and you need to carefully follow the syntax. You may want to put the interval, d, within quotes and see if this resolves the error.

Question: For the 7th question part 1, do we need to make all possible combinations of the diagnosis or in reference time. Answer: What you need to do is to look at all possible combinations but since the order within the pair does not matter you can look at combination between one diagnosis and all subsequent diagnoses. You can do this by making sure that the date for the second daignosis is larger than the date for the first.

Question: I have finished part 8, I still have problems geting the within 30 days & the time between, looked at all the presentations, and I read the suggested reading still having trouble following the Help in access, I can't get a result I keep getting blank data or error.Help please.Thank you Answer: Ok the function you need to use has the following syntax: DateDiff(interval, date1, date2) The interval you want is d for days. Dates are obtained from fields. Read the claims table twice and use the date fields to calculate the difference. Restrict it to one person so that you can follow what is happening with the data. Later you can remove this restriction to work on the entire data.

Question: Is there a function to calculate date between two diagnoses? Answer: Yes I think a useful function is datediff, you might be able to use it to calculate the difference of two dates.

Question: So I understand that the function datediff, we can use it as well for the time between. Answer: Yes take a look at it under functions and you see what it can do and how it works.

Question: I've been working on the final this weekend. I have finished Question 8 in it's entirety. However, I"m really struggling with Part I of Question 7. SInce subsequent Parts of Question 7 rely on the results of this query, I'm concerned that I'm not getting the results I should be getting. I was hoping maybe you can point me to an area of the course and/or texts where it might help. I've been looking through the SQL book and when I try out the intervals for dates I keep getting "invalid procedure call". I'm getting a little frustrated as I spent several hours on this one question last night. Answer: Part one of question 7 is very similar to assignment under complex queries. There is a video that might guide you in doing it.

Question: Where do we find the commands for within 30 days. Answer: You can use the function datediff to calculate the difference of two dates. Then in criteria portion you can restrict the query to select only cases with less than 30 days

Question: In response to the following questions provide both the SQL code for the query and the image of the resulting data. In the following questions, use the enclosed tables for frequency, importance and drug orientation of clients. I see only 2 worksheets...OrientationToDrugUse and ImportanceOfContact..no Frequency worksheet for Question 8 on the HSCI 709 final Answer: Use the arrows in the lower part of Excel to move to worksheets that are hidden from current tabs

Question: Where do we meet to turn the final, semester project and complete the course eval on Friday, 12/16? Answer: Please come to my office in Robinson B room 421. You can hand in your work and complete the evaluation at same time. Please come at 4:30 so that you are all together for a few minutes.

Question: Also Q1 thru 7 are we to start the whole tables from the data, then we create queries ? Answer: Yes, import the data and build queries based on them.

Question: In Q1 thru 10 in 7, we are to use only the data given to us in this page, correct? thanks Answer: Yes, only the data supplied in the Excel file. Note that there are data in different sheets

Question: I'm assuming this exam does not have the 2 hour time limit, but rather it is due on the 16th regardless of when we viewed it? Answer: Yes it is due on December 16th

Question: How do you calcualte the frequency of two diagnoses? Answer: Please note that frequency should be a number between 0 and 1, you can obtain this by counting the number of times a pair of diagnoses co-occur within 30 days and dividing this by total number of diagnoses.

Question: When is the final exam due? Answer: One week after the start of the exam.

Question: any update on how the non-multiple choice questions will be weighted? Answer: Each question will be 4 points

Question: In Question 11: If the patient has more than one claim on the same day; is that considered as a one visit? Answer: No as more than one visit.

Question: In Question 11: what is the difference between: SVC_FROM, SVC_THRU, and LST_ACTV? Answer: Hospitalization occurs over several days. SVC_FROM is the first date of service. SVC_THRU is the last day of service. Please ignore LST_ACTV.

Question: I would like to know CPT code. Where is the cpt code in the claims table? Is it PRCDR_CD? Answer: Yes it is

Question: In question 15: there is only one fow of data for the first month of which the database starts with, and only 4 rows of data for the last. Do we calculate only those? I am not sure that I understand the question correctly, can you please explain the question a little more? Answer: Each client starts with a different month of data. Make sure that you look for each client at the start and end month of their data. For each client you ignore the remaining data.

Question: In question 12: do you want the CPT codes for the month of December as a total of all the December months in the database? or do you want us to show it for each sperate year? Answer: Yes as a total of all December months

Question: In question 11: do you mean by seasons: Winter, Spring, Summer, and fall? and do you want it for all three years of which the database covers, though there is only one complete year? Answer: Assume the summer months are June, July and August, the fall months are September, October and November, the winter months are December, January and February and the spring months are March April and May. Collapse data from all years into these seasons.

Question: Is SVC_CDE in claims table the same as CPT code? Answer: No

Question: In quest. 6 could you please clarify what you mean by "unique patients"? Thank you. Answer: You can count a patient with the same ID only once, even though he/she may have several records in the table.

Question: In Question number 47: the order of the table in the question is(PAT_LNM,PAT_FNM,PAT_ID), while the answers are showing a different order of the table's columns:(PAT_ID,PAT_FNM,PAT_LNM). Can you please explaing the question? Answer: Review the SQL INSERT statement syntax, particularly the use of explicitly named columns and how they affect the order of the data one is trying to insert as a new record in a table.

Question: Question 34, in the Student_address table: are both the student ID and Index keys combined primary keys? Answer: Yes, both the StudentID and the Index are primary key

Question: are all questions worth 2 points each? Answer: No, only the multiple choice questions are worth 2 points. We are currently thinking through the points for the Access data analysis questions

Question: what do you mean when you say you want to see a picture of the query structure? do you want the design view of the actual queries? also, what if more than one query was run to answer one question, do you want to see every single query? Answer: Yes, I would like to see the deisgn view of the query. If multiple queries, then multiple pictures are needed.

Instruction

Answer all questions.
Do not send your database but keep it in case we want to see it
Report your answers in Microsoft word. In answering the questions follow the following rules:
- Repeat each question before providing the answer.
- For each question show picture of the query structure as well as the answer.
- Please name your file <YourName-Final-HCSI-709.doc>.
Bring your file to class. Do not email your file. Bring a print out or a disk copy to class on May 13th 2005 at 4:30.
You can use any resource of your preference (e.g., notes, books, videos, web-sites) EXCEPT another human being.
Check back with this page to read answers to questions asked by you or others.
Answer the first 5 questions as well as all remaining questions.
All multiple answers have only one correct answer
All questions refer to material contained in the lectures and the exercises
Answer every question. There is no penalty for guessing.

Question 1: What is your first and last name?

Question 2: What is your email?

Question 3: What is your telephone number?

Question 4: Identify who has helped you in answering the questions on this exam?

Question 5: Are you in the information technology track?

Import data from the following files into four tables. From ptid.xls to Patients, from claims.xls to Claims, from icd.xls to ICD9, from cpt.xls to CPT table. Then answer following questions:

Count the number of unique patients
Count the total number of female diabetes patients in the database.
Calculate the total cost of each patient sorted from most expensive to least expensive.
Make a Crosstab where the row is gender of the patient, the column is whether the patient has diabetes and the values in the table are average cost per patient.
For patients who have diabetes, identify (in order of frequency) other diagnoses that co-occur with diabetes.
Identify which season of the year has the most visit.
Identify clients that have diagnosis code but no ~~CPT~~ PRCDR_CD code.
Count the number of ~~CPT~~ PRCDR_CD codes in month of December.
Find the number of visits of the person with maximum cost.
Find the percent of change in average cost of care of patients, from first month on which we have data on the patient to the last month on which we have data on the patient

Section 1—use cases

Question #0016 (2 pts)

Which of the following statements is most correct:

(A) A Use Case is the name of a mathematical methodology pioneered by Ivar Ivar Jacobson, one of the three creators of the Unified Modeling Language, or UML and used by among others, the US Air Force to track U-2 aircraft and the Open Source Consortium to develop the Linux kernel.

(B) A Use Case is only a diagram consisting of actors, ovals with text inside them and lines, which can only use the <<extends>> stereotype.

(C) A Use Case is a formal description of an interaction between the actors and the system that is modeled from the point of view of the actors

(D) A Use Case is a formal description of an interaction between the actors and the system that is modeled from the point of view of the actors, together with the exchange of messages between the actor and the system; what the system does to provide the value to the actor, and the possible variants from the usual exchange, including errors, exceptional behavior and conditional behavior

(E) A Use Case is only a diagram consisting of actors, ovals with text inside them, and lines connecting the actors to the ovals which can be leveraged by intelligent agents using DARPA's Ontolingua togenerate OWL files.

ANSWER:

Question #017 (2 pts)

Which of the following statements is most correct:

(A) Use Cases are not part of the Rational Unified Process

(B) Use Cases describe "what" the system does but never "how" it is done

(C) Use cases describe "what" the entity does but never "how" it is done and are always written from the view point of the actor

(D) A and B only

(E) Use cases are always written from the view point of the actor. They can only be used in the last phase of the Rational Unified Process created by Ivar Ivar Jacobson

ANSWER:

Question #018 (2 pts)

Which of the following statements is most correct:

(A) Actors can be categorized as follows: (a) Principal Actors, (b) the Secondary Actors, (c) the External Hardware and (d) IT Support Staff.

(B) In a Use Case actors can be categorized as follows: (1) Principal Actors, (2) Secondary Actors, (3) Tertiary or Ternary actors and (4) Quadratic or Quaternary actors.

(C) In a Use Case actors can be categorized as follows: (1) Principal Actors, (2) Secondary Actors, (3) Special Purpose Software and (4) Networking Routers.

(D) In a Use Case actors can be categorized as follows: (1) Principal Actors, (2) Deputized Principal Actors, (c) the External Hardware and (d) External Systems

(E) In a Use Case actors can be categorized as follows: (1) Principal Actors, (2) Secondary Actors, (c) the External Hardware and (d) Other Systems

ANSWER:

Question #019 (2 pts)

You are analyzing a Use Case written for a system. The Use Case identifies two actors, the PATIENT and the IT-ADMINISTRATOR. Which of the following statements is most accurate:

(A) The PATIENT could be considered a Principal Actor if it interacts with the system and its various functionalities.

(B) The PATIENT could not be considered a Principal Actor because it interacts with the system and its various functionalities.

(C) The PATIENT must always be considered a Secondary Actor because it will most likely interact with the system and its various functionalities but only by proxy.

(D) The IT-ADMINISTRATOR ought to be considered a Principal Actor because he performs vital administrative and maintenance functions with respect to the system without which the system would always crash.

(E) The PATIENT could never be considered a Principal Actor because it interacts with the system and its various functionalities

ANSWER:

Question #020 (2 pts)

With respect to the Use Case shown below which of the following statements is most accurate:

USE CASE: DELETE PATIENT

Overview

The purpose of this use case is to remove a PATIENT from the Pembroke Clinic Information System

Primary Actor

Chief Staff Nurse

Secondary Actor

Clinic IT Manager

Starting Point

The actor must have displayed the list of all PATIENTs currently in the system

Ending Point

The PATIENT is either deleted or the delete is cancelled by the system

Measurable Result

A PATIENT is deleted from the information system

Flow of Events

This use case is started when the actor requests to review the existing list of PATIENTs. The actor then requests to delete the PATIENT information.

If the PATIENT still owes medical fees the actor will be adviced of this by the application and the delete will not be allowed. If there are no medical fees outstanding the actor is prompted to accept or cancel the operation. If the actor accepts the operation, the PATIENT is deleted from the system and the PATIENT list is updated.

Altenative Flow of Events

The actor tries to cancel the removal of a PATIENT from the system when the PATIENT still owes medical fees. The PATIENT delete will be canceled.

Use Case Extensions

None

(A) The information flow between the system and the actor is a list of purchase orders from the Pembroke Clinic pharmacy

(B) The information flow between the system and the actor is a list of doctors who have treated the PATIENTs tracked by the information system.

(C) The information flow between the system and the actor is a list of all the PATIENT's tracked by the system.

(D) The information flow between the sytem and the actor is a splash screen with the address and service hours of the Pembroke Clinic.

(E) None of the above

ANSWER:

Question #021 (2 pts)

With respect to the Use Case described in Question 20 above which of the statements is most accurate:

(A) The use case is written incorrectly because it describes how the delete operation occurs inside the information system

(B) The use case is written incorrectly because the Alternative Flow of Events is a repeat of the Flow of Events

(C) The use case identifies two types of actors and has a measurable result

(D) The use case is written incorrectly because there is no mention of the chief surgeon who is the one with the largest number of patients, and, therefore, is the most important actor in the Pembroke Clinic

(E) The use case is written incorrectly because there is neither mention of demographic information about the patients, nor patient's medical history

ANSWER:

Question #022 (2 pts)

During an interview with the Chief Staff Nurse she indicates that, when she is very busy with other admistrative functions, her assistant is the one who actually will delete patients from the system. Which of the following statements is most accurate:

(A) The use case should be rewritten to list the Chief Staff Nurse's assistant as another secondary actor

(B) The use case does not need to be rewritten because when the assistant performs the patient delete operation she is performing the task of the Chief Staff Nurse and in a use case actors represent roles and anyone can step into that role regardless of what their actual title.

(C) The use case entirely wrong because the PATIENT is the one affected and therefore it is the PATIENT who should show up as the Primary Actor.

(D) A and C only

(E) None of the above

ANSWER:

Question #023 (2 pts)

As part of their modernization activities the Pembroke Clinic has now terminals in the reception area. When a person comes to the clinic the receptionist asks the individual whether she is has already registered. If the person is never been treated at the clinic then the receptionist asks the person to register using one of the free terminals. You are documenting the Pembroke Clinic information system for a related project. For the use case called New Patient Registration it is most appropriate to:

(A) List the receptionist as a Secondary Actor

(B) List the receptionist as a Primary Actor

(C) List both the person who comes into the clinic to seek medical treatment and the receptionist as Primary Actor

(D) List the person who comes into the clinic to seek medical treatment as Primary Actor

(E) A, B and C but not D

ANSWER:

Question #024 (2 pts)

Which of the following statements is most accurate. In a graphical depiction of a Use Case the line joining the Actor and the Use Case:

(A) Represents a semantic relationship between the actor and the use case. The actor interacts with the system by writing code on the GUI. The association between the actor and the use case is the only way an actor can communicate with the system that is being represented by the use case

(B) Represents a semantic relationship between the actor and the use case. The actor interacts with the system by passing e-mail messages. The association between the actor and the use case is the only way an actor can communicate with the system that is being represented by the use case

(C) Represents a semantic relationship between the actor and the use case. The actor interacts with the system by passing hand-written messages to and from the use case. The association between the actor and the use case is the only way an actor can communicate with the system that is being represented by the use case

(D) Represents a semantic relationship between the actor and the use case. The actor interacts with the system by passing encrypted binary streams to and from the use case. The association between the actor and the use case is the only way an actor can communicate with the system that is being represented by the use case

(E) Represents a semantic relationship between the actor and the use case. The actor interacts with the system by passing messages to and from the use case. The association between the actor and the use case is the only way an actor can communicate with the system that is being represented by the use case

ANSWER:

Question #025 (2 pts)

Which of the following statements is most accurate. The major weakness of Use Cases is that:

(A) It is not possible to indicate whether an Actor can send more than one message. In other words there is no way to express a one-to-one-or-more multiplicity for the interactions.

(B) There is substantial ambiguity with respect to whether one should use the <<extends>> stereotype versus the <<uses>> stereotype when one refines the use case.

(C) There is no way to express the full semantics of the participation of an Actor with repect to a use case.

(D) It uses stick figures for actors in the UML notation which is not politically correct because the gender of the person cannot be immediately recognized, and, therefore, one is likely to assume that the actor is always a male, which is totally wrong.

(E) All of the above

ANSWER:

SECTION 2—database NORMALIZATION

Question #026 (2 pts)

Which of the following statements is correct:

(A) The goal of database normalization is to achieve a structure that preserves the integrity of the data while minimizing redundant data.

(B) The goal of database normalization is to eliminate the use of flat tables in industry and convince everybody that using Excel is primitive and only RDBMSs should be employed.

(C) The goal of database normalization is to ensure that DBA's will continue to get six-figure salaries because no average mortal can normalize a database.

(D) The goal of database normalization is to ensure that Oracle and MS SQL Server will continue their dominance in the market place.

(E) All of the above

ANSWER:

Question #027 (2 pts)

With respect to the table below, which of the statements is most accurate:

PATIENT

PAT_FNM	PAT_LNM	PAT_DOB	PAT_ADDRESS
Hunter	Thompson	1975-12-01	123 Elm Street, Alexandria, VA 22311
Johnny	Macain	1960-01-12	123 Elm Street, Alexandria, VA 22311
Sandy	Allenby	1960-01-12	234 Montrose Drive, Fairfax, VA 22310, 4423 Calvin Rd., Alexandria, VA 22311

(A) The table is in First Normal Form because all the rows have the same number of columns.

(B) The table is not in First Normal Form because the values for PAT_DOB corresponding to the second and third records are identical.

(C) The table is not in First Normal Form because the values for PAT_ADDRESS corresponding to the first and second records are identical.

(D) The table is not in First Normal Form because not all entries are atomic.

(E) The table is in First Normal Form because one could use PAT_FNM and PAT_LNM as the key and that would uniquely identify every record.

ANSWER:

Question #028 (2 pts)

With respect to the table shown in Question 27 above, which of the statements is most accurate:

(A) The data in the table could be brought into First Normal Form by (1) creating a new table to list the patient's addresses (2) adding a join table between the Patient and the Patient-Address table.

(B) The data in the table could be brought into First Normal Form by (1) creating a new table to list the patient's addresses (2) inserting a surrogate key in the Patient and that Patient Address tables and (3) adding a join table between the Patient and the Patient-Address table.

(C) The data in the table could be brought into First Normal Form by (1) creating a Java class that maps the multiplicity of addresses to a unified Patient list (2) adding a MOF metaclass to the OMG specification of UML.

(D) The data in the table could be brought into First Normal Form by (1) creating as many tables for addresses as there are distinct addresses in the original table and (2) adding a join tables between the Patient and the new Patient-Address tables.

(E) The data in the table could be brought into First Normal Form by (1) creating as many new tables as there are column in the original table (2) adding a join table between all the new tables.

ANSWER:

Question #029 (2 pts)

Which of the following statements is the most accurate:

(A) A table is in Second Normal Form if it is in First Normal Form and all non-primary key columns depend on the entire key.

(B) A table is in Second Normal Form if it is in First Normal Form and every column depends on the entire key.

(C) A table is in Second Normal Form if it is in First Normal Form and no even-numbered column depends on the entire key.

(D) A table is in Second Normal Form if it is in First Normal Form and no odd-numbered column depends on the entire key.

(E) A table is in Second Normal Form if it is in First Normal Form and every third and fifth columns depend on the entire key.

ANSWER:

Question #030 (2 pts)

Which of the following statements is most accurate:

(A) A table is in Third Normal Form if it is in Quadratic Form and the Error Coding Algorithm returns TRUE when the data is tested

(B) A table is in Third Normal Form if it is generated from a UML Class diagram that validates according to the Pennker-Allers Test for full normalization.

(C) A table is in Third Normal Form if is it is in Second Normal Form and all non-primary columns depend on the key, the full key and nothing but the key.

(D) A table is in Third Normal Form if one uses surrogate keys and hopes for the best.

(E) A table is in Third Normal Form if one eliminates all surrogate keys and flattens the table to make it exportable to Excel.

ANSWER:

Question #031 (2 pts)

In the information system used by the Chelsea Hospital, only the current address of the patient is kept. If a patient changes address then the old address is updated to the new address. No record of previous addresses is maintained. Given those facts which of the following statements is most accurate:

(A) The cardinality of the link between the Patient table and the Patient-Address table is one-to-many.

(B) The cardinality of the link between the Patient table and the Patient-Address table is one-to-two-or-more.

(C) The cardinality of the link between the Patient table and the Patient-Address table is one-to-zero-one-or-more.

(D) The cardinality of the link between the Patient table and the Patient-Address table is one-to-one.

(E) The cardinality of the link between the Patient table and the Patient-Address table is <<undetermined>> because when the UPDATE statement executes, there is a moment in time when the Patient has no address listed in the system.

ANSWER:

Question #032 (2 pts)

With respect to the table below which of the following statements is most accurate:

Student ID	Name	Midterm grade	Final grade	Address	Zip code
4561	Ali Safaie	B	A	1311 Manor Park	22101
22311	Mike Smith	C	B	1619 Ozkan Street	22311
8954	Mike Smith Jr.	A	C	2121 Euclid 563	22101

(A) The column labeled Student ID cannot be the key because keys must be globally unique and in the second record the value of the ZIP code is identical to that of the Student ID

(B) The column labeled Student ID cannot be the key because keys must be globally unique and only in the second record is the value of the ZIP code identical to that of the Student ID

(C) The column labeled Student ID could be the key provided one chooses a diiferent value so in the second record the value of the ZIP code is not identical to that of the Student ID

(D) A combination of A and D but not C

(E) The column labeled Student ID could be the key even tough in the second record the value of the ZIP code is identical to that of the Student ID

ANSWER:

Question #033 (2 pts)

With respect to the table shown in Question 032 which of the following statement is most correct:

(A) An attempt to insert a new record with Student ID = 4561 would succeed even if the Student ID is used as the key because the only requirement for primary keys is that they not be NULL.

(B) An attempt to insert a new record with Student ID = 4561 would succeed even if the Student ID is used as the key because provided the table is implemented in MySQL and one uses the C API's provided by the vendor.

(C) An attempt to insert a new record with Student ID = 4561 would succeed even if the Student ID is used as the key because provided the table is implemented in MySQL and one uses the latest version of the JDBC connector.

(D) An attempt to insert a new record with Student ID = 4561 would not succeed if the Student ID is used as the key because the primary key must be unique.

(E) An attempt to insert a new record with Student ID = 4561 would not succeed if the Student ID is used as the key because it violates referential integrity.

ANSWER:

Question #034(2 pts)

Assuming that the STUDENT-ADDRESS table is linked to the STUDENT table, i.e., the Student ID in the former is a Foreign Key pointing to the records in the latter, which of the following statements is most accurate:

STUDENT

Student ID	Name	Midterm grade	Final grade
4561	Ali Safaie	B	A
22311	Mike Smith	C	B
8954	Mike Smith Jr.	A	C

STUDENT-ADDRESS

Student ID	Index	Address	Zip code
4561	1	1311 Manor Park	22101
22311	1	1619 Ozkan Street	22311
8954	1	2121 Euclid 563	22101

(A) The student Ali Safaie cannot have two or more addresses.

(B) The student Ali Safaie can have at most two addresses.

(C) The student Ali Safaie can have any number of addresses provided the index for each address record is different.

(D) The student Ali Safaie only can have up to 255 addresses because a column named Index has always the SQL Data Type BYTE, and the maximum value for such a data type cannot exceed 255.

(E) The student Ali Safaie must always have 255 addresses because a column named Index has always the SQL Data Type BYTE, and the maximum value for such a data type is 255.

ANSWER:

Question #035 (2 pts)

Using the same conditions and tables shown in Question 19 above, which of the following statements is most accurate:

(A) An attempt to insert a new record in the STUDENT-ADDRESS table with Student ID = 131313 and Index = 1 will succeed because the combination of the two values is not already present in the table.

(B) An attempt to insert a new record in the STUDENT-ADDRESS table with Student ID = 131313 and Index = 1 will not succeed because it would violate referential integrity.

(C) An attempt to insert a new record in the STUDENT-ADDRESS table with Student ID = 131313 and Index = 1 will succeed because the Index can be set to "1" any number of times.

(D) An attempt to insert a new record in the STUDENT-ADDRESS table with Student ID = 131313 and Index = 1 will not succeed because the it would denormalize the table.

(E) An attempt to insert a new record in the STUDENT-ADDRESS table with Student ID = 131313 and Index = 1 will not succeed because it would change the allegorical posture of the clavial zizigy inherent in the post-newtonian frame of reference of all commercial RDBMSs.

ANSWER:

SECTION 3—data modeling (er diagram)

Question #036 (2 pts)

With respect to the data class diagram below, which of the following statements is most accurate:

Diagnosis

Patient ID

Diagnosis Code

Diagnosis Remarks

Diagnosis Calendar Date

(A) The name of the data class (or Entity) is Patient-Diagnosis

(B) The real name of the data class (or Entity) is Patient because the diagnosis is about the patient

(C) The name of the data class (or Entity) is Patient and it has 5 attributes, namely, Diagnosis, Patient ID, Diagnosis Code, Diagnosis Remarks, Diagnosis Calendar Date

(D) The name of the data class (or Entity) is Diagnosis and it has no attributes

(E) The name of the data class (or Entity) is Diagnosis and it has 4 attributes

ANSWER:

Question #037 (2 pts)

A portion of the documentation of the information model that contains the data class shown in Question 036 is shown below.

Entity Name

DIAGNOSIS

Entity Type

Independent

Entity Definition

A diagnosis for a patient treated by a medical doctor.

Which of the following statements is most accurate:

(A) The definition of the entity DIAGNOSIS is optimal because everybody knows what a diagnosis is, so there is no need to define the obvious

(B) The definition of the entity DIAGNOSIS is circular because it uses the term to be defined in its own definition

(C) The definition of the entity DIAGNOSIS is circular but it is the best one can accomplish because in this day and age with so many medical tests nobody can say what a diagnosis really is

(D) The definition of the entity DIAGNOSIS is optimal because it is contextualized by the reference to Megahealth Corporation

(E) All of the above

ANSWER:

Question #038 (2 pts)

The Figure shown below represents a graphical depiction of an information model.

Which of the following statements is most accurate:

(A) The information model contains eleven entities and the most generic data class shown in OBJECT-ITEM

(B) The information model contains three entities, namely, PERSON, FACILITY and PERSON, and in addition it shows that the entity ADMINISTRATOR has two attributes, namely, IT-Administrator and Hospital Administrator

(C) The information model contains four entities, namely, OBJECT-ITEM, PERSON, FACILITY and PERSON, and in addition it shows that the entity ADMINISTRATOR has two attributes, namely, IT Administrator and Hospital Administrator

(D) The information model contains eleven entities and ten subtype hierarchies

(E) The information model contains eleven entities and ten subtype ("is-a") hierarchies

ANSWER:

Question #039 (2 pts)

With respect to the Figure shown in Question 038 above. Which of the following statements is most accurate:

(A) ICU Physician is a specialization of MEDICAL-DOCTOR, which is a specialization of PERSON which is a specialization of FACILITY

(B) ICU Physician is a specialization of MEDICAL-DOCTOR, which is a specialization of PERSON which is a specialization of MATERIEL

(C) Both ICU Physician and Internist are generalized under the data class MEDICAL-DOCTOR, which is generalized under the data class PERSON which is generalized under the data class OBJECT-ITEM

(D) Only ICU Physician and Internist but not Cardiologist are generalized under the data class MEDICAL-DOCTOR, which is generalized under the data class PERSON which is generalized under the data class OBJECT-ITEM

(E) ICU Physician is generalized under the data class MEDICAL-DOCTOR, which is generalized under the data class PERSON which is generalized under the data class OBJECT-ITEM

ANSWER:

Question #040 (2 pts)

With respect to the Figure shown in Question 038 above. Which of the following statements is most accurate:

(A) The correct verb-phrase for the link originating in OBJECT-ITEM and ending in the linked entity FACILITY is "may-be-a" because not every OBJECT-ITEM can always be said to be an instance of FACILITY

(B) The correct verb-phrase for the link originating in OBJECT-ITEM and ending in the linked entity FACILITY is "is-a"

(C) The correct verb-phrase for the link originating in OBJECT-ITEM and ending in the linked entity FACILITY is "is-a" and the cardinality of the link is "one-to-one-or-more"

(D) The correct verb-phrase for the link originating in OBJECT-ITEM and ending in the linked entity FACILITY is "is-a" and the cardinality of the link is "one-to-zero-or-one"

(E) A and D but not B

ANSWER:

Question #041 (2 pts)

With respect to the Figure shown in Question 038 above. Which of the following statements is most accurate:

(A) In order to navigate from OBJECT-ITEM to one of its subtypes there should be an attribute in OBJECT-ITEM, e.g, Category-Code, and its metadata could contain the following Contraint: Enumeration(MATERIEL, MEDICAL-DOCTOR, PERSON)

(B) In order to navigate from OBJECT-ITEM to one of its subtypes there should be an attribute in OBJECT-ITEM, e.g, Category-Code, and its metadata must contain the following Contraint: Enumeration(FACILITY, PERSON, MATERIEL, MEDICAL-DOCTOR, ADMINISTRATOR, IT ADMINISTRATOR, HOSPITAL ADMINISTRATOR, ICU PHYSICIAN, INTERNIST, CARDIOLOGIST)

(C) In order to navigate from OBJECT-ITEM to one of its subtypes there should be an attribute in OBJECT-ITEM, e.g, Category-Code, and its metadata could contain the following Contraint: Enumeration(MATERIEL, FACILITY, PERSON)

(D) In order to navigate from OBJECT-ITEM to one of its subtypes there should be an attribute in OBJECT-ITEM, e.g, Category-Code, and its metadata must contain the following Contraint: Enumeration(MATERIEL, MEDICAL-DOCTOR, ADMINISTRATOR, PERSON)

(E) The combination of B and C but not A

ANSWER:

Question #042 (2 pts)

The Figure shown below represents a graphical depiction of an information model. Which of the following statements is most accurate:

Which of the following statements is most accurate:

(A) The ontological supertype of BLOOD-LAB-FACILITY is MEDICAL-FACILITY-ASSOCIATION, because it is above MEDICAL-FACILITY and the more general classes are always depicted above their specializations.

(A) The entity MEDICAL-FACILITY has four attributes, namely, HOSPITAL-FACILITY, MRI-FACILITY, ORTHODONTICS-FACILITY, BLOOD-LAB-FACILITY and ORTHOPEDICS-FACILITY

(C) The deontic supertype of BLOOD-LAB-FACILITY is FACILITY, because it is above MEDICAL-FACILITY-ASSOCIATION and the more general classes are always depicted above their specializations.

(D) The information model is complete because it has at least one double associative entity.

(E) None of the above

ANSWER:

Question #043 (2 pts)

With respect to the Figure shown in Question 042 above and based on the materials covered in the course. Which of the following statements is most accurate:

A proper definition for MEDICAL-FACILITY-ASSOCIATION, is:

(A) A relationship of an instance of HOSPITAL-FACILITY as the ordinate with another instance of MEDICAL-FACILITY as the subordinate that specifies a particular kind of dependence between them.

(B) A formal organization consisting of hospitals, radiology centers, orthodontists, orthopedics and serologists chartered under the laws of the state of Virginia.

(C) A formal organization chartered under the laws of the state of Virginia whose members are instances of HOSPITAL-FACILITY, MRI-FACILITY, ORTHODONTICS-FACILITY, BLOOD-LAB-FACILITY and ORTHOPEDICS-FACILITY .

(D) A relationship of an instance of HOSPITAL-FACILITY as the ordinate with another instance of MRI-FACILITY as the subordinate that specifies a particular kind of dependence between them.

(E) A relationship of an instance of MEDICAL-FACILITY as the ordinate with another instance of MEDICAL-FACILITY as the subordinate that specifies a particular kind of dependence between them.

ANSWER:

Question #044 (2 pts)

With respect to the Figure shown in Question 042 above and based on the materials covered in the course. Which of the following statements is most accurate:

A proper definition for OBJECT-ITEM, is:

(A) An individually identifiable instance that forms an element of, or constitutes the subject matter of our medical system. Note: Instances of OBJECT-ITEM can be persons, facilities, or materiel.

(B) An OBJECT-ITEM of interest to Megahealth Corporation

(C) A thing. Basically, anything, as long as it can be identified with a card reader.

(D) A supertype. Its subtypes are PERSON, MATERIEL, and FACILITY

(E) Either A or B but not C

ANSWER:

Question #045 (2 pts)

The Figure shown below represents a graphical depiction of an information model. Based on the materials covered in the course.

If the attribute Assoc-Type-Code in the entity Medical-Facility-Assn is defined as:

The alpha-numeric string that represents the kind of MEDICAL-FACILITY-ASSOCIATION

Which of the following statements is most accurate:

(A) The attribute must be used for navigating from MEDICAL-FACILITY to MRI-FACILITY.

(B) The attribute could be use to state the nature of the association between an instance of HOSPITAL-FACILITY and a particular ORTHOPEDICS-FACILITY.

(C) The attribute must be used for navigating from HOSPITAL-FACILITY to MRI-FACILITY.

(D) The attribute is useless because it depends on the date when the association begins and this can never be ascertained ahead of time

(E) The attribute is very useful because one can generalize it to point to additional addresses in the system pertaining to the same instance of HOSPITAL-FACILITY.

ANSWER:

SECTION 10—SQL (ONLY FOR IT TRACK STUDENTS)

Question #046 (2 pts)

With respect to the SQL stament shown below:

CREATE TABLE PAT (

PAT_ID INT NOT NULL PRIMARY KEY,

PAT_FM VARCHAR(20),

PAT_LNM VARCHAR(35)

)

TYPE=INNODB;

Which of the following statements is most accurate:

(A) Executing it in MySQL would create the a table named PAT but the table would not support referential integrity

(B) Executing it in MySQL would create the a table named PAT and the table would support referential integrity

(C) Executing it in MySQL would create the a table named PAT-LNM and the table would support referential integrity

(D) Executing it in MySQL would create the a table named PAT-FNM and the table would support referential integrity

(E) Executing it in MySQL would create the a table named PAT-FNM but the table would not support referential integrity

ANSWER:

Question #047 (2 pts)

With respect to the SQL stament shown below and assuming the the PAT table was created with the statement shown in Question 31 above:

INSERT INTO PAT(PAT_LNM,PAT_FNM,PAT_ID) VALUES

('MARTINEZ','MANUEL',45674),

('VALLARES','MARGARITA',45675);

Which of the following statements is most accurate:

(A) The INSERT will fail because the table columns are PAT_ID, PAT_FNM and PAT_LNM.

(B) The INSERT will not fail even tough the table columns are PAT_ID, PAT_FNM and PAT_LNM.

(C) The INSERT will not fail even tough the table columns are PAT_ID, PAT_FNM and PAT_LNM because INSERT statement lists the order of the columns and this supersedes the default order in the PAT table

(D) The INSERT will fail because PAT_ID has the SQL data type INT and the insert statement is trying to write a string into that field.

(E) The INSERT will fail because the PAT_LNM has the SQL data type VARCHAR(35) and the insert statement is trying to write a number into that field.

ANSWER:

Question #048 (2 pts)

When using MySQL which of the following statements is most accurate:

(A) To create a new database called MedicalRecords one uses CREATE DATABASE MedicalRecords;

(B) To create a new database called MedicalRecords one uses CREATE DATABASE Medical AND JOIN DATABASE Records;

(C) To create a new database called MedicalRecords one uses CREATE DATABASE USING SELECT MedicalRecords LEFT JOIN Hospitalization

(D) B or C but not A

(E) All of the above

ANSWER:

Question #049 (2 pts)

When using MySQL which of the following statements is most accurate:

(A) To connect to the database MedicalRecords one uses the command CONNECTOR MedicalRecords;

(B) To connect to the database MedicalRecords one uses the command USE MedicalRecords;

(C) To connect to the database MedicalRecords one uses the command OPEN MedicalRecords;

(D) To connect to the database MedicalRecords one uses the command CONNECT WHILE OPENING MedicalRecords;

(E) To connect to the database MedicalRecords one uses the command RECONNECT TO MedicalRecords DELAY = 0;

ANSWER:

Question #050 (2 pts)

With respect to the SQL statement below:

SELECT PAT.PAT_FNM, PAT.PAT_LNM, CLNCIAN.CLNCIAN_NM

FROM CLNCIAN RIGHT JOIN PAT ON CLNCIAN.PAT_ID = PAT.PAT_ID;

Which of the following statements is most accurate:

(A) Executing this command will retrieve all the records from PAT and those records from CLNCIAN where the PAT_ID values are equal on both tables.

(B) Executing this command will retrieve all the records from CLNCIAN and those records from PAT where the PAT_ID values are equal on both tables.

(C) Executing this command will retrieve all the records from PAT and CLNCIAN where the PAT_ID values are equal on both tables.

(D) Executing this command will retrieve all the records form PAT but no records from CLNCIAN.

(E) Executing this command will retrieve all the records form CLNCIAN but no records from PAT.

ANSWER: