COMP 570 Database Applications

 

1999-00 Catalog Data: This course covers the design and implementation of databases for several database applications using a database management system.

Textbooks: Connolly, Begg and Strachan, Database Systems - A Practical Approach to Design, Implementation and Management, Second Edition, Addison-Wesley.

References: 1) .....Oracle book.....

2) Elmasri,R. & Navathe,S.; Fundamentals of Database Systems, Third Edition, Addison-Wesley.

Coordinator: Michael Werner, Ph.D. Associate Professor of Computer Science. Office hours are 10:00 Monday, 2:00 Tuesday, 10:00 Friday, or by appointment. Office in Dobbs 006. Phone: (617) 989-4143. Email: wernerm@wit.edu.

WWW Page: http://www.public.wit.edu/faculty/wernerm/Comp570.htm

Goals: To master the design and implementation of databases from the user point of view, and to understand the functioning of database management systems from a systems point of view. To gain proficiency in using a modern database management system, namely Oracle.

Prerequisites: COMP355 Data Base Management Systems.

Prerequisite by Topic:

1 Programming in a high level language.

2 Entity/Relationship design of a database.

3 SQL database query and definition language.

4 Data Structures.

 

Topics and assigned readings

Chapter references are to the Connolly book unless otherwise noted:

 

Part I - Designing and implementing a database

1. The DreamHome Case Study (1 hr) Section 1.7

2. Entity/Relationship data modeling (3 hr) Chapter 5

3. Conceptual database design (2 hr) Chapter 7

4. Logical database design (3 hr) Chapter 8

5. Physical database design (3 hr) Chapter 9

 

Part II - Querying a database

6. SQL Data definition language (3 hr) Chapter 14

7. SQL Data manipulation language (3 hr) Chapters 13, 14

8. Building and using forms (3 hr)

 

Part III - Understanding transactions and protecting database integrity

9. Relational Algebra (3 hr) Chapter 3

10. Query Processing (3 hr) Chapter 18

11. Transaction Management (3 hr) Chapter 17

 

Part IV - Advanced Topics

12. Distributed Databases (3 hr) Chapter 20

13. Object-Oriented Databases (3 hr) Chapters 21, 22

(time permitting)

Estimated CSAB Category Content 4 credits

Total Credits: 4

Laboratory Projects:

There is a coordinated series of laboratory projects designed to build a complete database application using the MS ACCESS database software. The labs illustrate and reinforce many of the concepts introduced in the lectures, and follow a sample Company database used extensively in the Elmasri textbook.

Company Database Requirements:

1. A normalized set of tables representing employees, projects, departments, dependents and relationships between them.

2. Integrity constraints and validations prevent incorrect data from being entered.

3. Data entry forms using text fields, combo boxes, option groups, etc.

4. A set of standardized reports.

5. A set of standardized queries, which join the information in several tables.

6. Stand alone and LAN capabilities

7. Event driven capabilities on interactive forms using ACCESS macros and BASIC.

8. A customized menu system

9. Custom toolbars

Assignments: There will 12 graded laboratory assignments. The lowest grade will be dropped. Assignments may be handed in up to one week late for a 10 point penalty.

You may work alone or in 2 person teams. Each team member must fully understand the work since many test questions will parallel the assignments. Copying will result in all individuals involved receiving a zero.

Tests: There will be 3 quizzes and a final exam. If all quizzes have been taken the lowest score will be dropped. No quiz makeups.

Grading: Grades will be determined approximately as follows:

Assignments 35%

Quizzes 40%

Final 25%

Attendance: Regular attendance at every class is expected, and anyone who fails to meet this requirement may be requested to withdraw from Wentworth. In addition students with poor attendance may be withdrawn from the class with a grade of "WA". The attendance policies are more fully explained in the Wentworth Catalogue. You are responsible for all material given in class as well as in assigned readings.