DATABASE MANAGEMENT SYSTEMS I

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 I

Evaluation Tools (Active Term)

Course outcomes

1. 01 Analyze a problem to design a relational database.
2. 02 recognize the fundamental concepts in relational theory
3. 03 implement relational theory to working knowledge of Oracle DBMS Server
4. 04 apply SQL for DML and DDL

Course Syllabus

Reference Books & Course Materials

1. 01 Elmasri & Navthe: Fundamentals of Database Systems, Addison Wesley, fifth ed., 2007.

Learning Outcomes

1. L01 To develop skills for designing and implementing a relational database SOLO 5
2. L01 To develop skills for designing and implementing a relational database SOLO 5
3. L02 Describe the fundamental concepts in relational theory SOLO 3
4. L02 Describe the fundamental concepts in relational theory SOLO 3
5. L03 Perform operations using query language using DBMS softwares SOLO 4
6. L03 Perform operations using query language using DBMS softwares SOLO 4
7. L04 Develop skills and understanding to create and modify tables in relational databases SOLO 5
8. L04 Develop skills and understanding to create and modify tables in relational databases SOLO 5

Program Outcomes

1. P01 Be able to understand and apply security protocol and tools to security challenges faced in organizations
2. P02 Be able to design security software to combat security issues
3. P03 Be able to identify, categorize, and develop security solutions for computer orientated challenges.
4. P04 Be able to demonstrate autonomy and responsibility in managing computer security projects
5. P05 Be able to follow the state of the arts concepts in computer technology security
6. P06 Be able to design, implement, and evaluate a computational system to meet desired security needs within realistic constraints
7. P07 Be able to use appropriate security techniques, protocols, skills, and tools necessary for securing computer systems
8. P08 Be able to apply effective communication skills consistent with the professional environment
9. P09 Be able to apply effective collaboration skills in teamwork consistent with the professional environment
10. P10 Be able to apply appropriate security technology and techniques to facilitate a safe operation in an organization

Po-Lo Matrix