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

CHAPTER 1

CH 1-2Chapters 1-2 - Database Fundamentals and Architecture98 SLIDES

CH 3-4Chapters 3-4 - ER and EER Data Modeling46 SLIDES

CH 5Chapter 5 - Relational Data Model and Constraints70 SLIDES

CH 9Chapter 9 - ER-to-Relational Mapping76 SLIDES

0x05Chapter 8 - Relational AlgebraNO DECK YET

CH 6Chapter 6 - Basic SQL43 SLIDES

CH 7Chapter 7 - Advanced SQL64 SLIDES

CH 14-15Chapters 14-15 - Functional Dependencies and Normalization94 SLIDES

CH 1Emergent 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%