CSE 3330/5330 Database Systems (Spring 2008)
Sharma Chakravarthy
I am teaching CSE 5336 in Fall 2008; see mymav or my course web site www2.uta.edu/sharma for details
THE TA HAS OFFICE HOURS FROM 11A.M TO 1P.M ON TUESDAYS AND THURSDAYS IN NH 239
I have updated all the slides on the web!
The FINAL EXAM (Comprehensive) is scheduled on Monday, May 5th 2008 from 11 to 1:30pm in Rm NH 229. The OS final exam has been moved to a different time.
REMEMBER: it constitutes 25% of overall grade!
The following are included for the final exam:
from module III:
file structures, indexing alternatives, how indexing is efficient
query processing: alternative approaches for join and their differences, why qo is required, logical operators and physical operators/algorithms
Normalization: anomalies, 1, 2, and 3rd normal forms, identifying whether a relation is in a particular normal form and its decomposition
relational algebra and sql (module II)
ER modeling, mapping, and general DBMS architecture and related stuff (Module I)
Good luck,
Syllabus (pdf) revised on 05/06/2008
Course Introduction (4perpage)
project details and deliverables (pdf) (read it carefully) 05/06/2008
Suggestions for project topics (pdf)
Example Project Problem Statement (Due on 1/29/2007)
Example EER Diagram (Due on 2/19/2007)
Example Normalized Schema (Due on 3/07/2007)
Demo Slot Sheet Demo Slots: SIGN-UP
(Please look for the availability and send an email to the TA for Slot reservation)
Distance students may mail the TA with their slot choice.They may then conduct their demo over the phone with the TA incase they are not able to come in physically for the demo
- Homework1:- Draw the EER diagram for the problem statements given.
Solutions: sports_DB_ER.pdf (05/06/2008) musicstore_ER.pdf (05/06/2008)
- Homework2:- translate the English queries into RA and SQL; test your SQL on the database to make sure you get the right results!
solutions to 4.16 and 8.13 (in pdf )
(The tables for this homework are created in Dr. Sharma's Oracle schema in omega and populated with the sample data. You can log into your Oracle account and use SHARMAC.tablename to reference a table.)
http://www.uta.edu/library/internet/computer.html
http://www.uta.edu/library/research/rt-cse.html
http://www.uta.edu/library/reserach/db-cse.html
Last Updated: 05/06/08