Transcript Data Modeling using XML Schemas

CS3431 –
Database Systems I
Logistics
Instructor: Murali Mani
[email protected]
Mani-CS3431
1
What will we learn in this
course?

Database Design




Operations for Relational Model



Programming interfaces, Connections
Advanced Database Features


Relational Algebra (fundamental)
SQL: Standard Query Language
Database Application Development


Represent application requirements in conceptual model
(ER, Entity Relationship Model)
Translate an ER schema to relational schema
Analyze ‘goodness’ of schema using normalization theory.
Stored procedures, views, constraints, etc
Brief study of indexes, transactions, logging, security
Mani-CS3431
2
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
Mani-CS3431
3
Course Logistics


Web Page: http://web.cs.wpi.edu/~cs3431/a09
Lectures



M, R: (8:00 am-9:50 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%
Mani-CS3431
4
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

Mani-CS3431
5
Contact and Communication
[email protected]
[email protected]
Mani-CS3431
6
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.
Mani-CS3431
7
H/Ws and Projects

H/Ws due dates announced with assignment


Project will be done in multiple phases




Individual effort (to assure you practice the material)
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.
Mani-CS3431
8
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.
Mani-CS3431
9