MIS415 Business Database Systems
MIS415 Business Database Systems
* Home
* Description
* Overview
* Schedule *
* Projects
* Grades
* Discussions *
The following is a tentative list of topics to be covered in the course. Note that this list is subject to changes. In the case of major changes, an announcement will be made in class, and/or a note posted in the discussion boards. If you want to get an email notification when the content of this page changes, you may sign up using the box provided at the bottom of this page. Note that this is an external service that I do not maintain, so I do not guarantee the accuracy of this service. Use at your own risk. You may simply want to check this page every day as part of a schedule.
CBH: Connolly, Begg, Holowczak, EB: Earp, Bagui, SB: Sara Baase
| Module/ Milestone |
Dates | Topic |
RequiredReadings |
Auxiliary material |
|---|---|---|---|---|
| 0 | Jan 4 | Lect: Intro to course, basics of databases, needs for database use, course website and Pilot. | Course website WSU Pilot website CBH Ch. 1, 4, 5; EB Ch 1 |
[Lec. notes] |
| Lab 1: Database basics - Accessing and handling data for experiments, data cleansing and transforming | Lab 1 Exercises Oracle Apex |
|||
| Quiz1 | Due Jan 11 before class | Survey 1,
Pre-class Quiz 1 |
Module 1a | |
| 1a | Jan 11 | Lect: Data modeling overview - Entity-Relationship Modeling, Advanced ER structures | CBH Ch.6,7, 10 | [Lec. notes] Visio ERD Stencil |
| Lab 2 - Basic Data Modeling | Lab 2 Exercises | |||
| P0 | Due Jan 15 | Group Project Proposal and Team Formation | ||
| Quiz2 | Due Jan 18 |
Pre-class Quiz 2 | Module 1b | |
| 1b | Jan 18 | Lect: Advanced data modeling, normalization, logical and physical models, Model-Schema translation | CBH Ch. 8, 9, EB Ch. 0, 10. Video Example Order Example |
[Lec. notes] |
| Lab 3 - SQL Practice Lab - conducted by GA - Jit at Conference | Lab 3 Exercises | |||
| A1 | Due Jan 22 |
Assignment 1 - available from Pilot | Module 1b | download |
| Quiz3 | Due Jan 25 before class |
Pre-class Quiz 3 | Module 2a | |
| 2a | Jan 25 | Lect: Basics of querying, Calculus, Algebra, Intro to SQL | CBH Ch 3; EB Ch. 2, 4, 6. | [Lec. notes] |
| Lab 4 - Intro SQL Lab | Lab 4 Exercises | |||
| A2 | Due Jan 29 |
Assignment 2 - available from Pilot | Module 1b | download |
| Quiz4 | Due Feb 1 before class |
Pre-class Quiz 4 | Module 2b | |
| 2b | Feb 1 | Lect: Intermediate SQL querying: Subqueries and Grouping | CBH Ap. E; EB Ch. 3, 7, 8. | [Lec. notes] |
| Lab 5 - Intermediate SQL Lab, Midterm review | Lab 5 Exercises | |||
| A3a | Due Feb 5 |
Assignment 3a - Available from Pilot | Module 2 | download |
Exam 1 |
Feb 8 | Mid-term examination (on Modules 1-2b)
|
Module 1-2 | |
| P1 | Due Feb 15 | Group Project Design | ||
| 2c |
Feb 15 |
Lect: Advanced SQL Querying - Non-monotonic queries |
EB Ch. 5, 9 | [Lec. notes] |
| Lab 6 - Advanced SQL Lab | Lab 6 Exercises | |||
| Quiz5 | Due Feb 22 before class |
Pre-class quiz 5 | Module 3a | |
3a |
Feb 22 | Lect: JDBC as a database application middleware JSP as a Dynamic Web Application development language |
CBH Ch 15 JSP Tutorial JSP Documentation from Sun |
[Lect. notes] [JSP/JDBC Sample] [JSP/JDBC Sample with exception handling] [session jsp] |
| Lab 7 - JSP/JDBC Lab | Lab 7 Exercises | |||
| A3b | Due Feb 26 |
Assignment 3b - Available from Pilot | Module 2 | download |
| P2 | Due Feb 28 | Group Project Skeleton | ||
| Quiz6 | Due Feb 29 before class |
Pre-class quiz 6 | SB Ch. 2 only | |
| 3a | Feb 29 |
Lect: Advanced JSP Ethical issues in databases |
CBH Ch. 15 |
|
| Lab 7 - JSP Lab continued/ Project help | Lab 7 Exercises | |||
| Mar 7 | Project work, Final Exam Review | |||
| Lab: Project open house and demo sessions | ||||
| P3 | Due Mar 13 | Group Project - Full Implementation due | ||
| Final | Mar 14 | Final Exam | Comprehensive - Modules 1-3 | |
|
