Skip to main content
Cyprus International University
TR

DATABASE MANAGEMENT SYSTEMS II

Course
ITEC344 - DATABASE MANAGEMENT SYSTEMS II
Department
Information Technologies - English - Undergraduate
Course Type
Course
Status
Required
Language
English
Credit
4
ECTS
6
T+P+L
3 + 0 + 2
Course Coordinator(s)
-
Prerequisite
Keywords

Course Description

Fundamental concepts and applications about DB architectures will be discussed like properties of popular databases, backup, recovery, replication and reverse engineering. Also, students will gain knowledge on transactions, indexes, PL/SQL, Triggers, stored, functions, stored procedures and cursors. Views, materialized views, query performance optimization, database application Development with a programming language and SQL injection will also explained. Case studies will cover the topics studies in this lecture.

DATABASE MANAGEMENT SYSTEMS II

Evaluation Tools (Active Term)

No evaluation items have been defined.

Course outcomes

  1. 01 To develop skills for database administration for database objects
  2. 02 To give students an ability to clarify and apply the fundamental concepts in stored procedures/functions/triggers/materialized views
  3. 03 To give students a working knowledge and ability to apply Oracle DBMS Server's PLSQL
  4. 04 To enable students develop an application with DBMS

Course Syllabus

Week Topic
Week 1 Introduction
Week 2 Revision of DB I (ER Diagrams)
Week 3 Revision of DB I (SQL)
Week 4 SQL Developer
Week 5 Retrieving data with Joins
Week 6 Retrieving data with Sub-queries
Week 7 Data definition Languages (DDL), Data Manupulation Language (DML)
Week 8 Midterm Week
Week 9 Controling user access, Managing schema Objects
Week 10 Manupilating Large Data from many source
Week 11 Stored Procedures and Exception handling
Week 12 Stored Functions
Week 13 Dynamic SQL
Week 14 Triggers
Week 15 Developing Database Applications

Reference Books & Course Materials

  1. 01 Elmasri & Navathe "Fundementals of Database systems" 5th edition 2007
  2. 02 Oracle PL/SQL: Expert Techniques for Developers and Database Administrators
  3. 03 Database System Concepts

Learning Outcomes

  1. L01 To develop skills for database administration for database objects,
  2. L02 To give students an understanding of the fundamental concepts in stored procedures/functions/triggers/materialized views,
  3. L03 To give students a working knowledge of Oracle DBMS Server's PLSQL,
  4. L04 To enable students in the use of DBMS within an application.

Program Outcomes

  1. P01 Create a user interface in a contemporary object-oriented language to allow users to access business data
  2. P02 Identify and analyze user needs and take them into account in the selection, creation, integration, evaluation and administration of computing-based systems
  3. P03 Analyze common business functions and identify, design, and develop appropriate information technology solutions
  4. P04 Design and develop software solutions for contemporary business environments by employing appropriate problem-solving strategies
  5. P05 Configure and administer database server to support contemporary business environments.
  6. P06 Administer or mange a relational database for a small to medium size company
  7. P07 Be able to effectively integrate IT-based solutions into the user environment
  8. P08 Understand professional, ethical, legal, security and social issues and responsibilities
  9. P09 Be able to apply effective communication skills consistent with the professional environment
  10. P10 Be able to apply effective collaboration skills in teamwork consistent with the professional environment

Po-Lo Matrix

LO P01 P02 P03 P04 P05 P06 P07 P08 P09 P10 Average
L01 - - - - - - - - - - -
L02 - - - - - - - - - - -
L03 - - - - - - - - - - -
L04 - - - - - - - - - - -