DataBase Management Systems (IS 3845)
Instructor : Dr. Kailash Joshi
Office : ESH 207
contactmail joshi using umsl dot edu
Please refer to Canvas for office hours and class schedule and Myview for class room and timing
Required Text Books
1. Database Systems by Coronel, Morris, Rob: Course Technology (10th or 11th or 12th edition)
2. A Guide to SQL by Philip J. Pratt, Thomson Course Technology (9th Edition).
INFSYS 3845 Database Management Systems (3)
Prerequisites: Please refer the course catalog. 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. Concepts of functions, procedures, triggers, cursers, and PL/SQL programming language are also briefly reviewed.
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 many assignments.
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:
Tests - Two
Assignments - Six
Journals - Two
Standard letter grading scale will be used for the course grade.† Any grade indication for midterm is only tentative; final grade will depend on the overall performance. There would be two tests: Test 1 and Test 2, each worth 20% of the course grade, and five assignments each worth 10% of the grade. Students are also required to turn in two journals as per the schedule for 5% of the grade each. For the due dates, please refer to the schedule.† Assignment and Journal requirements are posted on my gateway. Students who miss an examination without prior accommodation may be assigned zero marks. Late submissions of assignments and journals also get zero marks -- as we generally discuss the solution on the due date. Any missing assignment/journal grades should be discussed with the instructor when the graded assignments are returned, or up to one week after that.† It is not possible to discuss or review missing grades at the end of the semester or when the final grades are turned in.
All examinations are closed book and closed to any study aids.
For the 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 Coronel & Rob and Pratt book chapters covered are available on mygateway.†
∑ 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:
∑ 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:
∑ 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.