Previous Weeks in the Database
Course
This file will contain the week-to-week reading and lecture
schedules. At the end of the week the "this week" will be
modified to reflect what actually happened and will be appended to
this file.
Week 1: Monday, January 19
- Topics:
- Reading:
- PowerPoint Slides
Monday:
- Martin Luther King day (no classes)
Wednesday:
- Introduction to the course
Thursday:
- Basic definitions and ideas
Friday:
- Basic definitions and ideas
Other Notes:
Week 2: Monday, January 26
- Topics:
- File Organizations and access methods
- Database models
- Reading:
- Date, chapter 3
- Sunderraman, chapter 1
Monday:
- A survey of file organizations and access methods
Wednesday:
- What a data model is
- Pre-relational database models
Thursday:
- The relational data model
Friday:
- Relational Algebra (a second look)
- An introduction to SQL
Other Notes:
Week 3: Monday, February 2
- Topics:
- Introduction to Oracle
- Introduction to SQL
- Reading:
- Date, chapter 3, 4
- Sunderraman, chapter 2
Monday:
Wednesday:
- Introduction to SQL
- First SQL exercise
Thursday:
- More on SQL
- Create/drop table
- Insert
- Update
- Delete
Friday:
Other Notes:
Week 4: Monday, February 9
- Topics:
- Introduction to top-down design with entity-relationship diagrams
- Reading:
- Date, chapter 14
- Sunderraman, chapter 2
Monday:
- Entity-relationship diagrams
- Moving from an entity-relationship diagram to a relational schema
Wednesday:
- Introduction to the group project
Thursday:
Friday:
- Small-group exercise on entity-relationship diagramming
Other Notes:
- The first hour exam will be next week.
Week 5: Monday, February 16
- Topics:
- Reading:
- Date, chapter 10
- Sunderraman, chapter 2
Monday:
Wednesday:
- Views and indexes
- More on the group project
- Review for exam #1
Thursday:
Friday:
Other Notes:
- The first hour exam will be Friday, February 20.
- Monday, February 16 is the last day to withdraw with an automatic "W".
- Group work days started last week. The class will generally not meet
on Thursdays to provide time for groups to meet. I will be in my office
for office hours, with preference given to groups that want to meet with me.
Please note: please do not make other arrangements for Thursdays
as we may need the time for lectures.
- We will move on to bottom-up design next week and leave the discussion on
reports to the following week.
Week 6: Monday, February 23
- Topics:
- The data dictionary
- Bottom-up design and data normalization
- Forms and reports
- Reading:
Monday:
Wednesday:
- Discussion on the loader
- Preliminary discussion on data normalization (using universal.dat for
examples)
Thursday:
Friday:
- Project proposals due Friday, February 27. Please note change
in date.
- Exercise #3 will be due Friday as well (instead of Wednesday)
- The Data Dictionary
- There will be an in-class small group project in forms based design,
probably on next Wednesday.
Other Notes:
Week 7: Monday, March 1
Dydd Dewi Sant yn hapus iawn i bawb!
- Topics:
- Bottom-up design and data normalization
- Reading:
Monday:
- Forms Based Bottom-up design
Wednesday:
- No class (medical appointment)
Thursday:
Friday:
- An in-class small group exercise on bottom-up design
Other Notes:
- Requirements document for the term project is due next Monday.
Week 8: Monday, March 8
Monday:
- No class (medical appointment)
Wednesday:
Thursday:
Friday:
Other Notes:
- Next week is Spring Break!
- Friday, March 12 is Mid-Term
- The second hour exam will be Friday, March 26.
- The ongoing bottom-up design exercise will be due some time in the week following our return from Spring break.
Week 9: Monday, March 15
- Topics:
- Spring Break! (no classes or office hours)
Week 10: Monday, March 22
- Topics:
- Resolving top-down and bottom-up design
- Advanced SQL
- Reading:
- Date, chapters 11, 12
- Sunerraman, chapter 2
Monday:
- Resolving top-down and bottom-up design
Wednesday:
- Advanced SQL
- Review for Exam #2
Thursday:
Friday:
Other Notes:
- The preliminary design document will be due Friday, April 2
- The bottom-up (group) design exercise is also due that Friday. I may change the due-date on one or the other (to a later date, of course) [Later]: The due-date of the preliminary design document was changed to the following Wednesday
Week 11: Monday, March 29
Monday:
- Exam returned and discussed
Wednesday:
Thursday:
Friday:
- Advanced SQL (Forall queries)
- The due-date for the preliminary design document has been changed to Wednesday, April 7
- Bottom-up design exercise due
Other Notes:
Week 12: Monday, April 5
- Topics:
- Tools: UML, Reports, and Forms
- Advanced SQL
- PL/SQL
- Reading:
- Sunderraman, Chapters 3, 4
- Oracle documentation on forms and reports
Monday:
- UML Modeling with Rational Rose and Visio (it turns out that Visio has all
the tools we need for modeling)
Wednesday:
- Introduction to Oracle tools:
- The report writer
Thursday:
Friday
Other Notes:
- The full design document will be due Wednesday, April 21 (please note change in due date)
- Because of several meetings this week, office hours need to be re-arranged as follows:
- Monday: 10:00 AM
- Wednesday: 10:00 AM
- Thursday: 4:00 PM
- Tuesday (11:00) and Friday (4:00) as usual
Week 13: Monday, April 12
- Topics:
- Reading:
- Sunderraman, Chapters 3, 4
Monday:
Wednesday:
- Discussion of SQL exercise set
- Exercise #5 due (in class)
- Exercise #6 assigned (review only)
Thursday:
Friday:
- PL/SQL and forms: Two demos
- A demo on JAVA JDBC
- Please note that the full design document is not due until next Wednesday.
- There will be a final exercise assigned next week on the relational algebra. As with the aggregation/group by/having exercise, it will be for review only.
Other Notes:
- The design document will be due Wednesday, April 21 (please note change in due date)
- The third hour exam will be Wednesday, April 28. Please note the correction in the date - the original lecture schedule had this scheduled for a Tuesday.
- Presentations will begin on Monday, May 3. A schedule will be out shortly.
Week 14: Monday, April 19
- Topics:
- Reading:
- Sunderraman, Chapters 3, 4
- Date chapter 7
Monday:
Wednesday:
- No class - instructor ill
- Full design document due. I will collect these this coming Monday.
Thursday:
Friday:
- University President Inauguration - no classes or office hours
Other Notes:
- The design document will be due Wednesday, April 21 (please note change in due date)
- The third hour exam will be Wednesday, April 28. Please note the correction in the date - the original lecture schedule had this scheduled for a Tuesday.
- Presentations will begin Monday, May 3. A schedule will be out next week.
Return to Class Home Page