Efnisyfirlit

• Database Management Systems: A Business-oriented Approach Using ORACLE, MySQL, and MS-Access
• Copyright Page
• Acknowledgments
• Contents
• About the Author
• Preface
• To the Student
• To the Instructor
• Part I: Understanding the DataBase Approach
• Chapter 1: The DataBase Environment
• Learning Objectives
• Chapter 2: DataBase Design
• Learning Objectives
• Chapter 1 The DataBase Environment
• 1.1. From Data to Information to Knowledge
• 1.2. Databases
• 1.2.1. File Systems
• 1.2.2. The Database Approach
• 1.3. The Database Environment
• 1.3.1. Database Management
• 1.3.2. Types of DBMS
• 1.3.2.1. First Requirement: Number of Database End Users
• 1.3.2.2. Second Requirement: Dispersion of Data Storage
• 1.3.2.3. Third Requirement: Type of Data Usage
• Summary
• Key Terms
• Review Questions
• Problems and Exercises
• Chapter 2 DataBase Design
• 2.1. The Database Development Process
• 2.2. Conceptual Database Design
• 2.2.1. Designing Entities
• 2.2.2. Designing Relationships
• 2.3. Logical Database Design Using the Relational Model
• 2.3.1. Step 1: Converting Entities into Tables
• 2.3.2. Step 2: Implementing 1:M Relationships
• 2.3.3. Step 3: Implementing M:M Relationships
• 2.4. Normalization – Optimizing the Database Design
• 2.4.1. Converting the Database to First Normal Form (1NF)
• 2.4.2. Converting the Database to Second Normal Form (2NF)
• 2.4.3. Converting the Database to Third Normal Form (3NF)
• Summary
• Key Terms
• Review Questions
• Problems and Exercises
• Part II: DataBase Development
• Chapter 3: Structured Query Language (SQL): Data Management
• Learning Objectives
• Chapter 4: Structured Query Language (SQL): Introducing Queries
• Learning Objectives
• Chapter 5: Structured Query Language (SQL): In Multiple Tables
• Learning Objectives
• Chapter 6: Structured Query Language (SQL): Grouping Data and Subqueries
• Learning Objectives
• Chapter 7: Structured Query Language (SQL): Views, Triggers, and Functions
• Learning Objectives
• Chapter 3 Structured Query Language (SQL): Data Management
• 3.1. SQL Basics
• 3.2. Creating the Database
• 3.2.1. Creating the Database Tables
• 3.2.1.1. Creating Tables in MariaDB
• Creating Tables in MariaDB through the SQL Command Editor
• Creating Tables in MariaDB Visually
• 3.2.1.2. Creating Tables in ORACLE
• Creating Tables in ORACLE Express with the SQL Command Editor
• Creating Tables in ORACLE Visually
• 3.2.1.3. Creating Tables in MS-Access
• Creating Tables in MS-Access Using the SQL Command Editor
• To create tables using the MS-Access visual environment follow the video on
• 3.3. Inserting Data into the Database
• 3.4. Deleting and Updating Data
• 3.4.1. Deleting Data from a Database
• 3.4.2. Updating the Data of a Database
• 3.4.3. ON DELETE and ON UPDATE Referential Integrity Constraints
• 3.4.4. Updating the Table Structure
• Summary
• Key Terms
• Review Questions
• Problems and Exercises
• Chapter 4 Structured Query Language (SQL): Introducing Queries
• 4.1. Query Basics
• 4.2. Understanding the Operations of SQL queries
• 4.2.1. Attribute and Row Selection
• 4.2.2. Selection Extraction and Update of Query Data
• 4.2.3. Executing SQL Queries
• 4.3. Forming SQL Queries
• 4.3.1. Create SQL Queries Using Conditional and Logical Operators
• 4.3.2. Create SQL Queries Using Text Searching
• 4.3.3. Create SQL Queries Using Date Searching
• 4.3.4. Using Arithmetic Operations in SQL Queries
• 4.3.5. Using the DISTINCT Clause
• 4.3.6. Sorting the Data in SQL Queries
• 4.4. SQL Aggregate Functions
• 4.4.1. The COUNT Aggregate Function
• 4.4.2. The SUM Aggregate Function
• 4.4.3. The AVG Aggregate Function
• 4.4.4. The MAX Aggregate Function
• 4.4.5. The MIN Aggregate Function
• Summary
• Key Terms
• Review Questions
• Problems and Exercises
• Chapter 5 Structured Query Language (SQL): In Multiple Tables
• 5.1. Joining Tables
• 5.1.1. The Rationale of Table Joining
• 5.1.2. Joining Tables with Cross Join
• 5.1.3. From Cross Join to Inner Join
• 5.1.3.1. Common Error
• 5.2. SQL JOIN Operator
• 5.2.1. Inner Join
• 5.2.2. Outer Join
• 5.2.3. Using Alias in JOIN
• 5.2.4. Cases of Using SQL Commands in Joined Tables
• 5.2.4.1. First Case: The Query Requires Attributes from Two Related Tables
• 5.2.4.2. Second Case: The Query Requires Attributes from Three or More Related Tables.
• 5.2.4.3. Third Case: The Query Requires Attributes from a Table or Tables, but the Criteria in the W
• 5.2.4.4. Fourth Case: Three Tables Are Related to Each Other in a Chain. The Query Requires Attribut
• 5.2.5. Recursive JOIN
• 5.3. Relational Set Operators
• 5.3.1. UNION Set Operator
• 5.3.2. INTERSECT Set Operator
• 5.3.3. MINUS Set Operator
• Summary
• Key Terms
• Review Questions
• Problems and Exercises
• Chapter 6 Structured Query Language (SQL): Grouping Data and Subqueries
• 6.1. Grouping Data
• 6.1.1. The Rationale of Data Grouping
• 6.1.2. The GROUP BY Clause
• 6.1.3. The DISTINCT Clause
• 6.1.4. Grouping with Limitations Using the WHERE Clause
• 6.1.5. Grouping with Calculated Attributes
• 6.1.6. The HAVING Clause
• 6.2. Subqueries
• 6.2.1. The Rational of Using Subqueries
• 6.2.2. WHERE Subqueries
• 6.2.3. HAVING Subqueries
• 6.2.4. IN Subqueries
• 6.2.5. ALL and ANY Subqueries
• 6.2.6. SELECT Subqueries
• 6.2.7. FROM Subqueries
• 6.2.8. INSERT, UPDATE, DELETE Revised with Subqueries
• Summary
• Key Terms
• Review Questions
• Problems and Exercises
• Chapter 7 Structured Query Language (SQL): Views, Triggers, and Functions
• 7.1. Views
• 7.1.1. Creating Virtual Tables as Views
• 7.1.2. Data Updating through Views
• 7.2. Triggers
• 7.2.1. The Rationale of Triggers
• 7.2.2. Creating Triggers
• 7.3. SQL Functions
• 7.3.1. Managing Arithmetic Attributes in Queries
• 7.3.2. Selecting Random Values in Queries
• 7.3.3. Concatenating and Managing Text Attributes
• 7.3.4. Date Managing Functions in Queries
• 7.3.5. Creating User-defined Functions
• Summary
• Key Terms
• Review Questions
• Problems and Exercises
• Part III: DataBase Management
• Chapter 8: DataBase: Administration and Security
• Learning Objectives
• Chapter 9: Building Web DataBase Applications
• Learning Objectives
• Chapter 10: DataBases in the Business World
• Learning Objectives
• Chapter 11: Distributed DataBases and Concurrency Control
• Learning Objectives
• Chapter 8 DataBase: Administration and Security
• 8.1. Database Administration
• 8.1.1. Database and Metadata Administration
• 8.1.2. Database Optimization
• 8.1.3. Efficient Data Storage Configuring Partitioning
• 8.1.4. Indexes – Improving Database Performance
• 8.1.5. Database Backup and Recovery
• 8.2. Database Security
• 8.2.1. Database Security Threats
• 8.2.1.1. Abuse of Legitimate Database Privileges
• 8.2.1.2. Excessive Privileges to Users
• 8.2.1.3. Weak Audit Trails
• 8.2.1.4. Storage Media Exposure
• 8.2.1.5. Security Attacks from Cybercriminals
• 8.2.2. Mitigating Database Security Threats
• 8.2.2.1. Scan for Vulnerability
• 8.2.2.2. Identify Sensitive Data
• 8.2.2.3. User Access Rights Management
• 8.2.2.4. Apply User Tracking
• 8.2.2.5. Monitoring and Blocking
• 8.2.2.6. Apply Database Audits
• 8.2.3. Creating Users and Granting Privileges
• Summary
• Key Terms
• Review Questions
• Problems and Exercises
• Chapter 9 Building Web DataBase Applications
• 9.1. Database Applications
• 9.1.1. Defining Database Applications
• 9.1.2. Database Application GET and POST Operations
• 9.1.3. Single-user and Multiuser Applications
• 9.1.4. Web Database Applications
• 9.2. Building Database Applications
• 9.2.1. Building a Web Database Application in ORACLE
• 9.2.2. Building a Database Application in MS-Access
• 9.2.3. Building a Database Application in MariaDB
• 9.2.3.1. First Step: Connect PHP with the SQL Engine
• 9.2.3.2. Second Step: Select the Database
• 9.2.3.3. Third Step: Execute the Query
• 9.2.3.4. Fourth Step: Display the Results on the Web
• Summary
• Key Terms
• Review Questions
• Problems and Exercises
• Chapter 10 DataBases in the Business World
• 10.1. Business Challenges in the Global Economy
• 10.2. Business Intelligence
• 10.2.1. A Framework for Business Intelligence
• 10.2.2. Data Warehouses and OLAP Services
• 10.2.3. OLAP Operations– Roll-up, Drill-down, Slice and Dice, Pivot
• 10.2.4. SQL ROLLUP, CUBE, and GROUPIN OLAP Extensions
• 10.2.5. Data Mining in Big Data
• 10.2.6. Data and Predictive Analytics
• 10.3. Enterprise-wide Reporting
• 10.3.1. The Need for Integration in Business ISs
• 10.3.2. ERPs and Enterprise-wide Reporting
• 10.3.3. Databases in ERPs
• 10.3.4. Cloud Enterprise Computing
• Summary
• Key Terms
• Review Questions
• Problems and Exercises
• Chapter 11 Distributed DataBases and Concurrency Control
• 11.1. Centralized and Distributed Databases
• 11.2. Distributed Database Design
• 11.2.1. The Fragmentation – Replication Dilemma
• 11.2.2. Distributed Database Fragmentation
• 11.3. Using Distributed Databases
• 11.3.1. Client’s Distribution Transparency
• 11.3.2. Client’s Distribution Transparency
• 11.4. Concurrency Control
• 11.4.1. Transaction Management in SQL
• 11.4.2. Concurrency Control with Lost Updates
• 11.4.3. Concurrency Control with Uncommitted Data
• 11.4.4. Concurrency Control with Scheduler
• 11.4.5. Two-Phase Commit Protocol in Distributed Databases
• Summary
• Key Terms
• Review Questions
• Problems and Exercises
• References
• Index