VITEC Database Systems Engineer Examination (Afternoon, Part 2)

1. Examination Time-14:30-16:30 (120 minutes). 2. Questions must be answered in accordance with the following: Question Nos. Question Selection Q1-Q2 Select one of the two. | October 2005 VITEC Database Systems Engineer Examination Afternoon Part 2 1. Examination Time-14 30-16 30 120 minutes . 2. Questions must be answered in accordance with the following Question Nos. Q1-Q2 Question Selection Select one of the two. 3. Mark your examinee information and test answers in accordance with the instructions below. 1 In the space provided on the answer sheet write your examinee number. If this item is not marked correctly your test cannot be scored. 2 In the space provided on the answer sheet write your date of birth exactly as they are printed on your examination admission card. It this item is not marked correctly your test cannot be scored. 3 In the question selection column circle the number of the question you select to answer. If the question is not circled correctly your test cannot be scored. If you circle two numbers only the first question will be graded. 4 Write each answer in the space specified for that question. 5 Write your answers clearly and neatly. Answers that are difficult to read will receive a lower score. 4. After the test you may take this question booklet home with you. 5. Observe the rules for describing conceptual data models relation schemas and relational database tables provided at the beginning of the booklet. Do not open the exam booklet until instructed to do so. Inquiries about the exam questions will not be answered. Company names and product names appearing in the test questions are trademarks or registered trademarks of their respective companies. Note that the and symbols are not used within. Notation Used in the Questions The notation for conceptual data models relation schemas and relational database table structures is given below. This notation applies unless otherwise noted in the text of a question. 1. Notation for Conceptual Data Models Fig. 1 Notation for Entity Types and Relationships 1 Entity types are indicated using rectangles. 2 The entity type name is written inside the rectangle. 3 The .