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 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