MIS 6326: DATABASE MANAGEMENT SYSTEMS

Spring 2000

Professor: Sumit Sarkar (JO 4.922, Email: sumit@utdallas.edu)

Class Hours:

Sec 501: 5:30-6:45 P.M. Tuesday/Thursday (MP 3.226)

Sec 502: 7:00-9:45 P.M. Tuesday (GR 2.302)

Office Hours: Tuesday 3:00–5:00 PM or By Appointment

TA: Junke Xu (Email: junke@utdallas.edu)

TA Hours: Saturday 1:00–4:00 PM (Assignment Weeks only) or By Appointment

TEXT

Required:

• Database Systems, Peter Rob and Carlos Coronel, Fourth Edition, Course Technology, 2000

Recommended MS Access References:

• Handout
• Other Microsoft Access 2000 references

COURSE OBJECTIVES

The primary objective of this course is to learn to design database applications for business enterprises. Topics include user requirement's analysis, logical database design, physical database design, database query languages, and distributed and client-server databases. The course will emphasize data definition and data manipulation languages for the relational data model. Hands-on experience will be provided using commercial packages.

COURSE REQUIREMENTS

1. Required readings

• Relevant chapters of the text book
• Additional readings handed out in class.

2. Assignments

There will be around 6-8 assignments in this course. These include two cases and a special topic presentation to be done in groups, and other individual written, reading, and programming exercises. The programming assignments will use Microsoft Access and ORACLE. Microsoft Access (Office 2000) is available in the student Microcomputer Lab as well as the School of Management Lab. ORACLE is available in the School of Management Lab. Your UTD ID is required for entry to these labs. Lab hours are posted in the lab.

EXAMINATIONS AND GRADING POLICY

There will be three tests during the semester. The weight for tests, assignments, and class participation are as shown.

• Assignments: 35%
• Test 1: 20%
• Test 2: 20%
• Test 3: 20%
• Class Participation: 5%

Make-up tests will not be allowed without prior permission.

CLASS SCHEDULE