DataBase Management Systems (IS 3845)

 

Instructor : Dr. Kailash Joshi

Office : CCB 207

Office Hours: 12.30-2 PM, 4.30 – 5.30 PM Tuesdays

contactmail joshi using umsl dot edu

 

Required Text Books

1. Database Systems by Coronel, Morris, Rob: Course Technology (9th or 10th edition)

2. A Guide to SQL by Philip J. Pratt, Thomson Course Technology (8th Edition).

 

Course Description

INFSYS 3845 Database Management Systems (3)

Prerequisites: INFSYS 2800 and a minimum campus GPA of 2.0. This course provides an introduction to the design and use of databases in meeting business information needs. Topics include database planning, conceptual design, and data administration. The concepts are studied with projects involving the use of a current database management system.

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. The two graded projects involve database design and 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, especially after the solution is presented in the class. 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 on the basis of evaluation of examinations, assignments, and journals. The weights will be assigned as follows:

EVALUATION

Total Points

Examinations - Two

40%

Assignments - Four

50%

Journals - Four

10%

Standard letter grading scale will be used for the course grade.  Any grade indication for midterm is only tentative; the final grade will depend on the overall performance. There would be two exams: Exam 1 and Exam 2, each worth 20% of the course grade, and four assignments each worth 12.5% of the grade. Students are also required to turn in four journals as per the schedule for 10% of the grade. For the dates, please refer to the schedule.  Assignment and Journal requirements are posted on mygateway. Students who miss an examination without prior accommodation may be assigned zero marks.

For course schedule please see mygateway.

 


 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. The power point transparencies for the Rob and Coronel chapters covered and the tentative schedule are available on mygateway.  The slides for the SQL book are included below.

General SCHEDULE (subject to modification)

 

·        Policies about attendance, late work, missed deadlines and tests, make-up opportunities, delayed grades.

 

·          Your success in this course is important to me. Be present in the class and feel free to ask for help. Keep up with the material covered in the class.

 

 

·        Expectations for submitting required work:

 

 

 

·        Academic Honesty:

 

http://www.umsl.edu/services/academic/assets/PDFs/Dishonesty-Rev-9-08.pdf

 

 

 

·        Civility:

 

http://www.umsl.edu/studentlife/dsa/student_planner/policies/positive.html

 

·        Access, Disability, Communication:

 

 

·        Campus Safety

·        All members of the UMSL community are invited to register their cell and office phone numbers to receive notification of any pending danger on campus. Find instructions here:

http://safety.umsl.edu/police/services/3n.html

·        In the event of an emergency on campus, call Campus Police at 314.516.5155.  A call to 911 on a cell phone only, will go to the St. Louis County Police.  The St. Louis County Police will notify UMSL Police, but this may cause a delay in response. Campus Police know the best way to escort emergency vehicles to locations on campus.

·        If you do not feel comfortable walking to a parking lot, MetroLink stop, or anywhere else on campus, contact the Campus Police for an escort: 314.516.5155.