CS585 Final Spring 2009 solution

CS585 Final Spring 2009 solution - CS585 Database Systems...

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

View Full Document Right Arrow Icon
CS585 Database Systems Spring 2009 Final Exam Name: _____________________ Student ID: _________________ Maximum Received Problem 1 20 Problem 2 15 Problem 3 10 Problem 4 20 Problem 5 15 Problem 6 20 Total 100
Background image of page 1

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

View Full DocumentRight Arrow Icon
Problem 1 (20 points) Briefly answer the following questions: a) 4pts Define a view and a table in DBMS. And specify the similarity and the difference between a view and a table. - view - a stored query accessible as a virtual table composed of the result set of a query. A view does not form part of the physical schema - table – a part of physical schema b) 4pts Explain the difference between data mining and decision support using OLAP. OLAP -> higher level views of business data, info representation DM -> meaningful patterns and rules c) 4 pts Name 2 properties that are not common between XML elements and XML attributes. - Element names are not unique – can have 2 price elements for a product element - Elements can be nested
Background image of page 2
d) 4 pts Can you write an automated tool to convert a DTD document into an XML schema without losing information? Can you do this in the reverse order? Explain your answers. - can do DTD to XML schema easily. The data types in DTD are a small subset of the data types in XML schema. No information is lost. - Cannot do this in reverse. A lot of information on data types will be lost e) 4 pts Explain a declaration and a definition in XML schema. You declare elements and attributes. Schema components that are declared are those that have a representation in an XML instance document. You define components that are used just within the schema document(s). Schema components that are defined are those that have no representation in an XML instance document. Declarations: - element declarations - attribute declarations Definitions : - type (simple, complex) definitions - attribute group definitions - model group definitions
Background image of page 3

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

View Full DocumentRight Arrow Icon
Problem 2 (15 points) Given the XML documents “bstore1.com/bib.xml”, “bstore2.com/bib.xml”, “bstore1.com/reviews.xml”, and “bstore2.com/reviews.xml” with the following sample content: <bib> <book year="1994"> <title>TCP/IP Illustrated</title> <author><last>Stevens</last><first>W.</first></author> <publisher>Addison-Wesley</publisher> <price>65.95</price> </book> <book year="1992"> <title>Advanced Programming in the Unix environment</title> <author><last>Stevens</last><first>W.</first></author> <publisher>Addison-Wesley</publisher> <price>65.95</price> </book> <book year="2000"> <title>Data on the Web</title> <author><last>Abiteboul</last><first>Serge</first></author> <author><last>Buneman</last><first>Peter</first></author> <author><last>Suciu</last><first>Dan</first></author> <publisher>Morgan Kaufmann Publishers</publisher> <price>39.95</price> </book> <book year="1999"> <title>The Economics of Technology and Content for Digital TV</title> <editor> <last>Gerbarg</last><first>Darcy</first> <affiliation>CITI</affiliation> </editor> <publisher>Kluwer Academic Publishers</publisher>
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 12/01/2009.

Page1 / 18

CS585 Final Spring 2009 solution - CS585 Database Systems...

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

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