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: Oracle Exams
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.
HOW THIS BOOK IS ORGANIZED AND HOW TO USE THIS BOOK – Introduction
1.4 HOW THIS BOOK IS ORGANIZED AND HOW TO USE THIS BOOK This book is designed for both college students who are new to database programming with Java and professional database programmers who have some experience on this topic. Chapters 2 and 3 provide the fundamentals on database structures and […]
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 […]
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 […]
WHAT ARE DATABASES AND DATABASE PROGRAMS? – Introduction to Databases
2.1 WHAT ARE DATABASES AND DATABASE PROGRAMS? A modern-day database is a structured collection of data stored in a computer. The term “struc-tured” implies that each record in the database is stored in a certain format. For example, all entries in a phone book are arranged in a similar fashion. […]
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 […]