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: Integrated Databases
HOW TO USE THE SOURCE CODE AND THE SAMPLE DATABASE – Introduction
1.5 HOW TO USE THE SOURCE CODE AND THE SAMPLE DATABASE All source code for each real class project developed in this book is available. All projects are cat-egorized into the associated chapters that are located in the folder Class DB Projects that is located in the Students folder on […]
DEVELOPING A DATABASE – Introduction to Databases
2.2 DEVELOPING A DATABASE The database development process may follow a classical systems development life cycle. 1) Problem Identification—Interview the user, identify user requirements. Perform preliminary analysis of user needs.2) Project Planning—Identify alternative approaches to solving the problem. Does the project need a database? If so, define the problem. Establish […]
IDENTIFYING KEYS – Introduction to Databases
2.4 IDENTIFYING KEYS 2.4.1 Primary Key and Entity Integrity An attribute that uniquely identifies one and only one instance of an entity is called a primary key. Sometimes a primary key consists of a combination of attributes. It is referred to as a composite key. The entity integrity rule states […]
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 […]
Third Normal Form (3NF) – Introduction to Databases
2.7.3 Third Normal Form (3NF) A Table is in third normal form (3NF) if it is already in 2NF and every non-key column is non-transitively dependent upon the primary key. In other words, all non-key columns are mutually independent, but at the same time, they are fully dependent upon the […]
Tables – Introduction to Databases
2.8.1.2 Tables Before you can create a Table in Access, you must create a database container and give it a name with the extension. mdb. Database creation is simple process and is explained in detail with an example later in this chapter. Suffice it to say that a Table is […]
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 […]
Data Files – Introduction to Databases
2.8.3.1 Data Files The main purpose of a database is to store and retrieve data. It consists of a collection of data that is treated as a unit. An Oracle database has a logical and physical structure. The logical layer consists of Table spaces, necessary for the smooth operation of […]
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 […]