Exam_07 - StudentId EXAMINATIONS 2007 END-YEAR COMP 442...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
StudentId_______________ COMP442 continued… EXAMINATIONS 2007 END-YEAR COMP 442 ISSUES IN DATABASE AND INFORMATION SYSTEMS Time Allowed: 3 Hours (180 minutes) Instructions: Attempt all questions. There are 180 possible marks on the exam. Make sure your answers are clear and to the point. Non-programmable calculators without full alphabetic keys are permitted. Non-electronic foreign language dictionaries are permitted. Refer to the Appendix. No other reference material is allowed. Answer in the appropriate heavily outlined boxes or follow the instructions given in the questions. Question Topic Marks PART 1 XML Databases 1 XML Basics [36 marks] 2 Converting an XML Schema into a DTD [10 marks] 3 Identity Constraints [20 marks] 4 XQuery [25 marks] 5 XML Functional Dependencies [9 marks] 6 XML Normal Form [20 marks] PART 2 Data Warehousing 7 OLAP and Data Warehouse Basics [10 marks] 8 Query Rewriting [20 marks] 9 Advanced OLAP Query Commands [20 marks] 10 OLAP and Data Warehouse Architectures [10 marks]
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
StudentID____________________ COMP442 continued 2 PART 1 XML Databases Question 1. XML Basics [36 marks] a) [13.5 marks] Define nine rules that a well formed XML document has to obey. ANSWER 1. 2. 3. 4. 5. 6. 7. 8. 9.
Background image of page 2
StudentID____________________ COMP442 continued 3 b) [7.5 marks] List the six basic concepts used to build an XML document? ANSWER 1. 2. 3. 4. 5. 6. c) [3 marks] What are DTD and XML Schema used for? ANSWER d) [3 marks] When is an XML document said to be valid? ANSWER
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
StudentID____________________ COMP442 continued 4 e) [9 marks] The syntax of XML Schema identity constraints is given in the Appendix. I. [3 marks] Define the term “context” of an identity constraint and briefly explain its role in the evaluation of an identity constraint. ANSWER II. [3 marks] Define the term “scope” of an identity constraint and briefly explain its role in the evaluation of an identity constraint. ANSWER III. [3 marks] Which XML concept can be at the end of a field xpath attribute? Discuss the two restrictions on this concept in your answer. ANSWER
Background image of page 4
StudentID____________________ COMP442 continued 5 Question 2. Converting an XML Schema into a DTD [10 marks] There is an XML Schema Bank_Roberies.xsd given in the Appendix. Convert the XML Schema given into a DTD, with the smallest possible loss of information. ANSWER
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
StudentID____________________ COMP442 continued 6 Question 3. Identity Constraints [20 marks] In this question, you will need to define identity constraints of the type key/keyref/unique for the XML schema Bank_Robberies.xsd , given in the Appendix. In your answer, clearly designate the context element of each identity constraint followed by the full syntax of the constraint, only. You may find the syntax of an identity constraint in the Appendix. Also note, there is an instance document of the XML schema
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/05/2011 for the course FIN 350 taught by Professor Debruinne during the Winter '11 term at Grand Valley State.

Page1 / 25

Exam_07 - StudentId EXAMINATIONS 2007 END-YEAR COMP 442...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online