DataBase Management Systems (IS 6845)

Instructor: Dr. Kailash Joshi

Office: CCB 207

Office Hours: 4.45 PM to 5.30 PM; TR, or by arrangement

e-mail: joshi@umsl.edu

Telephone : 314-516-6123

Required Text Books

1. Modern Database Management by Hoffer, Prescott, McFadden: Pearson Prentice Hall (9th edition)

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

Course Description

INFSYS 6845 Database Management Systems (3)
Prerequisite: INFSYS 5800. The course introduces the concepts of database management systems for business applications. Issues in database architecture, design, administration, and implementation are covered. Projects are assigned on a mainframe DBMS and a microcomputer-based DBMS to illustrate the concepts and applications.

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 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%

 Standard grading scale for letter grade will be used for the course grade. Any grade indication for midterm is only tentative, final grad will depend on total performance.

The midterm exam will be held in the 9^th week or thereafter. The date will be announced in the class with 9/10 days advance notice. For final exam dates please look up campus examination schedule.

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.

---

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:

Hoffer Book's Web Site

Pratt Book's PPT Slides

Creating Pine Valley Furniture Company DB

Power point slides for Hoffer chapters

SCHEDULE (Subject to change)

· 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.

• Late papers will not be accepted. AFTER a solution is presented in the class only a zero may be assigned. Delayed grades will not be assigned. Please speak with me to resolve problems you encounter early on.
• Class attendance and participation is essential for success. When you are absent, it is your responsibility to clarify missed assignments with classmates or with me prior to the next class.
• If you expect to miss class to participate in a university-sanctioned activity, be sure to submit a Student Absence Form or Athlete Travel Letter early in the semester so that we can discuss your responsibilities and make plans to fulfill the requirements of the classes you will miss.
• Requests for exceptions to these policies must be discussed with me in advance.

· Expectations for submitting required work:

• Submitted work will be typed, double-spaced and submitted in print, no emails or electronic submissions will be accepted.
• Written work must adhere to the style of the discipline: MLA, APA, Chicago Style, where relevant.
• Written work will be evaluated for composition and grammar. Be sure to run your essays through SafeAssign and, revise when necessary, before submitting them.

· Academic Honesty:

• Plagiarism is the use of another person’s words or ideas without crediting that person. Plagiarism and cheating will not be tolerated and may lead to failure on an assignment, in the class, and dismissal from the University. View this campus policy here:

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

Elements of a Syllabus (continued)

• You are responsible for being attentive to and observant of campus policies about academic honesty as stated in the University’s Student Conduct Code: http://www.umsl.edu/~webdev/bulletin/student-conduct.html

• To avoid accusations of academic dishonesty, please submit all written work to the SafeAssign System before finalizing what you submit for evaluation. Check information about the The Writing Lab @UMSL that is linked to MyGateway Home.

· Civility:

• Turn off beepers and cell phones during class. Adherence to the Student Conduct Code is expected.
• My commitment is to create a climate for learning characterized by intellectual diversity and a respect for each other and the contributions each person makes to class. I ask that you make a similar commitment.
• I am committed to insuring a positive learning environment by respecting that University policy:

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

· Access, Disability, Communication:

• Students requiring special accommodations should meet with me during office hours so that we can discuss how to meet your needs this semester. Prior to our meeting be sure you have met with someone in Disability Access Services (MSC 144).

· 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.

The Center for Teaching and Learning’s website includes sample statements of civility, academic honesty, and disability access. These are available for faculty to adapt at: http://www.umsl.edu/services/ctl/instr_support/tchng_res.html .

Some departments expect all syllabi to include standard statements of these policies in each course syllabus. Be certain to check whether this is the case in your program.