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: DEVELOPING A DATABASE
WHAT THIS BOOK COVERS – Introduction
1.3 WHAT THIS BOOK COVERS Nine chapters are included in this book. The contents of each chapter can be summarized as follows. detail. One of the most useful tools, JDBC RowSet, is also discussed and analyzed with some example code.
Integrated Databases – Introduction to Databases
2.1.2 Integrated Databases A better alternative to a file processing system is an integrated database approach. In this environ-ment, all data belonging to an organization is stored in a single database. The database is not a mere collection of files; there is a relation between the files. Integration implies a […]
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 […]
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, […]
Relational Data Model – Introduction to Databases
2.3.1 Relational Data Model A data model is like a blueprint for developing a database. It describes the structure of the database and various data relationships and constraints on the data. This information is used in building Tables and keys and defining relationships. A relational model implies that a user […]
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 […]
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 […]
Keys and Relationships – Introduction to Databases
2.8.2.5 Keys and Relationships A primary key is created for each Table in the database to efficiently access records and to ensure entity integrity. This implies that each record in a Table is unique in some way. Therefore, no two records can have the same primary key. The primary key […]
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 […]