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,
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
