BUSS 212: Business Systems Development B
Department of Information
Systems, University of Wollongong
Lecture content outlines and pointers to web resources:
- Lecture 1: Introduction.
- Lecture 2: We discussed conceptual data modeling using ER diagrams.
This is a pointer to the
homepage of the inventor of ER diagrams. Follow his papers link to see
his original 1976 paper that introduced ER diagrams.
- Lecture 3: We concluded our discussion of conceptual data modeling
and looked at the basics of the relational data model. This is a link to
the original paper by E. F. Codd (this
is the story of his career) in 1970 proposing the relational data
model.
- Lecture 4: We looked at integrity constraints in the relational
model and introduced relational algebra.
- Lecture 5: We discussed relational algebra in detail.
- Lecture 6: We discussed more relational algebra and introduced SQL.
- Lecture 7: We discussed SQL.
- Lecture 8: We continued our discussion of SQL.
- Lecture 9: We discussed the SQL DDL, assertions and triggers.
- Lecture 10: We discussed functional dependencies, their closures and
canonical covers.
- Lecture 11: We discussed relational normalization.
- Lecture 12: We concluded our discussion of relational normalization
and started discussing object-oriented modeling.
- Lecture 13: We concluded our discussion of object-oriented modeling
and UML.
Note that the pointers to relevant web resources provided above
are only for your information and do not constitute part of the formal
subject material.
Classroom Tutorials
- Week 1: No scheduled tutorials.
- Week 2: We discussed a conceptual data modeling example - the
banking application in Chapter 2 of the text.
- Week 3: We discussed some of the mathematical foundations of database
theory, based on a handout available in
postscript form.
- Week 4: We looked at two conceptual data modeling examples:
application 1 and application
2 .
- Week 5: We looked at another
conceptual modeling example and started discussing some
relational algebra examples
- Week 6: We continued discussing the relational algebra example from
week 5.
- Week 7: We looked at more
relational algebra examples
- Week 8: We continued working with the week 7 relational algebra
exercises.
- Week 9: We produced SQL solutions to the week 5 relational algebra
queries.
- Week 10: We worked on the week 7 exercises using SQL.
- Week 11: We did more of the same.
- Week 12: We looked at more SQL and some exercises on functional
dependencies (specifically, excercise 6.15 from the Korth, Silberschatz
and Sudarshan text)
- Week 13: We looked at some exercises involving normalization based on
functional dependencies.
|