CS340

COMPLETE

Introduction 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

02_SYLLABUS_INDEX // 9_DECKS // 525_SLIDES

0x01Chapters 1-2 - Database Fundamentals and Architecture98 SLIDES

0x02Chapters 3-4 - ER and EER Data Modeling46 SLIDES

0x03Chapter 5 - Relational Data Model and Constraints70 SLIDES

0x04Chapter 9 - ER-to-Relational Mapping76 SLIDES

0x05Chapter 8 - Relational AlgebraNO DECK YET

0x06Chapter 6 - Basic SQL43 SLIDES

0x07Chapter 7 - Advanced SQL64 SLIDES

0x08Chapters 14-15 - Functional Dependencies and Normalization94 SLIDES

0x09Emergent Database Topics34 SLIDES

0x0AFinal ProjectPROJECT

ΣTotal Slides525 SLIDES

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 Assignment5%

0x02Quizzes (2)10%

0x03Major Exams (2)25%

0x04Project15%

0x05Attendance5%

0x06Final Exam40%