Database Assignment

Only available on StudyMode
  • Topic: SQL, Data Definition Language, Database
  • Pages : 20 (4313 words )
  • Download(s) : 68
  • Published : February 28, 2013
Open Document
Text Preview
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 .......................................................................... 21  3.2 Populating the table site ................................................................................... 22  3.3 Populating the table subject_area .................................................................... 22  3.4 Populating the table instructor ......................................................................... 23  3.5 Populating the table student............................................................................. 23  3.6 Populating the table invoice.............................................................................. 24  3.7 Populating the table course .............................................................................. 25  3.8 Populating the table authorization ................................................................... 25  3.9 Populating the table offering ............................................................................ 26  3.10 Populating the table attendance..................................................................... 26 2

DATABASE ASSIGNMENT2 Iago Castro Cuna

4 DATABASE QUERIES ............................................................................................................ 27  4.1 QUERY A ............................................................................................................. 27  4.2 QUERY B.............................................................................................................. 28  4.3 QUERY C .............................................................................................................. 28  4.4 QUERY D ............................................................................................................. 29  4.5 QUERY E .............................................................................................................. 30  4.6 QUERY F...
tracking img