XML and Databases Exercise Session 3 courtesy of
- Slides: 42
XML and Databases Exercise Session 3 (courtesy of Ghislain Fourny/ETH)
Good to know: XML Schema types § Simple type - predefined or user-defined - element or attribute type § Complex type - user-defined - element type only Empty content § Simple content § Complex content § Mixed content § Department of Computer Science 2
Good to know: XML Schema types § Types (can) have QNames: § § All predefined types User-defined types (here simple) Department of Computer Science Tags, attributes. . . XML Schema looks like XML. . . that's because it is XML! 3
Good to know: XML Schema types § They can also be anonymous. Anonymous types can be defined under any xs: element or xs: attribute. Nonanonymous types have a global scope and must be defined directly under xs: schema. Department of Computer Science 4
Complex types in XML Schema § Complex type, complex content Department of Computer Science 5
Complex types in XML Schema § Simple content (here anonymous) Department of Computer Science 6
Complex types in XML Schema § Empty content Simple content restricted to "" § Or a complex content without any children § § Mixed content § As in complex content, with an additional attribute mixed set to true in xs: complex. Type Department of Computer Science 7
Exercises 1 -3 § Passenger § Flight § Airport § Booking Department of Computer Science 8
Exercises 1 -3 § Passenger: name, address, passport number § Flight: ID, number of seats, date, origin, dest § Airport: name, code, tax value § Booking: credit card, flight, passenger Department of Computer Science 9
Exercise 1: XML Data § Sample data Department of Computer Science 10
Exercise 1: XML Data § How to prevent this? Department of Computer Science 11
Exercise 1: XML Data § How to prevent this? § With a DTD/Schema! Department of Computer Science 12
Exercise 2: XML Schema Modelling Department of Computer Science 13
Exercise 2: XML Schema Modelling Passenger Passport number name Department of Computer Science address 14
Exercise 2: XML Schema Modelling code name tax Airport Passenger Passport number name Department of Computer Science address 15
Exercise 2: XML Schema Modelling code name tax flight. ID seat. No date Flight Airport Passenger Passport number name Department of Computer Science address 16
Exercise 2: XML Schema Modelling code name flight. ID tax seat. No date source Flight Airport dest Passenger Passport number name Department of Computer Science address 17
Exercise 2: XML Schema Modelling code name flight. ID tax seat. No date source Flight Airport dest book credit card Passenger Passport number name Department of Computer Science address 18
Exercise 2: XML Schema Modelling code name flight. ID tax 1 source seat. No date N Flight Airport 1 dest N M book credit card N Passenger Passport number name Department of Computer Science address 19
Exercise 2: What‘s wrong? Department of Computer Science 20
Exercise 2: Inconsistency Department of Computer Science 21
Exercise 2: Inconsistency Department of Computer Science 22
Exercise 2: Redundancy Department of Computer Science 23
Exercise 2: Redundancy Department of Computer Science 24
Exercise 2: Extraneous data Department of Computer Science 25
Exercise 2: A Schema for Passenger Passport number name Department of Computer Science address 26
Exercise 2: A Schema for Passenger Passport number name Department of Computer Science address 27
Exercise 2: A Schema for Flight flight. ID seat. No date source Flight Airport dest Department of Computer Science 28
Exercise 2: A Schema for Flight flight. ID seat. No date source Flight Airport dest Department of Computer Science 29
Exercise 2: A Schema for Flight flight. ID seat. No date source Flight Airport dest Department of Computer Science 30
Exercise 2: A Schema for Flight flight. ID seat. No date source Flight Airport dest Department of Computer Science 31
Exercise 2: A Schema for Airport code name tax Airport Department of Computer Science 32
Exercise 2: A Schema for Airport code name tax Airport Department of Computer Science 33
Exercise 2: A Schema for Airport code name tax Airport Department of Computer Science 34
Exercise 2: Root Element Department of Computer Science 35
Exercise 3: DTD and XML Schema Department of Computer Science 36
Exercise 3: Corresponding XML Schema Department of Computer Science 37
Exercise 4: Corresponding XML Schema Department of Computer Science 38
Exercise 3: Corresponding XML Schema Department of Computer Science 39
Exercise 3: Corresponding XML Schema Department of Computer Science 40
Exercise 3: Corresponding XML Schema Department of Computer Science 41
Hope to see you next week! Department of Computer Science 42
