Database Assignment
University of Greenwich Database assignment2
Iago Castro Cuna
Student ID: 000628811 Course ID : COMP1450
DATABASE ASSIGNMENT2 Iago Castro Cuna
Table of Contents
1 INTRODUCTION ..................................................................................................................... 4
2 CREATING THE DATABASE TABLES ....................................................................................... 5 2.1 Creating the company ......................................................................................... 5 2.2 Creating the table site ........................................................................................ 6 2.3 Creating the table subject_area .......................................................................... 7 2.4 Creating the table instructor ............................................................................... 8 2.5 Creating the table student ................................................................................ 10 2.6 Creating the table invoice ................................................................................. 11 2.7 Creating the table course .................................................................................. 12 2.8 Creating the table authorization ....................................................................... 13 2.9 Creating the table offering ................................................................................ 15 2.10 Creating the table attendance......................................................................... 16 2.11 Assumptions and clarifications about the table creation ............................... 17 2.12 Reviewing the structure of the tables in oracle .............................................. 18
3 POPULATING THE DATABASE TABLES ................................................................................ 21 3.1 Populating the table company
Iago Castro Cuna
Student ID: 000628811 Course ID : COMP1450
DATABASE ASSIGNMENT2 Iago Castro Cuna
Table of Contents
1 INTRODUCTION ..................................................................................................................... 4
2 CREATING THE DATABASE TABLES ....................................................................................... 5 2.1 Creating the company ......................................................................................... 5 2.2 Creating the table site ........................................................................................ 6 2.3 Creating the table subject_area .......................................................................... 7 2.4 Creating the table instructor ............................................................................... 8 2.5 Creating the table student ................................................................................ 10 2.6 Creating the table invoice ................................................................................. 11 2.7 Creating the table course .................................................................................. 12 2.8 Creating the table authorization ....................................................................... 13 2.9 Creating the table offering ................................................................................ 15 2.10 Creating the table attendance......................................................................... 16 2.11 Assumptions and clarifications about the table creation ............................... 17 2.12 Reviewing the structure of the tables in oracle .............................................. 18
3 POPULATING THE DATABASE TABLES ................................................................................ 21 3.1 Populating the table company