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