Methods for obtaining requirements and designing database systems; differences between hierarchical, relational, and network database designs; techniques for designing and coding effective reporting procedures. Prerequisite: either CSS 263, CSS 341 or CSS 342; CSS 360; may not be repeated.
This course covers techniques for database design and reporting, as well as database system concepts necessary for implementation and optimization. The first part of the course will cover concepts and techniques useful in database design, reporting, and implementation, including the relational model, relational algebra, Structured Query Language (SQL), and normalization. The second part of the course will cover object role modeling and the phases of database design methodology (conceptual, logical, and physical). Additional topics, such as transaction management, query processing, and current trends will be addressed as time permits.
Student learning goals
Relational model and relational algebra
Structured Query Language (SQL)
Object Role Modeling (ORM)
Phases of database design
General method of instruction
Pelase visit http://www.dreamspark.com and download SQL Server 2008 R2 Developer Edition. You can also get the same from the library.
Class assignments and grading
There will be four assignments. There will also be a group project in which you and some fellow students will design and implement a database using SQL Server, including conceptual, logical, and physical design stages and sample queries
Homework: 10% (Turning all of these in is important to your grade.) Quizzes: 15% (Best 3 out of 4 quizzes – no make-up quizzes will be given.) Group project: 25% Midterm: 25% Final exam: 25% I use a linear grading scale such that 75% = 2.0, 85% = 3.0, 95% = 4.0.