DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING
- Course
- COMP213 - DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING
- Department
- Computer Programming - English - Associate
- Course Type
- Course
- Status
- Required
- Language
- English
- Credit
- 4
- ECTS
- 7
- T+P+L
- 3 + 0 + 2
- Course Coordinator(s)
- Asst. Prof. Dr. Yasemin BAY
- Prerequisite
- -
- Keywords
Course Description
At the end of this course, students are expected to have experience and knowledge on databases, database design and SQL. Introduction to DBMS (Definition, characteristics, levels of abstraction, advantages, query types), Relational database (relational model, database design), Relational Algebra, SQL, Data Manipulation Language (DML), nested queries, sub-queries, joins, grouping, row functions, aggregate functions, Data Definition Languages (DDL) with constraints like primary key, foreign key and case constraints will be covered. Also, database user management and user rights will be explained.
DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING
Evaluation Tools (Active Term)
| Item | Type | Weight (%) |
|---|---|---|
| Midterm | Midterm | 30 |
| Final | Final | 40 |
| Project | Project | 20 |
| Quiz1 | Quiz | 5 |
| Quiz2 | Quiz | 5 |
| Total | 100 | |
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
No learning outcomes have been defined.
Program Outcomes
- P01 Be able to apply knowledge of programming
- P02 Be able to design software systems of varying complexity
- P03 Be able to identify, categorize, and develop solutions for computer orientated challenges.
- P04 Be able to demonstrate autonomy and responsibility in managing computer programming projects
- P05 Be able to follow the state of the arts concepts in computer technology
- P06 Be able to design, implement, and evaluate a computational system to meet desired needs within realistic constraints.
- P07 Be able to use appropriate techniques, skills, and tools necessary for computing practice.
- P08 Be able to apply appropriate technologies and techniques for the collection and analysis of organizational and environmental data to facilitate evidence-based decision making
- P09 Be able to apply effective communication skills consistent with the professional environment -
- P10 Be able to apply effective collaboration skills in teamwork consistent with the professional environment -
Po-Lo Matrix
The PO-LO matrix has not been populated yet.