W1-MovieDB.pdf - Course Distributed Database Assignment I Due Date Objective Understand Oracle centralized database Define user defined type \u2013 UDT

W1-MovieDB.pdf - Course Distributed Database Assignment I...

This preview shows page 1 - 3 out of 3 pages.

1 | P a g e Course: Distributed Database Assignment I Due Date: June 10, 2019 Objective: - Understand Oracle centralized database - Define user defined type UDT - Working on nested relation - Creating a Table - Create views and functions Notice: please follow the following steps in preparing the deliverable 1. write a SQL statement, copy and paste it in Word file named after you, 2. execute it, take the snapshot of the result of executing it and paste it the same word file 1. Based on the class diagram shown below, perform the activities listed below - Create all UDT, - Create relevant tables (makes sure that the name of a table is plural or collection) - Populate data into the Movies Table,
Image of page 1
2 | P a g e - Define the functions in the MovieUDT to return movies based on the parameter passed - Create view named vwmovieDirectors having title, fname, lname as attributes
Image of page 2