DataBase Management Systems (IS 3845)
Instructor : Dr.
Kailash Joshi
Office : CCB 215
Office Hours: 5.00 PM
to 6.00 PM; TR
e-mail: joshi@umsl.edu
Telephone : 516 - 6123
Required TextBooks
1. Modern Database Management by
Hoffer, Prescott, McFadden: Pearson Prentice Hall (8th edition)
2. Oracle SQL by Bordoloi, Bock,
Pearson Prentice Hall (latest edition).
Course Description
This course introduces the concepts of
database management for business applications. The course covers issues in
Database Architecture, Database Design, and Implementation. With increasing
emphasis on building integrated systems based on unified information
architecture, information modeling and database development have emerged as the
most important activities in information systems development. Database modeling
has also become the central unifying activity in all contemporary systems
analysis and design methodologies.
Besides fundamentals of database systems and data modeling, students
will also learn SQL to access databases on an Oracle platform.
Projects
In additions to the course work,
students will carry out various projects. Two projects involve conceptual
database design. Other projects involve setting up a database and using SQL
query facility in an Oracle DBMS environment. The use of packages is designed
to illustrate the concepts discussed in the text book. Due dates for each
project will be announced in the class. There will be a penalty of up to 100%
for late submission. Students are required to work in groups for some project
assignments.
Grading
The final grade will be based on the
weighted average of marks obtained in various exams and assignments. The
weights will be assigned as follows:
|
Exams |
70% |
|
Assignments |
20% |
|
In class participation and performance |
10% |
The class will use problem based
learning (PBL) approach. Students should read the assigned chapters in advance
and be prepared to participate actively in the class. There would also be
in-class quizzes. The power point transparencies for the chapters covered and
the approximate schedule are available on the following links:
Powerpoint
slides for Hoffer chapters
There would be two exams, each worth 35% of the course grade. Course
schedule and assignments are announced in the class. Be there! Students who
miss an examination will be automatically assigned zero marks.