©2002 EF Nis
Tempus Project CD_JEP-16160-2001
» Home
» What's New


Project Overview
» Background
»Project Description
» Management Team
» Consortium
» Logical Framework Matrix
» E-Mail

The Project
» Events
» Workgroup Activities
» Reform at FEEN
» Equipment
» Textbooks and Manuals
» Student mobility

Links
» Tempus Home
» Tempus Documents
» Consortium


Last update:

October 6, 2005

Project's Life
Textbooks and manuals supported by the CD_JEP-16160-2001
 
 

 

Lab Manual for Databases Course Using Oracle

Slobodanka J. Ðordevic-Kajan,
Leonid V. Stoimenov

   
   
Authors Slobodanka J. Ðordevic-Kajan, Leonid V. Stoimenov
Title Lab Manual for Databases Course Using Oracle
Publisher Faculty of Electronic Engineering, Nis
Year 2004
ISBN 86-80135-91-7
COBISS-ID 115971340
Reviewers Prof. dr Živko Tošic, Prof. dr Milena Stankovic, University of Niš
Pages 130
Illustrations  
Language Serbian
Type Text-Book
Categorization Computer Science/Exercises
Abstract This book contains basic information for students about databases, database modeling, and querying databases using Oracle DBMS and Oracle SQL. The book is devoted primarily to students of the Faculty of Electronic Engineering in Niš, where the complete course of "Databases" (in eighth semester for the Computer Science and Informatics major) is covered. The book, also, covers all standard courses from the database field at other computer science and informatics faculties.
   
From the review

This publication is written in Serbian and it contains basic information for students about databases, database modeling, and querying databases using Oracle DBMS and Oracle SQL. The book is devoted primarily to students of the Faculty of Electronic Engineering in Nis, where the complete course of "Databases" (in eighth semester for the Computer Science and Informatics major) is covered. The book, also, covers all standard courses from the database field at other computer science and informatics faculties.

The manuscript of this book is divided into 5 chapters followed by 5 appendices and section wit references. The first chapter has an introductory character and gives a short review of the data models and development of databases. In other chapters the following problems are treated: database schema development, conceptual models (EER) and mapping to implementation models (relational data model), and solutions of developed database schemas (Chapter 2); general properties of Oracle DBMS, Oracle objects and SQL*Plus commands, and introductory to SQL query language (Chapter 3); SQL data types, relational operators, aggregation functions, and SQL statements for views and indexes (Chapter 4); principles of embedded SQL and Oracle Pro*C/C++ environment for embedded SQL (Chapter 5). Appendices contains 5 parts: syntax of SQL SELECT statement; Oracle catalog and Oracle data dictionary; Oracle Date and Time data type; List of Embedded SQL Statements Supported by Pro*C; and data in SQLCA structure.

This publication can be used for supplementary readings in basic courses in the area, since represents a brief review of practical, essential and fundamental concepts. Our recommendation is that this book is useful as manual for lab exercises, but also as an introductory book of database principles using Oracle DBMS in a Databases course.

 

 

         

About This Site | Search | E-mail

Site contents ©2002-2003 Faculty of Electronic Engineering of Nis
Please send comments and suggestions about this site to Webmaster