Lecture handouts and example java code for the "The Internet Database Environment" lecture are available in the Lecture Handouts section.

Final exam will be held in classroom on Wednesday, December 13, 2006, 6:00 to 8:00 pm.

Example script files used in the lecture for "Advanced SQL" lab are available in the Lecture Handouts section.

Phase 4 (Extra-credit) assignment of the class project has been posted in the Assignments section. The deadline for handing in this project phase is December 12, 2006.

Lecture

Date

Subject

1

 Aug 30, 2006

 The Database Environment  (pdf: 2/page or 6/page)

2

 Sep 6, 2006

 The Database Development Process  (pdf: 2/page or 6/page)

3

 Sep 13, 2006

 Modeling Data in the Organization  (pdf: 2/page or 6/page)

4

 Sep 20, 2006

 The Enhanced ER Model and Business Rules  (pdf: 2/page or 6/page)

5

 Sep 27, 2006

 Logical Database Design and the Relational Model  (pdf: 2/page or 6/page)

6

 Oct 4, 2006

 Logical Database Design and the Relational Model  (pdf: 2/page or 6/page)

7

 Oct 11, 2006

 Physical Database Design and Performance (pdf: 2/page or 6/page)

8

 Oct 17, 2006

 Midterm Exam

9

 Oct 25, 2006

 Midterm Exam (Solutions and Grades)

10

 Nov 1, 2006

 Mountain View Community Hospital sample EER model

11

 Nov 8, 2006

 Advanced SQL (pdf: 2/page or 6/page)

12

 Nov 29, 2006

 Advanced SQL (Example script files)

13

 Dec 6, 2006

 (Example java ODBC code)

 

	Develop a detailed Enhanced Entity-Relationship (EER) diagram and business rules for the Mountain View Community Hospital case study described after chapters 1-4.
	The developed model should constitute the answer to project assignments P1, P2, and P3 described on page 183 of the textbook after chapter 4.
	Your design should include the EER model specifications should follow the level of details explained in chapter 4.
	It is recommended that you use a data model design tool like Microsoft Visio to design and document your EER model.
	This is an individual project.
	Deadline: October 4, 2006.

 

	Develop a detailed relational schema for the Mountain View Community Hospital case study as described after chapter 5.
	All relations in your design should at least be in 3rd normal form (3NF).
	The developed relational schema should constitute the answer to project assignments P1, P2, and P4 described on page 238 of the textbook after chapter 5.
	It is recommended that you use a data model design tool like Microsoft Visio to design and document your relational schema.
	This is an individual project.
	Deadline: November 8, 2006.

 

	Develop SQL code that would create the database files corresponding to your relational schema for the Mountain View Community Hospital case study created in phase 2 of the class project.
	The developed SQL code should constitute the answer to project assignments P1 and P2 described on page 332 of the textbook after chapter 7.
	Your SQL code should include enough comments and documentation to describe its design and functionality.
	It is recommended that you execute your SQL code on a DBMS to test its correctness and gain the hands on experience, which is the main objective of this project.
	This is an individual project.
	Deadline: November 22, 2006.

 

	Develop a web-enabled interface for the Mountain View Community Hospital case study database created in prior phases of the class project.
	The developed web- interface should constitute the answer to project assignments P1 described on page 419 of the textbook after chapter 10.
	Your interface code should include enough comments and documentation to describe its design and functionality.
	You don't need to implement the full database model developed in previous phases. It is sufficient to implement a subset of the relations, but it has to be large enough to provide useful functionality.
	You should also implement a couple of queries on the DB, to be initiated from the web interface. Query results should be displayed on the web interface as well.
	This is an individual project.
	Deadline: December 12, 2006.

www.dbazine.com
An online portal for database issues and solutions.

www.dbta.com
Data Base Trends & Applications magazine Web site. Addresses enterprise-level information issues.

Databases.about.com
A comprehensive site with many feature articles, links, interactive forum, chat rooms, and so forth.

www.adtmag.com
Application Development Trends is a leading publication on the practice of information systems development.

www.brsolutions.com
Business Rules Solutions is the consulting company of Ronald Ross, a leader in the development of a business rule methodology. You can also check out the next link.

www.intelligententerprise.com
Intelligent Enterprise is a leading publication on database management and related areas. This magazine is the result of combining two previous publications, Database Programming & Design and DBMS.

www.tdan.com
The Data Administration Newsletter regularly publishes new articles, special reports, and news on a variety of data modeling and administration topics.

www.mysql.com
This site is the official home page for MySQL and includes many free downloadable components for working with MySQL.

SearchDatabase.com
This site contains a wide variety of information about database management and DBMSs. New “tips” are added daily, and you can subscribe to an alert service for new postings to the site. Many tips deal with improving the performance of queries through better database and query design.