| Class # | Date | Topics; Objectives | Supporting Resources | Professor's Responsilities: Class Activities | Students' Responsibilities: Pre-Class and Class Period |
Students' Responsibilities: Assignments and Tests |
| 1 | 30-Aug | Course Introduction; Prerequisites; Begin "Context of Database Management: the Database Environment"; Present Demo of a "Modern Database Application" |
Syllabus; Website; Windows; File Management w. Explorer; Database Use with Access; Email/Attach; Start-Up Files; PowerPoint Slides; Handout; Demo Application |
Present Syllabus and Course Overview; Review Prerequisite Requirements; Demo a Sample "Modern Database Application"; Present First Lecture: "The Database Environment" |
Verify your A. B. Freeman computing system account and log onto the system; Study Course WebSite, esp. Syllabus, Assignments, Tests and Calendar; Review Windows, Explorer, Access, and Email/Attach; Make Folder and Copy/Obtain Copy of 2 Start-Up Database ApplicationFiles; Establish Own Back- Up Procedures; Complete Class Exercise |
See technical staff if you have problems logging onto the system; Class Exercise: Provide Self Descriptive Info using "Mydata" Database Application you downloaded, and Email/Attach it to your Professor; Practice Own Backup Procedures; Obtain Textbook: McFadden, Hoffer, Prescott (MHP) |
| 2 | 4-Sep | Conclude Course Overview; Conclude "The Database Environment" Study Questions at end of Chapter 1 |
McFadden, Hoffer, Prescott (MHP) Chapter 1; PowerPoint Slides, Handout | Lecture, Slides, Handout | Finish Reading Chapter 1, using Study Questions at the end of the chapter as your guide; Finish and Send the Class Exercise (Access Database Application and Email using Attach When Completed); Due Before Class Starts |
Complete Class Exercise, if not already done (see Class 1); Practice Own Backup Procedures |
| 3 | 6-Sep | "Database Development Process"; Projected: Planning Phase of Database Development Process. Defining Business Vision, Goals, Project Scope, Functions, Need/Problem, General Data Areas | MHP, Chapter 2; PowerPoint Slides; Handout | Lecture/Presentation with PowerPoint Slides | Finish Reading MHP, Chapter 2 | Class Exercise: Company Background for Pre-Planning; Practice Own Backup Procedures |
| 4 | 11-Sep | (Lost Class Day Due to Terrorist Attacks) | - | - | Begin Reading MHP, Chapter 3; reflect on three businesses/organizations and their database needs | Begin Assignment 1 |
| 5 | 13-Sep | Conclude: "The Database Development Process" | PowerPoint Slides; Handout | Lecture/Presentation with PowerPoint Slides | MHP, Chapter 3; actively follow procedures for E/R Diagramming | - |
| 6 | 18-Sep | Data Analysis and Design/Modeling: Entities, Attributes | Slides, Examples | Demonstration: Entities, Attributes | Chapter 3 | Assignment 1 Due at 1:00 P.M. |
| 7 | 20-Sep | Data Analysis and Design/Modeling: Relationships | Slides, Examples | Demonstration of Start-up Technique: Functions and Entities | Chapter 3 | Assignment 1 Due at 1:00 P.M. -- Extension Due to Terrorist Attack. Student is responsible for all class events and objects, if attending Freeman Days in New York |
| 8 | 25-Sep | Data Analysis and Design/Modeling: Cardinality | Slides, Examples | T.B.A. | Finish Reading Chapter 3 | Form Groups, Begin Work on Assignment 2 |
| 9 | 2-Oct | Projected: Use of Computerized Tools in Data Analysis and Design: Visio, Edge, Oracle Designer | Slides, Examples | T.B.A. | Follow the demo; begin reading MHP, Chapter 4 | Work on Assignment 2 |
| 10 | 4-Oct | Projected: More Data Analysis and Modeling: Supertypes, Subtypes, Business Rules, Constraints | Slides, Examples | T.B.A. | Finish Reading MHP, Chapter 4 | Class Exercise: Submit E/R Diagram; Work on Assignment 2 |
| 11 | 9-Oct | Projected: Advanced Analysis and Modeling: Object-Oriented and UML | Slides, Examples | T.B.A. | Read Chapter 5, MHP | - |
| 12 | 11-Oct | Projected: Access as a Logical Application Modeling Tool: Planning User Interfaces | Slides, Examples | T.B.A. | Begin reading MHP, Chapter 6 | Assignment 2 Due at 1:00 P.M. |
| 13 | 16-Oct | Projected: Logical Design: Relational Model, Relations | Slides, Examples | NOTE: I will be out of town, October 12 through 15. | Finish reading MHP. Chapter 6 | Study for Test 1 |
| 14 | 18-Oct | Test 1: Stated at start of Chapters 1 through 6. | Test 1: Text, Chapters 1 through 6, and supporting slides and handouts | Test 1: Prepare test on Chapters 1 through 6; primarily short answer and fill in the blank; few multiple choice | Test 1: Answer and study all "review questions" at end of Chapters 1 through 6 | Test 1: Chapters 1 through 6 |
| --------- | ------------- | --------------------- | ------------------ | ------------------- | --------------------- | ------------------ |
| 15 | 23-Oct | Normalization; Physical Design Using Access 2000 | Slides, Exercise | Follow Exercise in Access: Build Tables | MHP, Chapter 7 | T.B.A. |
| 16 | 25-Oct | Projected: More Physical Design; Oracle | More Access | T.B.A. | T.B.A. | Assignment 3 Due at 1:00 P.M. |
| 17 | 30-Oct | Projected: More Access or Oracle | T.B.A. | T.B.A. | T.B.A. | T.B.A. |
| 18 | 1-Nov | Projected: More Access | Tutorial | T.B.A. | T.B.A. | T.B.A. |
| 19 | 6-Nov | Projected: More Access | T.B.A. | T.B.A. | T.B.A. | T.B.A. |
| 20 | 8-Nov | Projected: Client/Server and Middeleware | T.B.A. | T.B.A. | MHP, Chapter 8 | T.B.A. |
| 21 | 13-Nov | Projected: SQL and Oracle | T.B.A. | T.B.A. | MHP, Chapter 9 | Assignment 4 Due at 1:00 P.M. |
| 22 | 15-Nov | Projected: Database Access from Client Applications | T.B.A. | T.B.A. | MHP, Chapter 10 | T.B.A. |
| 23 | 20-Nov | Projected: Distributed Databases | T.B.A. | T.B.A. | MHP, Chapter 11 | T.B.A. |
| 24 | 27-Nov | Projected: O-O Databases and Development | T.B.A. | T.B.A. | MHP, Chapter 12 | T.B.A. |
| 25 | 29-Nov | Projected: Data Administration and the DBA | T.B.A. | T.B.A. | MHP, Chapter 13 | Student is responsible for all class events and objects, if attending Freeman Days in Houston |
| 26 | 4-Dec | Projected: Data Warehousing | T.B.A. | T.B.A. | MHP, Chapter 14 | T.B.A. |
| 27 | 6-Dec | Test 2 | Test 2 | Test 2 | Test 2 | Test 2 -- Comprehensive (Planned) |
| --------- | ------------- | --------------------- | ------------------ | ------------------- | --------------------- | ------------------ |
| December 12th at 12:00 noon and at 6:00 P.M. | Project & Presentations | Project & Presentations | Project & Presentations | Project & Presentations | Project & Presentations | Project (Assignment 5) due at 12:00 noon. Presentations at 6:00 P.M. |
Overview & Objectives | Full Syllabus & Grading | Calendar
Text & Other Resources | Assignments | Tests & Exams
Caveat: All Course Components Are Subject to Change
Warren E. Duclos, Jr. | A.B. Freeman School of Business | Tulane University
Unless otherwise noted, all material is:
Copyright © 1997, 1998, 1999, 2000, 2001 The A. B. Freeman School of Business at Tulane University.
All rights reserved.
Fax: (504) 865-5562