Computer science – database assignment
CH 11: OBJECT and OBJECT-RELATIONAL DATABASES
#11.25 – Convert the example of GEOMETRY_OBJECTS given in section 11.1.5 from the functional notation to the notation given in Figure 11.2 that distinguishes between attributes and operations. Use the keyword INHERIT to show that one class inherits from another class.
#11.27 – Consider the UNIVERSITY EER schema of Figure 8.10. Think of what operations are needed for the entity types/classes in the schema. Do not consider constructor and destructor operations.
#11.31 – Map the COMPANY ER schema of Figure 7.2 into ODL classes. Include appropriate methods for each class.
CH 12: XML – EXTENSIBLE MARKUP LANGUAGE
#12.9 – Consider the LIBRARY relational database schema in Figure 4.6. Create an XML schema document that corresponds to this database schema.
CH13: INTRODUCTION TO SQL PROGRAMMING TECHNIQUES
#13.9 – Consider the LIBRARY relational database schema in Figure 4.6. Write a program segment that retrieves the list of books that became overdue yesterday and that prints the book title and borrower name for each. Use embedded SQL and C or any programming language of your choice or even a pseudo-code.