UNIVERSITY OF HAWAII AT MANOA

SHIDLER COLLEGE OF BUSINESS

 ITM 354: Database Management. Spring 2008

 

WEEKLY SCHEDULE                  GRADING                 CONDUCT/POLICIES      

 

INSTRUCTOR:

Dr. Xuefei (Nancy) Deng

Office: SCB Room E601A

Phone: 956-7580

Email: xuefei@hawaii.edu

 

SCHEDULE:

Class: 1:30 pm -2:45 pm, Wed. & Fri.

Classroom: SCB D201

Computer Lab: SCB E102

Office hours: By appointments.

 

COURSE MATERIALS:

 Required Textbook:

 Hoffer, Prescott and McFadden, Modern Database Management, 8th edition, Pearson Prentice-Hall, 2007

Optional Readings:

Michele E. Davis & Jon A. Phillips, Learning PHP and MySQL, O’Reilly, 2006

Articles and case studies will be distributed in class if necessary.

 

 

COURSE DESCRIPTION:

Information is the life blood of modern organizations and most modern organizations depend on database systems to effectively utilize, manage and protect valuable information resources.  Building on ITM352 and ITM353, ITM354 is designed to give you, a future IT professional, working knowledge of the “nuts and bolts” for using, modeling, designing and implementing database systems.  The learning emphasis in this course will be on both database theory and practice, and will focus on strengthening your analytical and independent thinking capabilities as well as communication skills that are essential to a successful IT career.   As the IT field is very complex and is constantly and rapidly changing, the course also aims at cultivating your self-learning capabilities that will allow you to adapt and exploit forthcoming technological advancement.

 

COURSE OBJECTIVES:

  1. To learn state-of-the-art database concepts, theories, techniques, and tools that are directly applicable to an MIS career, including:
    • Database system concepts and system architecture
    • Full life-cycle relational database system development: requirements analysis, conceptual design, logical design, database management system (DBMS) selection, database implementation and physical design, and user-interface/form design
    • Relational database queries: SQL and Query By Example
    • Hands-on practice with tools such as ACCESS and MySQL
    • DBMS functionality and implementation techniques, including transaction processing, concurrency control, recovery control and security
    • Advanced database technology and emerging trends: Web-based databases, Data Warehousing, etc.
  1. To strengthen written  and verbal communication skills
    • Learn to actively participate in  class discussion in a professional manner
    • Practice public presentation skills by presenting ideas and project results
    • Learn to write professional reports as if in the real world
    • Work in groups to practice leadership skills and interpersonal communication skills

 

  1. To enhance  self-learning
    • Develop the habit of reading database magazines, journals and doing research in the library and other resources, such as World Wide Web, as you are required to bring into class discussions current database technology practice and development ideas
    • Learn to extend old knowledge and gain new knowledge on your own by doing challenging problem-solving exercises and extra-credit assignments

Required Software:

Back to the top