1.1 OUTSTANDING FEATURES OF THIS BOOK 1) This book covers both fundamental and advanced Java database programming techniques to help both beginning and experienced students as well as programmers. 2) A sample database, CSE _ DEPT, which represents an example computer science depart-ment and is built with Oracle 18c Express […]
Category: Keys and Relationships
Instructor Materials and Customer Support – Introduction
1.5.1 Instructor Materials and Customer Support All teaching materials for all chapters have been extracted and are represented by a sequence of Microsoft PowerPoint slide files, one file for one chapter. Interested instructors can find those teaching materials in the Teaching PPT folder located in the Instructors folder on the […]
A SAMPLE DATABASE – Introduction to Databases
2.3 A SAMPLE DATABASE We will use a sample database, CSE _ DEPT, to illustrate some essential database concepts. Tables 2.1~2.5 show sample data Tables stored in this database. FIGURE 2.1 Records and fields in a Table. The data in CSE _ DEPT database is stored in five Tables—LogIn, Faculty, […]
Foreign Keys and Referential Integrity – Introduction to Databases
2.4.3 Foreign Keys and Referential Integrity Foreign keys are used to create relationships between Tables. It is an attribute in one Table whose values are required to match those of primary key in another Table. Foreign keys are created to enforce referential integrity, which states that you may not add […]
ER NOTATION – Introduction to Databases
2.6 ER NOTATION There are a number of ER notations available, including Chen’s, Bachman, crow’s foot and a few others. There is no consensus on the symbols and the styles used to draw ERDs. A number of draw-ing tools are available to draw ERDs. These include ER Assistant, Microsoft Visio […]
DATABASE COMPONENTS IN SOME POPULAR DATABASES – Introduction to Databases
2.8 DATABASE COMPONENTS IN SOME POPULAR DATABASES All databases allow for storage, retrieval and management of the data. Simple databases provide basic services to accomplish these tasks. Many database providers, like Microsoft SQL Server and Oracle, provide additional services that necessitate storing many components in the database other than data. […]
Data Files – Introduction to Databases
2.8.2.1 Data Files A data file is a conglomeration of objects, which includes Tables, keys, views, stored procedures and others. All these objects are necessary for the efficient operation of the database. 2.8.2.2 Tables The data in a relational database resides in Tables. These are the building blocks of the […]
Transaction Log Files – Introduction to Databases
2.8.2.7 Transaction Log Files A transaction is a logical group of SQL statements that carry out a unit of work. Client server databases use log files to keep track of transactions that are applied to the database. For example, before an update is applied to a database, the database server […]
Stored Procedures – Introduction to Databases
2.8.3.4 Stored Procedures In Oracle, functions and procedures may be saved as stored program units. Multiple input argu-ments (parameters) may be passed as input to functions and procedures; however, functions return only one value as output, whereas procedures may return multiple values as output. The advantages to creating and using […]
Initialization Parameter Files – Introduction to Databases
2.8.3.5 Initialization Parameter Files The Oracle server must read the initialization parameter file before starting an Oracle database instance. There are two types of initialization parameter files: static parameter files and persistent parameter files. An initialization parameter file contains a list of instance parameters, the name of the database the […]