CS340
COMPLETEIntroduction to Database Systems
CS340 introduces database concepts, database architecture, conceptual data modeling, logical database design, relational constraints, relational algebra, SQL, normalization, teamwork-based database projects, and emergent database topics such as object-oriented databases, NoSQL theory, and MongoDB CRUD operations.
Course Code
CS340
Credit Hours
3
Prerequisites
CS210 Data Structures
01_DESCRIPTION
CS340 introduces database concepts, database architecture, conceptual data modeling, logical database design, relational constraints, relational algebra, SQL, normalization, teamwork-based database projects, and emergent database topics such as object-oriented databases, NoSQL theory, and MongoDB CRUD operations.
02_SYLLABUS_INDEX
0x01Chapters 1-2 - Database Fundamentals and Architecture
0x02Chapters 3-4 - ER and EER Data Modeling
0x03Chapter 5 - Relational Data Model and Constraints
0x04Chapter 9 - ER-to-Relational Mapping
0x05Chapter 8 - Relational Algebra
0x06Chapter 6 - Basic SQL
0x07Chapter 7 - Advanced SQL
0x08Chapters 14-15 - Functional Dependencies and Normalization
0x09Emergent Database Topics
0x0AFinal Project
03_LEARNING_OUTCOMES
- Describe basic database concepts, architecture, and DBMS principles.
- Develop conceptual models using ER, EER, or UML notation.
- Create logical database designs from conceptual ER models.
- Apply functional dependencies and normalization forms such as 1NF, 2NF, 3NF, and BCNF.
- Create relational schemas using keys, entity integrity, and referential integrity.
- Work effectively in a team to design, implement, and present a database project.
04_WEIGHT_OF_ASSESSMENTS
0x01Class Assignment
0x02Quizzes (2)
0x03Major Exams (2)
0x04Project
0x05Attendance
0x06Final Exam