Midterm Exam Correct Responses

Section 1—use cases

Question #001 (2 pts)

Which of the following statements is most correct:

(A) A Use Case is only a diagram consisting of actors, ovals with text inside them and lines, which can be automatically generated by so-called CASE tools such as RationalRose or Enterprise Architect.

(B) 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 usind the Ontology Web Language to provide decision support in mission-critical applications

(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 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, NASA to track satellites and the World Wide Web Consortium (W3C) to develop the Knowledge Web

ANSWER: D

Question #002 (2 pts)

Which of the following statements is most correct:

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

(B) 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) Use cases are always written from the view point of the actor. They are used in the last phase of the Rational Unified Process created by Ivar Ivar Jacobson

(E) None of the above

ANSWER: B

Question #003 (2 pts)

Which of the following statements is most correct:

(A) 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.

(B) In a Use Case actors can be categorized as follows: (1) Principal Actors, (2) Secondary Actors, (3) Software and (4) Hardware.

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

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

(E) Actors can be categorized as follows: (a) Principal Actors, (b) the Secondary Actors, (c) the External Hardware and (d) External Systems.

ANSWER: E

Question #004 (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 Principal Actor because it will most likely interact with the system and its various functionalities

(D) The PATIENT and the IT-ADMINISTRATOR could considered Principals Actors because the PATIENT interacts with the system and its various functionalities and the IT-ADMISTRATOR 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: A

Question #005 (2 pts)

Which of the following statements is most accurate:

(A) You must always have the following seven elements in a Use Case otherwise the Use Case is by definition wrong: (1) the beginning of the use case, (2) the end of the use case (3) the interaction between the use case and the actors, (4) the exchanges of information, (5) the chronology and the origin of the information, (6) Behavior Repetitions and (7) Optional Situations.

(B) You must always have the following seven elements in a Use Case otherwise the Use Case is by definition wrong: (1) the repetition of the use case, (2) the end of the use case (3) the interaction between the use case and the actors, (4) the exchanges of information, (5) the chronology and the origin of the information, (6) Behavior Repetitions and (7) Optional Situations.

(C) You must always have the following seven elements in a Use Case otherwise the Use Case is by definition wrong: (1) the beginning of the use case, (2) the inner loop of the use case (3) the interaction between the use case and the actors, (4) the exchanges of information, (5) the chronology and the origin of the information, (6) Behavior Repetitions and (7) Optional Situations.

(D) You must always have the following seven elements in a Use Case otherwise the Use Case is by definition wrong: (1) the beginning of the use case, (2) the end of the use case (3) the interconnection between the use case and the actors, (4) the exchanges of Information, (5) the chronology and the origin of the information, (6) Behavior Repetitions and (7) Optional Situations.

(E) None of the above

ANSWER: E

Question #006 (2 pts)

You are documenting a use case for an on-line system whose principal actor is the PATIENT. Which of the following statements is most accurate:

(A) For the Information Exchanges it is more than enough to state that the PATIENT will provide pertinent information as prompted by the system

(B) For the Information Exchanges it is more than enough to state that the PATIENT will provide stuff as prompted by the system

(C) For the Information Exchanges it is more than enough to state that the PATIENT will provide name and address as prompted by the system

(D) For the Information Exchanges it is mandatory to state that the PATIENT will provide his first name, last name, street name, street number, city, state, and ZIP code as prompted by the system

(E) For the Information Exchanges it is recommended to state that the PATIENT will provide his first name, last name, street name, street number, city, state, and ZIP code if that is what the system requests

ANSWER: E

Question #007 (2 pts)

Which of the following statements is most accurate. A detailed documentation of the information exchanges is most important because:

(A) It forms the basis of the system's GUI development

(B) It forms the basis of the system's business layer, which is likely to be written in C++ or Java

(D) It forms the basis of the system's migration strategy

(E) It forms the basis of the system's security metadata layer

ANSWER: C

Question #008 (2 pts)

Which of the following statements is most accurate. In the context of a Use Case a scenario is:

(A) All possible sequences of interactions between the actor and the system

(B) Only the first sequence of interactions between the actor and the system

(D) A bundled sequence of interactions between the actor and the system

(E) C and D but not A

ANSWER: D

Question #009 (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 represents a semantic relationship between:

(A) 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

(B) 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

(C) 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

(D) 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

(E) 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

ANSWER: A

Question #010 (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) It is not possible to indicate whether an Actor can send only one message. In other words there is no way to express a one-to-one multiplicity for the interaction

(C) It is not possible to indicate whether an Actor can send only three messages. In other words there is no way to express a one-to-three multiplicity for the interaction

(D) Only A and C but not B

(E) None of the above

ANSWER: A

SECTION 2—Evolution of databases

Question #011 (2 pts)

Which of the following statements is correct:

(A) Flat databases are preferable to relational databases because they do not waste computer storage

(B) Flat databases are preferable to relational databases because they do not force the user to keep information on items that logically cannot be available

(C) Flat databases are preferable to relational databases because they do not keep large sparse data full of missing information

(D) Flat databases are preferable to relational databases because they are conducive to complicated search queries that divide the database further

(E) None of the above

ANSWER: E

Question #012 (2 pts)

Which of the following statements is not correct:

(A) In a relational database, all related data is stored as a record

(B) In a relational database a primary key is needed to identify the content of a record

(C) In relational databases it is often necessary to put facts not about the primary key in a separate table with a different primary key, because the facts in a table are about the primary key

(D) In relational databases for a given table its associated tables do not need pointers to indicate their linkage because the validation rules enforce all relationships

(E) In relational databases the primary key of any given table is always locally unique

ANSWER: D

Question #013 (2 pts)

Which of the following statements is incorrect

(A) Relational databases make life difficult for the designer of the database because many possible relationships must be anticipated

(B) Relational databases are normally considered hard to modify because adding new concepts involves adding new tables, not simply altering old ones

(C) Relational databases make life easy for the user because it is possible to avoid having to enter missing information for variables that are not logically possible

(D) Relational databases make life easy for the user data entry and data processing speeds are higher

(E) Relational databases make life easy for the user because data can be examined from many different perspectives

ANSWER: B

Question #014 (2 pts)

Which of the following statements is the most accurate:

(A) In a relational database, tables need to be of the same size but they don't need to have a key column that connects them to each other and that uniquely defines the elements inside the table

(B) In a relational database, tables do not need to be of the same size but they all need to have a key column that connects them to each other and that uniquely defines the elements inside the table

(C) In a relational database, tables do not need to be of the same size and they don't need to have a key column that connects them to each other and that uniquely defines the elements inside the table

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

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

ANSWER: B

Question #015 (2 pts)

Which of the following statements is most accurate:

(A) One of the great advantages of flat tables is that you don't need a key

(B) One of the great advantages of flat tables is that you must have a composite key

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

(E) None of the above

ANSWER: E

Question #016 (2 pts)

Which of the following statements is most accurate:

(A) Use of flat tables is strongly discouraged because there are no cases where they do a good job

(B) Use of flat tables is strongly discouraged because in all cases they do a good job

(D) Use of flat tables is strongly discouraged because their widespread use would ruin the relational database business

(E) A combination of B and D

ANSWER: C

Question #017 (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 even tough in the second record the value of the ZIP code is identical to that of the Student ID

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

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

ANSWER: C

Question #018 (2 pts)

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

(A) The record with Student ID = 8954 has the ZIP code 22101 and the record with Student ID = 4561 has the the ZIP code 22101

(B) The record with Student ID = 8954 has the ZIP code 22101 and the record with Student ID = 4561 has the the Name = Ali Safaie

(C) The record with Student ID = 8954 has the ZIP code 22101 and the record with Student ID = 4561 has the the Final Grade = A

(D) The record with Student ID = 8954 has the ZIP code 22101 and the record with Student ID = 22311 has the the Final Grade = A

(E) A, B and C but not D

ANSWER: E

Question #019 (2 pts)

Which of the following statements is most accurate:

(A) Flat databases are specially conducive to complicated search queries that divide the database further.

(B) Flat databases are totally conducive to complicated search queries that divide the database further.

(D) Flat databases are thoroughly conducive to complicated search queries that divide the database further.

(E) Flat databases are not conducive to complicated search queries that divide the database further.

ANSWER: E

Question #020 (2 pts)

Which of the following statements is most accurate:

(A) To effectively store both information items and the relationships among these items, relational data may be kept in table formats, but it is not absolutely necessary.

(B) To effectively store both information items and the relationships among these items, relational data must not be kept in table formats, but it is not absolutely necessary.

(C) To effectively store both information items and the relationships among these items, relational data are not kept in table formats.

(D) To effectively store both information items and the relationships among these items, relational data are kept in table formats.

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

ANSWER: D

SECTION 3—data modeling (er diagram) and modeling data class linkages

Question #021 (2 pts)

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

Patient

First-Name

Last-Name

Address

Telephone-Number

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

(B) The name of the data class (or Entity) is Patient and it has 5 attributes

(C) The name of the data class (or Entity) is Patient and it has 5 attributes, namely, Patient, First-Name, Last-Name, Addess and Telephone-Number

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

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

ANSWER: E

Question #022 (2 pts)

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

Entity Name

PATIENT

Entity Type

Independent

Entity Definition

A PATIENT who is treated by Megahealth Corporation.

Which of the following statements is most accurate:

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

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

(C) The definition of the entity PATIENT is circular but it is the best one can accomplish because in this day and age with so many health care providers nobody can say what a patient really is

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

(E) All of the above

ANSWER: B

Question #023 (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 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

(B) 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 ("is-a") hierarchies

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

ANSWER: E

Question #024 (2 pts)

With respect to the Figure shown in Question 023 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) 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

(D) 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

(E) 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

ANSWER: D

Question #025 (2 pts)

With respect to the Figure shown in Question 023 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 MATERIEL is "may-be-a" because not every OBJECT-ITEM can always be said to be an instance of MATERIEL

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

(C) The correct verb-phrase for the link originating in OBJECT-ITEM and ending in the linked entity MATERIEL 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 MATERIEL is "is-a" and the cardinality of the link is "one-to-zero-or-one"

(E) A and D but not B

ANSWER: D

Question #026 (2 pts)

With respect to the Figure shown in Question 023 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 must contain the following Contraint: Enumeration(MATERIEL, MEDICAL-DOCTOR, ADMINISTRATOR, 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 could contain the following Contraint: Enumeration(MATERIEL, FACILITY, PERSON)

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

ANSWER: D

Question #027 (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 entity MEDICAL-FACILITY has four attributes, namely, HOSPITAL-FACILITY, MRI-FACILITY, ORTHODONTICS-FACILITY, BLOOD-LAB-FACILITY and ORTHOPEDICS-FACILITY

(B) The proper 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.

(C) The proper 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 incomplete because it does not have a double associative entity for either FACILITY or OBJECT-ITEM

(E) None of the above

ANSWER: E

Question #028 (2 pts)

With respect to the Figure shown in Question 027 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 formal organization consisting of hospitals, radiology centers, orthodontists, orthopedics and serologists chartered under the laws of the state of Virginia.

(B) 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 .

(C) 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.

(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: E

Question #029 (2 pts)

With respect to the Figure shown in Question 027 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 OBJECT-ITEM of interest to Megahealth Corporation

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

(D) 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.

(E) Either A or B but not C

ANSWER: D

Question #030 (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 used to state how one Hospital relates to a particular Orthopedics Clinic.

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

(E) A combination of A be and C

ANSWER: B

Question #031 (2 pts)

With respect to the Figure shown in Question 030 above and based on the materials covered in the course.

If the attribute Effective-Begin-Date is defined as:

The chronological datum in a calendar when a MEDICAL-FACILITY-ASSOCIATION begins

And if the attribute Effective-End-Date is defined as:

The chronological datum in a calendar when a MEDICAL-FACILITY-ASSOCIATION stops

Which of the following statements is most accurate:

(A) The MEDICAL-FACILITY-ASSOCIATION could be used to capture only the beginning and end of the association between a hospital and any instance of MRI-FACILITY

(B) The MEDICAL-FACILITY-ASSOCIATION could be used to capture only the beginning and end of the association between a hospital and any instance of MRI-FACILITY or BLOOD-LAB-FACILITY

(C) The MEDICAL-FACILITY-ASSOCIATION could be used to capture only the beginning and end of the association between a hospital and any instance of the five subtypes of MEDICAL-FACILITY

(D) The MEDICAL-FACILITY-ASSOCIATION could be used to capture only the beginning and end of the association between a hospital and any person working in a MEDICAL-FACILITY

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

ANSWER: C

Question #032 (2 pts)

With respect to the Figure shown in Question 030 above and based on the materials covered in the course:

Which of the following statements is most accurate:

(A) One of the attributes of Medical-Facility is Facility-Address

(B) It is possible to assign a Street-Name, Street-Number, City, State and ZIP Code to instances of Hospital-Facility

(D) It is possible to assign a Street-Name, Street-Number, City, State and ZIP Code to instances of personnel working at a hospital

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

ANSWER: E

Question #033 (2 pts)

With respect to the Figure shown in Question 030 above, assume that the attribute State in the entity Facility-Address is documented as follows.

Entity Attribute Name

State

Entity Attribute Definition

The code that represents one of the 50 political subdivisions of the United States of America, the District of Columbia, the Commonwealth of Puerto Rico, the Virgin Islands, Guam, American Samoa, or any other territory or possession of the United States

Entity Attribute Metadata

Logical Data Type: String

Constraints: Enumeration:(AL, AK, AS, AZ, AR, CA, CO, CT, DE, DC, FM, FL, GA, GU, HI, ID, IL, IN, IA, KS, KY, LA, ME, MH, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, MP, OH, OK, OR, PW, PA, PR, RI, SC, SD, TN, TX, UT, VT, VI, VA, WA, WV, WI, WY)

Using the table below:

FACILITY-ADDRESS

Address-Type-Code	Street-Number	Street-Name	State	ZIP-Code
MFAT01	123	Elm Drive	VA	22311
MFAT11	444	Oak Road	ZU	34554

Which of the following statements is most accurate:

(A) The record containing the entry for State = ZU is valid because enumerations are only precatory and one can always extend them anyways

(B) The record containing the entry for State = ZU is valid because one must always assume that enumerations are incomplete and only the user can decide what is needed

(C) The record containing the entry for State = ZU would be valid even if the enumeration were not modified to contain that value

(D) The record containing the entry for State = ZU would be valid if the enumeration were modified to contain that value

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

ANSWER: D

Question #034 (2 pts)

Assume that the table below corresponds to the entity Medical-Facility as specified in the information model depicted in Question 030 above.

MEDICAL-FACILITY
Name	Category-Code
Northern Chelsea IntroX	MF01
Devonshire Med Center	MF02
Sanguine Labs of New Jersey	MF03

Which of the following statements is most accurate:

(A) The record for the instance of Medical-Facility named Northern Chelsea IntroX is definitely an MRI-Facility because the name clearly says so (it has a capital X and everybody knows that X stands for X-Rays in medical lingo).

(B) The record for the instance of Medical-Facility named Northern Chelsea IntroX may be an MRI-Facility if the Category-Code value "MF01" is set equal to "MRI-Facility".

(C) The record for the instance of Medical-Facility named Northern Chelsea IntroX may be an MRI-Facility if either the Category-Code value "MF01" is set equal to "Blood-Lab-Facility" or the value "MF02" is set equal to "MRI-Facility".

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

(E) All of the above

ANSWER: B

Question #035 (2 pts)

Assume that the attribute Category-Code in the entity Medical-Facility (See information model depicted in Question 030) is specified as follows.

Entity Attribute Name

Category-Code

Entity Attribute Definition

An alpha-numeric string that indicates the kind of MEDICAL-FACILITY

Entity Attribute Metadata

Logical Data Type: String

Constraints: Enumeration:(Hospital-Facility, MRI-Facility, Orthopedics-Facility, Orthodontics-Facility, Blood-Lab-Facility)

Which of the following statements is most accurate.

An instance of Medical-Facility named "XanadoX Center" could be typed as an "X-Ray-Facility" if

(A) the appropriate value in the enumeration is added

(B) one uses the enumeration value "MRI-Facility" because they are both radiological centers

(D) if the value is set to NOS (Not-otherwise-specified) or UKN (Unknown)

(E) A combination of B and D but not A

ANSWER: A

Chapter 5: Relationships and Primary Keys

ER Models are useful because they:
1. Allow us to create efficient databases that are not full of logically missing data or require repetition of data in each record.
2. Allow us to draw relationships between persistent data.
3. Allow programmers to bypass database development using SQL code.
4. A&B
5. A only.

Correct Answer: d

Which of the following could be an entity in a clinical database:
1. Physician
2. Patient
3. Department
4. A only
5. All of the above

Correct Answer: e

Primary keys are:
1. Not required to be unique.
2. All facts in the table are about the primary key.
3. Are always required to be combination of at least two fields.
4. All of the above
5. None of the above

Correct Answer: b

Which of the following is correct:
1. Attributes are characteristics of entities
2. Once you have a primary key, all other attributes are useless.
3. An entity can have many attributes with same name.
4. All of the above.

Correct Answer: a

Which of the following is not correct:
1. Foreign keys conflict with Primary Keys
2. Foreign keys are needed in a relationship to enforce referential integrity.
3. Foreign keys are always the same data type as their corresponding Primary Keys.
4. Foreign keys can be used in one table to look up data from another table.

Correct Answer: a

An advantage of using ‘Referential Integrity’ is that:
1. One can avoid mismatched data
2. Your database will not have ‘orphan’ records, in other words children without parents.
3. Making a change in one table will prevent changes in corresponding tables.
4. A&B
5. All of the above

Correct Answer: d

Which one of the following would be the best solution to use if you had “Many to Many” relationships?
1. Numerical fields
2. Data fields
3. Primary Keys
4. Junction Tables
5. Table Joins

Correct Answer: d

In which table would a person find primary keys from more than one table?
1. Sub Table
2. Super Table
3. Junction Table
4. Foreign Table
5. Primary Table

Correct Answer: c

In Microsoft Access, a field is equivalent to ________ in our ER model.
1. Name
2. Table
3. Attribute
4. Keys
5. None of the above

Correct Answer: c

Chapter 6: Entities and Attributes

Which one of the following would not be an acceptable value if the data type of our field is “Auto-Number.”
1. 100
2. 02
3. 5A9
4. 5
5. None of the above

Correct Answer: c

Can we have an attribute other than primary key from Patient table in the Visit table? (Choose one correct response)

a. No, Patient attributes can only be in the Patient table.

b. Yes, if foreign keys and correct relationship exist.

c. Yes, but only if the patient is being seen by the same doctor every time.

d. Yes, because patients have only one doctor.

e. No because sometimes Patient visit is incomplete.

Correct Answer: a

Which of the following values would not be rejected by MS Access in a text field with maximum value of 2?

a. V A

b. MD

c. Mrs.

d. C&B

e. 121

In MS Access, which one of the following is not an acceptable field name?

a. DateOfAdmission

b. First_Name

c. Phone

d. Zip Code

e. None of the above

Correct Answer: d

If you select an auto-number for the primary key:

a. There will be no duplicates in primary key

b. The primary key cannot be related to a non-numeric entity such as name of a person

c. A different field that contains the meaning of the the numbers must accompany the table

d. All of the above

e. B&C

Correct Answer: a

One of the purposes of creating relationships between tables is to:

a. Allow families of records to have the same last name.

b. Find the meaning of a numeric primary key.

c. Trace information pertaining to one record from one table to another.

d. Allow two tables to have the same facts.

e. All of the above

Correct Answer: c

MS Access allows us to create joins between tables where:

a. The value of the field is present in both tables.

b. The field has a value in one table and a corresponding ‘null’ in the other table.

c. Only a

d. Only b

e. Both A&B

Correct Answer: e

Chapter 7: Normalization of Databases

Good database design requires:

a. Present data in the sequence collected so that it is convenient to use it.

b. Non-key fields should be facts about the foreign key.

c. Primary key should uniquely identify the individual occurrences of the entity or relationship

d. A&B

e. None of the above.

Correct answer: c

When a table is in First Normal Form, (1NF):

a. Fields consist of atomic data

b. Fields are repeated in a row.

c. A&B

d. Both A&B

e. None of the above

Correct Answer: a

If knowing Physician Name is enough for knowing Physician ID, then which one of the following statements is true:
1. Physician Name is functionally dependent on Physician ID
2. Both are functionally independent of each other
3. Physician ID is functionally dependent on Physician Name
4. Physician ID is the primary key
5. A&D

Correct Answer: c

If the field, ‘Employee_Name’ is fully functionally dependent on the field ‘Employee_Number’ then which one of the following statements is not correct:
1. Given an employee name we can find the employee number
2. Given an employee number we can find the employee name
3. A only
4. A&B
5. Neither A or B is correct.

Correct Answer: b

When we talk about tables in Second Normal Form, we can say that:
1. A foreign key is always the same as the primary key.
2. The primary key is the minimum subset necessary to determine each fact in the table.
3. The last two fields will always depend on the concatenated primary key.
4. B&C
5. All of the above.

Correct Answer: b

Which of the following are good rules of design for normalization:
1. Each table should refer to multiple entities
2. Composite or repeating fields should always be used.
3. The primary key should uniquely identify the entity.
4. A&B
5. All of the above

Correct Answer: c

A good database designer might not put the field ‘Visit_Date’ in the Patient table because:
1. Date fields are never put in a Patient table.
2. The field Visit_Date might not depend on the primary key of the Patient table.
3. The field Visit_Date will expire after 7 days, leaving orphan data in the database.
4. C only
5. A&B only

Correct Answer: b

Chapter 8: Queries

Query commands are written in which of the following languages:
1. SQL
2. C&*
3. Oracle
4. MS Access
5. All of the above

Correct Answer: a

Queries are helpful in the following ways:
1. They help us to quickly retrieve specific information from databases of any size and across many tables.
2. They allow us to bypass normalization rules.
3. B only
4. They allow us to update, append and delete data.
5. A&D

Correct Answer: e

Queries can be used to extract data about the following:
1. People
2. Places
3. Tables
4. Fields
5. All of the above

Correct Answer: e

Querying a join relationship is advantageous because:
1. SQL does not have a feature to query join relationships.
2. This type of query can provide data about related fields in more than one table.
3. Dependency between primary keys is broken.
4. We can examine parents of a table.
5. None of the above.

Correct answer: b

Which type of query would be best for adding new data to an existing list?
1. Select
2. Delete
3. Append
4. Make
5. Crosstab

Correct Answer: c

In a relational database containing a table about the alumni of the University, which of the following types of query would allow you to view the records for alumni of Health System Management program:
1. Crosstab
2. Select
3. Append
4. Update
5. None of the above

Correct Answer: b

We want to query our database to display only those records where a patient is assigned a physician. Which of the following joins would allow us to do this?
1. One-to-Many
2. One-to-One
3. Many-to-One
4. Twice-as-Many
5. A&D

Correct Answer: b

The following tactic could be used to limit our search results to dates that occur only the year 2005.
1. Providing a filter criterion in our query.
2. Deleting all records in our database that occur in the year 2001.
3. Removing all foreign key references.
4. A&B
5. None of the above.

Correct answer a

Chapter 9: More from Queries

In following figure, which of the following statements is correct:

a) The ID field is an auto-number and therefore the same number in the three tables
b) Patient’s name should be also in the Encounter table
c) In this query, it is not possible to find out the patients of a provider
d) The ID fields in the three table should be joined together so that each record is appropriately selected
e) None of the above

Correct answer e

In the above figure, which of the following is correct:
a) In this query , there may be many providers for the same patient in this query
b) In this query, every provider must have only one patient
c) In this query, every patient must have only one provider
d) In this query, a provider may have no visits but still be available in the query
e) In this query, a patient may have no visits but still be available in the query

Correct answer a

In the above figure, which of the following is correct?

a) Diagnosis is a fact about the patient and should be in the patient table
b) Telephone field is repeated and therefore in error
c) Date field is not needed in the encounter table
d) City could be fully functionally dependent on zip code and therefore can be removed from Patient table
e) None of the above

Correct answer: d

In the above figure in the table Encounter, which of the following is not true:
a) PatientID is the primary key
b) PatientID is foreign key
c) ProviderID is foreign key
d) Diagnosis is a fact
e) Date is not text

Correct answer a

In the above figure, which of the following is correct?
a) The number of records in the encounter table can exceed the number of records in the patient table
b) Providers must be fewer than patients
c) The number of encounters cannot exceed the number of patients times the number of providers
d) None of the above
e) All of the above

Correct answer a

When a patient is admitted to a hospital, typically a primary diagnosis and 5 other diagnoses are kept about the visit. This information was collected in a table with following fields: Hospitalization ID (primary key), Patient ID, Date of admission, Primary diagnosis, First co-morbidity Diagnosis, Second co-morbidity Diagnosis, Third co-morbidity Diagnosis, Fourth co-morbidity Diagnosis, Fifth co-morbidity Diagnosis. Which of the following statements is incorrect?
1. The table is in Normal form.
2. A single record is used to list all co-morbidities.
3. A patient can have more than one hospitalization
4. All of the above
5. None of the above

Correct answer a

A database designer has organized a database with three tables: Patient contact information, Provider's information and Visits. All three tables have the Patient Medical Record number as their primary key. In this manner, it is clear what the medical record number was for a visit, which providers worked on the medial record number and which patient was involved. Is this design reasonable?
a) Yes
b) No the tables should be combined as they are all about the same entity
c) No mental health is functionally dependent on physical health
d) Yes as long as the clinic has both mental and physical health visits
e) No, the primary key in each table should uniquely define the records in that table

Correct response: e