CET315 Portfolio Exercise 3.pdf - CET315 Advanced Databases Portfolio Exercise 3 Object-Relational Databases This is an individual portfolio exercise

CET315 Portfolio Exercise 3.pdf - CET315 Advanced Databases...

This preview shows page 1 - 2 out of 5 pages.

CET315 Advanced Databases - Portfolio Exercise 3 Object-Relational Databases This is an individual portfolio exercise. During previous tutorials on object-relational databases you have developed part of an object-relational database based on a hospital case study. If you had not previously completed this tutorial then it is strongly recommended that you do so before attempting this portfolio element. This portfolio exercise is based on a sailing club competition database and the UML class diagram for this case study is given on the final page of this document. Using either Oracle APEX or SQL Developer, your tasks for this portfolio element are to: 1. Create an Oracle 11g type that will implement the AddressType type, ensuring that you write the get_address() method which will print an address as house number and street name, town, postcode and country, separated by commas and spaces, e.g. ‘12 Winstone Avenue, Durham, SR2 1AB, UK’. 2. Create an Oracle 11g type that will implement the SailingClubType type. To do this you will need to investigate use of the object-relational feature of VARRAYs to store a list of telephone numbers for the sailing club. There is no need to define or implement the get_tel_num method at this point. 3. Create an Oracle 11g type that will implement the SailorType type. To do this will require you to investigate use of the object-relational REF construct (for defining object-references between tables) for relating sailors to sailing clubs. 4. Subsequently create a SailingClub table which will store sailing club details, and insert some (i.e. at least three) sample rows of data into this table, ensuring that each sailing club has multiple (i.e. two or three) telephone numbers.
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read all 5 pages?

  • Spring '19
  • Jan Smith
  • PostgreSQL, Telephone number, Database management system, Sailor

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture