Fundamentals of Database System Course Overview.pptx

Fundamentals of Database System

1. Course Overview Fundamentals of Database Systems 1 JKU, 2025 Department of Computer Science By Instructor: Mequanent S.

2. What the course is about? Databases play a critical role in almost all areas where computers are used, including in business , engineering , medicine , law , education , and library science , etc. Database systems are designed to manage large data set in an organization . They are used to: maintain internal records, present data to customers and clients on the World-Wide-Web ,& support many other commercial processes 2

3. C o n t … Thus the DB course is about: How to organize data Supporting multiple users Efficient and effective data retrieval Secured and reliable storage of data Maintaining consistent data Making information useful for decision making 3

4. T h u s This course is designed to equip students with the theoretical and practical skill in understanding, designing, developing, administering and managing a database system in an organization . 4

5. Course Content Chapter 1 Introduction to Database Systems 1.1. Overview 1.2. Basics of Database 1.3. File organization verses Database approach 1.4. Characteristics of the Database Approach 1.5. Users and actors of Database system 1.6. Actors on the Scene 5

6. Cont.. Chapter 2 Database System Architecture 2.1. Data models, Schemas, and Instances 2.2. Over view of data models 2.3. Architecture and Data Independence 2.4. Database Language and Interface 2.5. The Database System Environment 2.6. Classification of DBMS 6

7. C o n t … Chapter 3 Database Modeling 3.1. The Entity Relationship (ER) Model 3.1.1. The high-level conceptual model 3.1.2. Entities, Attributes, and Keys 3.1.3. Relationships, Associations, and Constraints 3.1.4. The ER Diagrams 3.1.5. Mapping ER-models to relational tables 3.2. Enhanced Entity Relationship (EER) Model 7

8. C o n t … 3.2. Enhanced Entity Relationship (EER) Model 3.2.1. Inheritance 3.2.2. Union 3.2.3. Aggregation and Association 3.2.4. Mapping EER model to relational model 3.3. The Relational Database Model 3.3.1. The Relational Model Concepts 3.3.2. The Relational Constraints and Relational Database Schemas 3.3.3. The Relational Operations 8

9. C o n t … Chapter 4 Functional Dependency and Normalization 4.1. Functional Dependency 4.2. Normal Forms 4.2.1. First Normal Form 4.2.2. Second Normal Form 4.2.3. Third Normal Form 4.2.4. Boyce Coded Normal Form 9

10. C o n t … Chapter 5 Record Storage and Primary File Organization 5.1. Introduction 5.2. Operations on Files 5.3. Files of Unordered Records (Heap Files) 5.4. Files of Ordered Records (Sorted Files) 5.5. Hashing Techniques 5.6. Index Structure for Files 5.7. Types of Single Level Ordered Index 5.8. Dynamic Multilevel indexes using B Trees and B+ Trees 5.9. Indexes on Multiple Indexes 10

11. C o n t … Chapter 6 The Relational Algebra and Relational Calculus 6.1. Introduction 6.2. Relational Algebra 6.3. The Relational Calculus 11

12. C o n t … Chapter 7 The SQL Language 7.1. Structured Query Language 7.2. Data types 7.3. DDL, DML, TCL and DCL 7.4. Basic Queries in SQL 7.5. Nested Queries in SQL 7.6. Views 7.7. Comments 7.8. Constraints 12

13. R e f e r e nc e s Book 1. Raghu Ramakrishnan, Johannes Gehrke . Database Management Systems, McGraw-Hill; 3rd edition, 2002 2. Elmasri , R., & Navathe, S. (2017). Fundamentals of database systems (7th Edition). Pearson. Other References 1. Osama Mustafa, Robert P. Lockard. (2019). Oracle Database Application Security, Apress , Berkeley,CA . 2. C. J. Date. (2019). Database Design and Relational Theory. 2nd Edition. Apress , Berkeley, CA. 3. Anthony Hack. (2019). SQL Computer Programming for Beginners . Independently published 13

14. Course Assessment Assessment Type Percentage Quiz/ Assignment 10% Lab Exam/Project 2 % Mid Exam 3 % Final Exam 40% T O T AL 100%

15. Chapter One - Introductory Concepts Next Class on 15