DATABASE MANAGEMENT SYSTEMS

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

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. L02 Describe the fundamental concepts in relational theory SOLO 3
3. L03 Perform operations using query language using DBMS softwares SOLO 4
4. L04 Develop skills and understanding to create and modify tables in relational databases SOLO 5

Program Outcomes

1. P01 Demonstrate comprehensive knowledge of key concepts across the breadth of effective application and use of MIS and innovative information technologies in organizations.
2. P02 Demonstrate autonomy and responsibility in managing MIS projects and improving organizational processes
3. P03 Demonstrate comprehensive understanding of appropriate enterprise frameworks, theories from the MIS to research and assess contemporary issues in the field and related allied fields and disciplines
4. P04 Apply MIS knowledge to facilitate the acquisition, development, deployment, and management of information systems
5. P05 Apply MIS knowledge to the exploitation of opportunities created by information technology innovations ensuring the alignment between MIS strategy and organizational strategy
6. P06 Demonstrate ethical reasoning in relation to crucial MIS issues such as privacy, information security, and ethical use of information
7. P07 Apply appropriate technologies and techniques to the collection and analysis of organizational and environmental data to facilitate evidence-based decision-making
8. P08 Analyse organizational data to accurately identify organizational problems and propose solutions using MIS
9. P09 Apply effective communication skills consistent with the professional environment
10. P10 Apply effective collaboration skills consistent with the professional environment

Po-Lo Matrix