Database Systems (CSE 321)
Course information
The objective of the course is to present an introduction to database management systems, with an emphasis on how to organize, maintain and retrieve information from a Database management system (DBMS). This will help students to develop and design software systems utilizing databases, and equip students with the knowledge of managing large-scale data. Moreover, this should be understood by current and future business leaders so that they can offer strategic guidance based on an informed understanding of database business capabilities. This course provides the basis for achieving this goal.
2022F courses (TA: Bongwon Lee, Seongyun Jeong)
Midterm (statistics), Final (statistics)
2023F courses (TA: Song Kim, Sunghyun Yang, Seongyun Jeong)
Midterm (statistics), Final (statistics)
Tentative Outline for the Courses
Database System concepts and architecture - Introduction to the fundamental concepts of database systems, including data models, schemas, and architectures.
References:
--
ER-diagram - Study of Entity-Relationship diagrams used to visually represent data models and relationships between data entities.
References:
Database Complete Book -
Relational data model and relational database constraints - Exploration of the relational data model, including tables, attributes, and keys, and the constraints that maintain data integrity.
References:
XXX
Relational database design by ER mapping - Techniques for converting ER diagrams into relational database schemas.
References:
XXX
Basic SQL - Introduction to Structured Query Language (SQL) for querying and manipulating relational databases.
References:
XXX
Advanced SQL - Advanced SQL techniques including joins, subqueries, and transaction control.
References:
XXX
Relational Algebra - Theoretical foundation of SQL, using relational algebra to describe operations on relations.
References:
XXX
Functional dependencies - Analysis of functional dependencies and their role in database normalization.
References:
XXX
Normalisation - Process of organizing data to minimize redundancy and dependency using normal forms.
References:
XXX
B-Tree - Study of B-Tree data structures used in database indexing for efficient data retrieval.
References:
XXX
Transactions and concurrency controls - Concepts of database transactions and methods to ensure consistency in concurrent operations.
References:
XXX
Vector database - Introduction to vector databases, focusing on handling and querying vector data efficiently.
References:
XXX
MySQL references
W3 School: https://www.w3schools.com/MySQL/default.asp
Code Academy: https://www.codecademy.com/catalog/language/sql
Tools
ER-diagram: https://draw.io/
Relational database tools: http://raymondcho.net/RelationalDatabaseTools/RelationalDatabaseTools.html
Decomposition calculator: http://functionaldependencycalculator.ml/algorithm/7
Related textbook & lecture
With highest honor
2022F: Junwha Hong
2023F: Woocheol Shin