Oracle Database Programming with Java: Ideas, Designs, and Implementations
Cover -- Half Title -- Title -- Copyright -- Dedication -- Contents -- Preface -- Acknowledgments -- About the Author -- Copyrights and Trademarks -- Chapter 1 Introduction -- 1.1 Outstanding Features of This Book -- 1.2 Whom This Book Is For -- 1.3 What This Book Covers -- 1.4 How This Book Is Organized and How to Use This Book -- 1.5 How to Use the Source Code and the Sample Database -- 1.5.1 Instructor Materials and Customer Support -- Chapter 2 Introduction to Databases -- 2.1 What Are Databases and Database Programs? -- 2.1.1 File Processing System -- 2.1.2 Integrated Databases -- 2.2 Developing a Database -- 2.3 A Sample Database -- 2.3.1 Relational Data Model -- 2.3.2 Entity-Relationship (ER) Model -- 2.4 Identifying Keys -- 2.4.1 Primary Key and Entity Integrity -- 2.4.2 Candidate Key -- 2.4.3 Foreign Keys and Referential Integrity -- 2.5 Define Relationships -- 2.5.1 Connectivity -- 2.6 ER Notation -- 2.7 Data Normalization -- 2.7.1 First Normal Form (1NF) -- 2.7.2 Second Normal Form (2NF) -- 2.7.3 Third Normal Form (3NF) -- 2.8 Database Components in Some Popular Databases -- 2.8.1 Microsoft Access Databases -- 2.8.1.1 Database File -- 2.8.1.2 Tables -- 2.8.1.3 Queries -- 2.8.2 SQL Server Databases -- 2.8.2.1 Data Files -- 2.8.2.2 Tables -- 2.8.2.3 Views -- 2.8.2.4 Stored Procedures -- 2.8.2.5 Keys and Relationships -- 2.8.2.6 Indexes -- 2.8.2.7 Transaction Log Files -- 2.8.3 Oracle Databases -- 2.8.3.1 Data Files -- 2.8.3.2 Tables -- 2.8.3.3 Views -- 2.8.3.4 Stored Procedures -- 2.8.3.5 Initialization Parameter Files -- 2.8.3.6 Control Files -- 2.8.3.7 Redo Log Files -- 2.8.3.8 Password Files -- 2.9 Create a New Oracle XE 18c Sample Database -- 2.9.1 Connect to Default Oracle Database from the Oracle SQL Developer -- 2.9.2 Create an Oracle User Account for the User Schema -- 2.9.3 Create LogIn Table -- 2.9.4 Create Faculty Table.