Chapter 01 Basic Database Concepts

01 The Need for a Database
Data and Information
Information Systems and Databases
02 Definition and characteristics of database
Definition of a database
Database Features
03 Data in the Data Science Era
Data classification by form
Data classification by characteristics
summation
Practice problems

Chapter 02 Database Management System

01 Background of the emergence of database management systems
02 Definition of Database Management System
03 Advantages and Disadvantages of Database Management Systems
04 The evolution of database management systems
summation
Practice problems

Chapter 03 Database System

01 Definition of a database system
02 Database Structure
schema
3-stage database structure
Data independence
Data Dictionary
03 Database User
database administrator
End users
application programmer
04 Data Language
Data Definition Language
data manipulation language
Data control language
05 Configuration of the database management system
Query handler
Saved Data Manager
summation
Practice problems

Chapter 04 Data Modeling

01 Data Modeling and Data Model Concepts
02 Entity-Relationship Model
individual
attribute
relationship
ER diagram
03 Logical Data Model
Concepts and characteristics of logical data models
Hierarchical data model
Network Data Model
summation
Practice problems

Chapter 05 Relational Data Model

01 Concept of Relational Data Model
Basic terms of the relational data model
Structure of Relations and Databases
Characteristics of relations
Types of keys
02 Constraints of the relational data model
Entity integrity constraints
referential integrity constraints
summation
Practice problems

Chapter 06 Relational Data Operations

01 Concept of relational data operations
02 Relational Algebra
Concepts and operators of relational algebra
General set operators
Pure relational operators
Expressing queries using relational algebra
Extended relational algebra operators
03 Relationship Interpretation
summation
Practice problems

Chapter 07 Database Language SQL

01 Introduction to SQL
02 Data Definition Using SQL
SQL's data definition features
Creating a table
Change the table
Delete table
03 Data manipulation using SQL
SQL's data manipulation functions
Data retrieval
Inserting data
Modification of data
Deletion of data
04 views
The concept of view
Creating a view
Utilizing views
Delete a view
05 Insert SQL
Concepts and Features of Insert SQL
Insert SQL without cursor
Insert SQL that requires a cursor
summation
Practice problems

Chapter 08 Database Design

01 Database Design Phase
02 Requirements Analysis
03 Conceptual Design
Extracting objects and properties
Relationship extraction
Creating an ER diagram
04 Logical Design
Relation schema conversion rules
Logical design using relation schema transformation rules
05 Physical Design and Implementation
summation
Practice problems

Chapter 09 Normalization

01 The concept of normalization and abnormal phenomena
02 Functional dependency
03 Basic normal form and normalization process
The concept of normalization and types of normal forms
First regular form
Second regular form
3rd regular form
Voice/Code Regular
Fourth normal form and fifth normal form
Summary of the normalization process
summation
Practice problems

Chapter 10 Recovery and Parallel Control

01 Transaction
The concept of transaction
Transaction characteristics
Transactions and Operations
Transaction status
02 Disability and Recovery
Types of Disabilities
Database storage operations
recovery techniques
03 Parallel Control
Parallel execution and parallel control
The problem of parallel execution
Transaction Schedule
Concurrency control techniques
summation
Practice problems

Chapter 11 Security and Permissions Management

01 Security
02 Permission Management
The concept of authority management
Granting of authority
Revocation of authority
Assigning and revoking roles
summation
Practice problems

Chapter 12 Database Application Technologies

01 Object-oriented database
02 Object-relational database
03 Distributed Database System
04 Multimedia Database System
05 Other database application technologies
summation
Practice problems

Chapter 13 Data Science and Big Data

01 Data Science
02 Big Data
03 Big Data Storage Technology: NoSQL
04 Big Data Analysis Technology: Data Mining
04 Big Data Representation Technology: Data Visualization
summation
Practice problems

Appendix Utilization of the Database
01 Introduction and Installation of Oracle
02 Building and using a database using Oracle
03 Building and Using a Database Using Live SQL
Project 04: Let's Write Together, Friends

① Database Basics: Chapter 1 introduces databases, and Chapter 2 introduces DBMS.
Chapter 3 introduces a database system that combines these.

② Data Model and Operation: In Chapter 4, we will learn about the concept of data modeling and the role of data models.
And in Chapter 5, we look at the overall relational data model, which is the core data model, and in Chapter 6, we look at the main operations of relational data.

③ Database Language SQL: After introducing the main functions of SQL in Chapter 7, we will learn how to write queries in SQL to create tables and retrieve and manipulate data.

④ Database Design: Introduces the importance and goals of database design and covers two major design methods.
In Chapter 8, we will learn about design methods using the E-R model and relational transformation rules, and in Chapter 9, we will learn about design methods using normalization.

⑤ Database Management: In Chapter 10, we will learn about various recovery techniques and concurrency control techniques that solve problems that may arise when executing concurrently.1
In Chapter 1, you'll learn how to grant and revoke permissions using SQL to maintain database security.

⑥ Database Application Technology: Chapter 12 introduces object-oriented, object-relational, distributed, and multimedia databases that have different characteristics from relational databases.
Chapter 13 explores the relationship between data science and big data and introduces big data-related technologies.

⑦ Database Utilization: In the appendix, learn how to actually build a database using Oracle.
And we'll introduce a simple project that demonstrates the theory covered throughout the book.