Database Design for Business Application (MIS 375)

Fall 2003

Morrill 105, 3:00-4:15 MW, Section 1

South Engineering, 4:30-5:45 MW, Section 2

 

Instructor: Karl Altenburg, PhD

Office: Minard 401D

Telephone: 231-6651

E-mail: karl.altenburg@ndsu.nodak.edu

Office Hours: 1:00-2:00 MTWR, and by appointment.

 

Textbook: Watson RT. 2004. Data Management: Databases and Organizations. 2nd ed. Wiley: New York. 603 p.

 

 

Course Description:  Fundamentals of conceptualizing and implementing databases.  Emphasis is on using query languages to obtain information for decision-making.  Includes managerial topics related to database administration, security, integrity, optimization, and distributed databases.

Pre-requisite: MIS 370, CSci 228.

Course Objectives:  1) to understand the use and management of data in organizations, 2) To develop a practical understanding of the design of relational databases, 3) to develop experience in the use of database manipulation using SQL and other query mechanisms, 4) to apply database design and implementation skills in course projects.

Grading: Grading is based on the 90-80-70% grading system.

Evaluation: The emphasis of the course is practical in nature and evaluation will reflect this emphasis.  Group and individual projects will contribute significantly to evaluation.  However, individual progress will also be evaluated through 3 exams.  Presentations, quizzes, and homework may also be used for evaluation.  A tentative breakdown of evaluation is as follows:

Exams (2)

100 pts * 2 = 200 pts

20%

Final Exam

150 pts

15%

Larger Projects

350 pts

35%

Smaller projects,

homework, quizzes

and other assignments

300 pts

30%

 

 

Note: Any students with disabilities or other special needs who need special accommodations in this course are invited to share these concerns or requests with the instructor as soon as possible.

Academic honesty statement: All work in this course must be completed in a manner consistent with NDSU University Senate Policy, Section 335: Code of Academic Responsibility and Conduct (http://www.ndsu.nodak.edu/policy/335.htm).