Practice Questions for Midterm Exam - Database Management Systems | MIS 310, Exams of Introduction to Database Management Systems

Download Practice Questions for Midterm Exam - Database Management Systems | MIS 310 and more Exams Introduction to Database Management Systems in PDF only on Docsity! Sample Midterm Part I. True / False (5 points – 1 pt each) Expected Time: 5 minutes. ______ 1. Unary relationships can have many-to-many connectivity. ______ 2. The value of a primary key can be null. ______ 3. The value of a foreign key can be null. ______ 4. A strong entity type is one that exists independently of other entity types. ______5. A derived attribute is an attribute whose value can be calculated from related attribute values. Part II. Multiple Choice (10 points – 2 points each) Expected Time: 5 Minutes. ______ 6. Which of the following is NOT a type of anomaly created by data redundancy? a. modification anomaly b. insertion anomaly c. junction anomaly d. deletion anomaly ______ 7. Each column has a specific range of values known as the _______ ? a. mountain range b. column range c. permissible domain d. attribute domain ______ 8. The real power behind the relational database, allowing the use of independent tables linked by a common attribute, is: a. SELECT b. PROJECT c. JOIN d. INTERSECT ______ 9. Problems inherent in the many-to-many relationship in a relational environment can best be avoided by: a. using the hierarchical model b. placing all entities in one table c. resolving the M:N relationship into two 1:M relationships d. enforcing referential integrity rules Sample Midterm ______ 10. A recursive relationship is a(n) __________ relationship. a. unary b. binary c. ternary d. plenary Part III. E-R Diagram (20 points) Expected Time: 20 Minutes. Consider the following situation for Tiny College: A student may take between one and six classes a semester. In order to be offered, each class must have at least 10 students enrolled. The maximum number of students in each course is 45. There may be many classes offered for a particular course, and in some semesters no classes are offered due to low enrollment. Tiny College encourages multi-disciplinary course offerings, and in some cases, more than one department may run courses. Classes at Tiny College can be team-taught by up to three different professors, or may be taught in the traditional manner with only one professor teaching a class. Professors may be on a sabbatical leave, and teach no courses in a particular semester. Create the E-R Diagram that describes the situation at Tiny College. Make sure to indicate connectivity, cardinality and participation. Please label the relationships. State clearly any assumptions that you make. The assumptions must not contradict the material already presented. Be sure to resolve any M:N relationships that may exist. You may want to practice first on scratch paper. Sample Midterm Part VI. Interpreting E-R Diagrams (10 points) Expected Time: 10 Minutes Consider the following ERD: (a) Express the relationship “Prescribes” in words. Be sure to capture all aspects (i.e. connectivity, cardinality and participation) of the relationship in your description. (b) Express the relationship “Takes” in words. Be sure to capture all aspects (i.e. connectivity, cardinality and participation) of the relationship in your description. MEDICAL SPECIALTY DOCTOR Has prescribes DRUG PATIENT Takes 1 N N M N M(0,1) (1,N) (1,N) (0,N) (0,N) (0,N) Interacts with N M (1,N) (1,N) Sample Midterm Part VII. Even More E-R Diagrams (20 points) Expected Time: 20 Minutes Given the following information regarding a hospital, create an ER diagram. Make sure to indicate connectivity, cardinality, and participation. Please label the relationships. State clearly any assumptions that you make. The assumptions must not contradict the material already presented. For this problem, you DO NOT need to resolve and M:N relationships. 1. A facility maintains a number of laboratory (ies) (Radiology, electrodiagnosis, hematology, etc.) 2. A facility contains a numbers of wards (obstetrics, emergency, rehabilitation, geriatrics, etc) 3. Each ward is assigned a certain number of staff members (nurses, secretaries, etc.) and a staff member may be assigned to multiple wards. 4. A facility staffs a number of physicians on its medical staff. A physician may be on the staff of more than one facility. 5. A physician treats patients, and a patient is treated by any number of physicians. 6. A physician diagnoses patients, and a patient is diagnosed by any number of physicians. 7. A patient may be assigned to a ward. The hospital cares only about the current ward a patient is assigned to (if assigned at all) 8. A patient uses medical/surgical items, which are supplied by vendors. A vendor also provides supply items that are used for housekeeping and maintenance purposes. 9. A laboratory performs tests about patients.