DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING-I
- Course
- CMPE343 - DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING-I
- Department
- Computer Engineering - English - Master
- Course Type
- Scientific Preparation
- Status
- Required
- Language
- English
- Credit
- 0
- ECTS
- 0
- T+P+L
- 0 + 0 + 0
- Course Coordinator(s)
- -
- Prerequisite
- -
- Keywords
- -
Course Description
-
DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING-I
Evaluation Tools (Active Term)
No evaluation items have been defined.
Course outcomes
- 01 Analyze a problem to design a relational database.
- 02 recognize the fundamental concepts in relational theory
- 03 implement relational theory to working knowledge of Oracle DBMS Server
- 04 apply SQL for DML and DDL
Course Syllabus
| Week | Topic |
|---|---|
| Week 1 | Introduction to Database Management Systems |
| Week 2 | DMBS concepts (Characteristics, levels of abstraction, advantages, query types ) |
| Week 3 | Relational database ( relational model, ER diagram) |
| Week 4 | 1 Week Break due to Covid19 Pandemy |
| Week 5 | Introduction to Structured Query Language |
| Week 6 | Restricting and Sorting Data |
| Week 7 | Single Row Functions |
| Week 8 | Conversion Functions |
| Week 9 | Aggregate Functions |
| Week 10 | Nested Queries - joins |
| Week 11 | Nested queries - Subqueries |
| Week 12 | Data Definition Languages (DDL) (table operations, constraints, indexing) |
| Week 13 | Data Manipulation Language(DML) |
| Week 14 | Normalization |
| Week 15 | Revision |
Reference Books & Course Materials
- 01 Elmasri & Navthe: Fundamentals of Database Systems, Addison Wesley, fifth ed., 2007.
Learning Outcomes
- L01 To develop skills for designing and implementing a relational database
- L02 To give students an understanding of the fundamental concepts in relational theory
- L03 To give students a working knowledge of Oracle DBMS Server
- L04 To enable students in the use of SQL for DML and DDL
Program Outcomes
No program outcomes have been defined.
Po-Lo Matrix
The PO-LO matrix has not been populated yet.