COSI 345-Outline

COURSE CONTENT FOR

COSI 345 A Database Management

Text: Hoffer / Prescott / Topi, Modern Database Management, Ninth Edition. Prentice Hall, ISBN 0-13-600430-X

Book cover image for Microsoft Office Access 2007: Comprehensive Concepts and Techniques Text: Philip J. Pratt, Mary Z. Last, Gary B. Shelly, Thomas J. Cashman, Microsoft Office Access 2007, ISBN 13: 978-1-4188-4341-0 © 2008

Microsoft Access Topics

Creating & Querying a Database

Maintaining a Database

Creating Reports and Forms

Multi-Table Forms

Switchboard, Example

SQL

Text: Ramakrishnan / Gehrke, Database Management Systems, Third Edition. McGraw-Hill, 2003, ISBN 0072465638 / 9780072465631

*Weeks*	*Chapters*	*Topics*
1	1	Overview of Database Systems
2-3	2	Introduction to Database Design
4-5	3	The Relational Model
6	*Review and Mid-Term Test I*
7-8	4	Relational Algebra and Calculus
9-10	5	SQL: Queries, Constraints, Triggers
11	*Review and Mid-Term Test II*
12	8	Overview of Storage and Indexing
13	12	Overview of Query Evaluation
14	16	Overview of Transaction Management
15	*Final Comprehensive Exam*

(Second Edition)

*Weeks*	*Chapters*	*Topics*
1	1	Introduction To Database Systems
1	2	The Entity-Relationship Model (1)
2	2	The Entity-Relationship Model (2)
2	3	The Relational Model
3	4	Relational Algebra and Calculus Examples
4	5 (Sections 1 to 6)	SQL: Queries, Prgramming, Triggers Example Switchboard How? Using SQL in Access 07
5	5 (Sections 7 to 11)	SQL: Queries, Prgramming, Triggers Expressions Set-Comparison Aggregation Group-By More
6		*Review and Mid-Term Test I*
7	15 (Sections 1 to 5)	Schema Refinement and Normal Forms
8	15 (Sections 6 to 8)	Schema Refinement and Normal Forms
9	7	Storing Data: Disks and Files
9	8	File Organizations and Indexes
10	9	Tree Structured Indexing
	10	Hash Based Indexing
	11	External Sorting
11		*Review and Mid-Term Test II*
12	12 (Sections 1 to 6)	Evaluation of Relational Operators
13	12 (Sections 7 to 8)	Evaluation of Relational Operators
14	17	Security
15		*Final Comprehensive Exam*