Database Management - Introduction
Management and Science University Graduate Management Centre (GMC)
Database Administration (DCT 5043)
Instructor: Weekly Schedule: Contact: General Method of instruction:
Dr. David Asirvatham Director / A. Prof. Sun: 9.00am – 5.30pm david.asirvatham@gmail.com Tel: 019-5111555 Lectures Discussions Tutorials Assignment Case Studies Project Fundamentals of Database Systems, 6/E by Ramez Elmasri & Shamkant Navathe; : Addison-Wesley, 2011 Information Technology Project Management Jack T. Marchewka Wiley, 2006
Text:
Software:
Dreamweaver HTML/XML/ PHP editor Apache Web Server MySQL database Project Software
MBA : Information System and E-commerce
Subject Code Subject Status Level Credit hours Assessment
Database Administration DCT 5043 Core Masters (MBA) 3 (3 + 0) 3 representing lectures (7 hrs per week x 6 weeks) Exam 50% Assignment 1: DB (Individual) 15% Assignment 2: Project Plan (Group) 15% Project Management (Group) 20%
Objectives
In this course, students will be: 1. guided to outline architecture for a database system, define and manipulate data, and understand the transactions process of database systems 2. provided with knowledge on modern database systems, data warehouses and on-line analytical processing, and the role of database in e-commerce 3. Explain the basic principles IT strategic planning, and the main techniques commonly used in the preparation of IS/IT strategic plans and Projects; By the end of the course, students should be able to: 1. Explain the principles of database management systems 2. Explain data modeling with emphasis on Relational Mode 3. Demonstrate the ability to design databases using E-R Models 4. Explain query processing and familiarize using SQL; 5. Strategic information system planning: what is involved in establishing a planning process 6. Determining the business information systems strategy. 7. Strategic planning for information systems 8. Explain the basic steps in Project Management This course
Database Administration (DCT 5043)
Instructor: Weekly Schedule: Contact: General Method of instruction:
Dr. David Asirvatham Director / A. Prof. Sun: 9.00am – 5.30pm david.asirvatham@gmail.com Tel: 019-5111555 Lectures Discussions Tutorials Assignment Case Studies Project Fundamentals of Database Systems, 6/E by Ramez Elmasri & Shamkant Navathe; : Addison-Wesley, 2011 Information Technology Project Management Jack T. Marchewka Wiley, 2006
Text:
Software:
Dreamweaver HTML/XML/ PHP editor Apache Web Server MySQL database Project Software
MBA : Information System and E-commerce
Subject Code Subject Status Level Credit hours Assessment
Database Administration DCT 5043 Core Masters (MBA) 3 (3 + 0) 3 representing lectures (7 hrs per week x 6 weeks) Exam 50% Assignment 1: DB (Individual) 15% Assignment 2: Project Plan (Group) 15% Project Management (Group) 20%
Objectives
In this course, students will be: 1. guided to outline architecture for a database system, define and manipulate data, and understand the transactions process of database systems 2. provided with knowledge on modern database systems, data warehouses and on-line analytical processing, and the role of database in e-commerce 3. Explain the basic principles IT strategic planning, and the main techniques commonly used in the preparation of IS/IT strategic plans and Projects; By the end of the course, students should be able to: 1. Explain the principles of database management systems 2. Explain data modeling with emphasis on Relational Mode 3. Demonstrate the ability to design databases using E-R Models 4. Explain query processing and familiarize using SQL; 5. Strategic information system planning: what is involved in establishing a planning process 6. Determining the business information systems strategy. 7. Strategic planning for information systems 8. Explain the basic steps in Project Management This course
References: Week 2-5 James Martin, Computer Database Organization, latest ed., Prentice Hall, 2002 Philip J.Prat and Joseph Adamski, The Concepts of Database Management, 2/e International Thomson Publishing Company, 2003 Other Resources Journal of Database Management http://www.idea-group.com/journals/details.asp?id=198 Journal of Information Technology http://www.palgrave-journals.com/jit/ Journal of Intelligent Information System http://www.isse.gmu.edu/JIIS/ Journal of Legal Studies http://www.journals.uchicago.edu/JLS/home.html Journal of Management http://www.journalofmanagement.org/ Journal of Management Information System http://jmis.bentley.edu/toppage/index.html MIS Quarterly http://www.misq.org/index.html