CS3431

1
CS3431 Database Systems I

• Logistics
• Instructor Murali Mani
• mmani_at_cs.wpi.edu

2
What will we learn in this course?

• Database Design
• Represent application requirements in conceptual
  model (ER, Entity Relationship Model)
• Translate an ER schema to relational schema
• Analyze goodness of schema using normalization
  theory.
• Operations for Relational Model
• Relational Algebra (fundamental)
• SQL Standard Query Language
• Database Application Development
• Programming interfaces, Connections
• Advanced Database Features
• Stored procedures, views, constraints, etc
• Brief study of indexes, transactions, logging,
  security

3
Textbook

• First Course in Database Systems, Jeffrey D.
  Ullman and Jennifer D. Widom, Prentice Hall. 3rd
  Edition
• Database Systems The Complete Book
• Hector Garcia-Molina, Jeffrey D. Ullman and
  Jennifer D. Widom
  Prentice Hall, 2nd Edition
• Oracle9i Programming A Primer, (or, 10g)
  Rajshekhar Sunderraman, Addison-Wesley

4
Course Logistics

• Web Page http//web.cs.wpi.edu/cs3431/a09
• Lectures
• M, R (800 am-950 am)
• Lectures, discussion of examples, projects, H/Ws
• Grading
• H/W assignments (4 or 5) 10
• Projects (in 3 phases) 25
• Exams mid term (Sep 24) final (Oct 15) 60
• Class participation 5

5
Course Management

• http//www.cs.wpi.edu/cs3431/a09
• lecture overheads
• homework assignments
• project due dates
• any other handouts/material
• on mywpi (limited)
• discussion boards (discuss among fellow
  students)
• viewing of grades

6
Contact and Communication

• cs3431-staff_at_cs.wpi.edu
• cs3431-all_at_cs.wpi.edu

7
Office Hours

• Are posted on the course web page.
• Make use of them they are there for YOU !
• May schedule additional office hours, if need
  arises and you ask for them.

8
H/Ws and Projects

• H/Ws due dates announced with assignment
• Individual effort (to assure you practice the
  material)
• Project will be done in multiple phases
• Team effort (to collaborate to produce quality).
• A full cycle from project idea, design,
  development to final polished project
  presentation !
• Multiple phases to get our feedback and to pace
  yourself!
• Late submissions
• Grades for late submissions will not count.
  However we will be happy to correct them and give
  feedback, if you ask us to.

9
Tips for doing well

• Exams
• Master the topics (reading, attend lectures,
  homework)
• Master the topics on time
• Project
• Ensure that you are on schedule
• Teamwork counts
• Additional investigations can get additional
  points.