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: WHAT THIS BOOK COVERS
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. […]
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 […]
DEFINE RELATIONSHIPS – Introduction to Databases
2.5 DEFINE RELATIONSHIPS 2.5.1 Connectivity Connectivity refers to the types of relationships that entities can have. Basically, the relationship can be one-to-one, one-to-many and many-to-many. In ER diagrams, these are indicated by placing 1, M orN at one of the two ends of the relationship diagram. Figures 2.2–2.5 illustrate the […]
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 […]
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. […]
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 […]
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 […]
CREATE A NEW ORACLE XE 18C SAMPLE DATABASE – Introduction to Databases
2.9 CREATE A NEW ORACLE XE 18C SAMPLE DATABASE After you finish the installation of Oracle 18c Express Edition database (refer to Appendix A), you can begin to use it to connect to the server and build our database. Now let’s start to create a new Oracle 18c XE sample […]