CALIFORNIA STATE UNIVERSITY - NORTHRIDGE
Department of Accounting & Information Systems

IS 441 : DATABASE MANAGEMENT SYSTEMS

Spring 2004 Semester


Instructor:                   Dr. DAT-DAO NGUYEN
Office:                          BB3221
Office Hours:              Tuesday and Thursday from 12:30 to 14:00
                                     Wednesday from 18:00 to 18:30
                                     or by appointment.
e-mail:                          datdao.nguyen@csun.edu
Web page:                  http://www.csun.edu/~dn58412/


SCHEDULE OF CLASS MEETINGS

       Ticket Number          Time                     Location
          12674           T&TH 11:00 - 12:15           BB 2228

COURSE DESCRIPTION

Any organization, regardless of its size and mission, needs information to make operational, tactical, and strategic decisions. At the same time, business activities generate an abundant amount of raw facts to be kept for and interpreted in future decision making activities. Information systems have been implemented to assist decision makers / information users at any level to record, maintain and process related raw data into useful information. It is apparent that the core of any information system is an effective/efficient database. 

This course provides students with necessary analytical/technical background for selection and use of database management systems.  Topics include the managerial environment of a business database and functions of database administration, conceptual database design for an effective and efficient database. Then students will use SQL (Structured Query Language) - a database related programming language - to implement a relational database,  process various database management functions and queries.  A group project requires students using MS Access to design and implement a database for a business function of a real business entity.

After completing the course, students should be able to communicate with business users, analyze their data requirements and design/implement appropriate databases within the framework of information development to support the information need in business decision making.

REQUIRED TEXTBOOK

- Hoffer, Prescott, and McFadden (2002), Modern Database Management, 6th Edition. Prentice Hall (This is a classic DB Management book. It has instructed many generations of undergraduate/graduate students in business database management.) 

- Textbook Webpage (A source for study guide and self tests to reinforce your learning.)

 

RECOMMENDED READING

- Patrick (2002), SQL Fundamentals, 2nd Edition. Prentice Hall. (This is a "SQL Playbook" that you may want to consult in the SQL programming part of the course. It covers SQL for Oracle and MS Access).

COMPUTER FACILITIES

Computer labs for the College of Business are located in BB2125 and BB2129. Hours of operation are posted outside BB2129.

GROUP PROJECT

There is a group project on database design and implementation that requires active participation of students in a team of 3 (three) members.  Specific requirements (and expectations) for the project will be discussed in class. At the end of the semester, each group will submit a detail report and present their work in class.

- Group Project Specifications
- Peer Evaluation Form

GRADING

- Mark Distribution:

      Homework Assignments
              ERD Modeling          5%
              Normalization         5%
              SQL Programming       5%

           Project                 15%
           
           Midterm Exam            30%
           Final Exam              40%

- Homework Assignments:  There are 3 assignments covering major techniques in database modeling and programming. All homework assignments are  to be done individually.  You may consult with your colleagues on the assignments but you should have your own answer and submit your own work. Refer to Academic Regulations prescribed in University 2002-2004 Catalog cited in the following section. As graded assignments will be given back in the next class meeting, late assignments will not be accepted.

- Project:  You should participate equally and actively in group work.  The individual credit for group project will be based on peer evaluation of individual contribution to the group work.

- Exams: The exams will cover the chapters listed on the following schedule, the material discussed in class lectures, and the homework problems assigned during the Semester.

- Final Grade: The final grade distribution is based on the following scale: A (93-100), A- (90-92), B+ (87-89), B (83-86), B- (80-82), C+ (77-79), C (73-76), C- (70-72), D+ (67-69), D(60-66), F (0-59).

COURSE SCHEDULE

WEEK OF TOPICS READINGS
(HofferText)
HOMEWORKS*
       2/02  DB DEVELOPMENT
      DB Environment
  Ch.1
  Lecture Note 1
 
       2/09       DB Development Process   Ch.2
  Lecture Note 2
Review/Preview
of Systems Development Process
       2/16  DB ANALYSIS AND MODELING
      Data Modeling with ERD
  Ch.3, 4 & App.A
  Lecture Note 3
Hands-on Practice:
Problem Set in Lecture 3
       2/23                          ''          "  
       3/01  DB DESIGN
      Relational Data Model    
  Ch.5
  Lecture Note 4
Hands-on Practice:
Problem Set in Lecture 4
       3/08                          "    Assignment 1
       3/15       Normalization   Ch.5 & App.B 
  Lecture Note 5
Hands-on Practice:
Problem Set for Lecture 5  
DOC 1, DOC 2, DOC3,
DOC 4, DOC5, DOC6
       3/22                           "           "  
       3/29       Physical DB Design   Ch.6
  Lecture Note 6
Assignment 2  
    MIDTERM EXAM  (Lectures 1 to 5)
       4/05   SPRING RECESS (No Classes)
       4/12 DB IMPLEMENTATION   
     SQL Programming
  Ch 7, 8
  Lecture Note 7
   SQL Repertoire  
BrokerHouse.mdb
SQL Play List 1
SQL Play List 2  
       4/19      SQL Lab   Hands-on SQL Play List 3  
       4/26      SQL Lab   Hands-on Production.mdb
SQL Play List 4
SalesOrders.mdb
SQL Play List 5
SalesOrder Play List 5
       5/03      Data and DB Administration   Ch.12
  Lecture Note 8  
 Assignment 3 ZIP
 Supplemental Play List AS3
       5/10 ADVANCED TOPICS
     Client/Server and Distributed DB
  Ch.9, 13
  Lecture Note 9
 
       5/17      Object-Oriented Data Modeling   Ch.14
  Lecture Note 10
 Project Due
      5/24 FINAL EXAM WEEK

* To be posted during the Semester

ACADEMIC REGULATIONS

Students are reminded of the importance of reading and understanding the full content of the academic regulations in the University 2002-2004 Catalog on Academic Dishonesty. Any form of academic dishonesty will result in a grade of F for the course and could lead to suspension or even expulsion from the University. This is non-negotiable and no second chance will be given.


BULLETIN BOARD
(Students should check this bulletin board regularly for updated class information)

 Lecture notes (overheads) will be posted on this page. It is preferable to read them before attending class.

HOMEWORK ASSIGNMENTS SENT TO MY E-MAIL ACCOUNT WILL NOT BE CONSIDERED FOR GRADE.  (We are not in Virtual University yet !!!)

REVIEW / PREVIEW OF SYSTEMS DEVELOPMENT PROCESS
- System Development Environment
- System Development Process

SITE LICENSE SOFTWARE FOR CSUN-IS STUDENTS: Where you can get Visio, Project, Visual Studio, Windows XP at costs from Microsoft Developer Network (MSDN) Academic Alliance between Microsoft and our Accounting& IS Department: Click here !!!

FINAL EXAM:  (Ref: SPRING 2004 Schedule page 145)

  Ticket Number       Class Time                            Exam Schedule                                                        Location
     12674                   T&TH 11:00 - 12:15              THURSDAY         5/27/04       10:15-12:15            BB 2228
The final exam will cover the material from Lectures 5 to 10. 
The theoretical/conceptual part has a set of multiple choice questions. 
The technical part includes Normalization and SQL Programming .

(Posted 5/17/04)