DATABASE MANAGEMENT SYSTEMS

Course Description

-

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
2. L02 To give students an understanding of the fundamental concepts in relational theory
3. L03 To give students a working knowledge of Oracle DBMS Server
4. L04 To enable students in the use of SQL for DML and DDL

Program Outcomes

1. Demonstrate advanced knowledge of core concepts and theoretical frameworks in Management Information Systems, and apply them to develop innovative models that reflect current advancements in the field.
2. Analyze complex organizational problems and design integrated information systems solutions by applying advanced MIS knowledge and synthesizing multiple theoretical perspectives.
3. Develop and manage database systems and data-driven applications that ensure effective storage, retrieval, and use of organizational data in real-world contexts.
4. Utilize data analytics, business intelligence tools, and data visualization techniques to extract actionable insights and support strategic, data-driven decision-making.
5. Evaluate and apply emerging technologies such as AI, IoT, and Blockchain to drive digital transformation, enhance organizational performance, and formulate original research inquiries.
6. Conduct independent and collaborative research using appropriate methodologies, and communicate findings effectively through scholarly writing and presentations suited to diverse audiences.
7. dentify and address ethical, legal, and societal implications in the research, development, and use of information technologies, adhering to scientific and professional standards.
8. Collaborate effectively in multidisciplinary teams and demonstrate leadership in addressing complex technology-driven challenges.
9. Apply project management methodologies and tools to plan, execute, and monitor IT projects within organizational settings.
10. Develop and integrate information systems that align with organizational goals and strategies, supporting innovation and sustainable growth.
11. Perform comprehensive systems analysis and design, including requirements gathering, modeling, prototyping, and evaluating enterprise system architectures such as ERP, CRM, and SCM.
12. Assess and mitigate organizational information security risks by applying appropriate principles, technologies, and best practices in cybersecurity.

Po-Lo Matrix