ADD - Designing of an Oracle 10g database solution for...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Designing of an Oracle 10g database solution for International Production Company This document focuses on the design and use of Oracle 10g database technologies to fulfill the functional requirements of the International Production Company. The document is the result of a collective effort from all members of our group Course Lecturer Mr. Chandranna Rayadurg Course Bsc in Computing (Semester 5) Group members Sasika Perera - S0586KDKD1110 Tajudeen Olajide Sanni-S0450ALAL0410 Mohamed Fazan Fuard - S0403KDKD1110 Momar Seneba Ndiaye - 0072GGGG0408 2011 ADVANCED DATABASE DEVELOPMENT Bsc. Computing Bsc. Computing (Semester 5) ADVANCED DATABASE DEVELOPMENT Page: 2 Table of Contents Acknowledgement ........................................................................................................................................ 4 1. Introduction .......................................................................................................................................... 5 1.1 Aim of this project ............................................................................................................................... 5 1.2 Objectives ............................................................................................................................................ 5 1.3 Assumptions made in this project ...................................................................................................... 5 2. Entity Relationship diagram .................................................................................................................. 6 3. Tables of the database .......................................................................................................................... 7 3.1 CREATE and INSERT Statements of the tables .................................................................................. 11 3.1.1. BATCH Table ........................................................................................................................ 11 3.1.2. CUSTOMER Table ................................................................................................................ 12 3.1.3. DEPARTMENT Table ............................................................................................................ 13 3.1.4. DESIGNATION Table ............................................................................................................ 13 3.1.5. EMPLOYEE Table ................................................................................................................. 14 3.1.6. EMPLOYEE SKILLS Table ...................................................................................................... 15 3.1.7. FINISH TYPE Table ............................................................................................................... 15 3.1.8. ORDER DETAIL Table ........................................................................................................... 16 3.1.9. 3....
View Full Document

Page1 / 47

ADD - Designing of an Oracle 10g database solution for...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online