CS 2550
|
Database Design and Application |
|
Instructor |
|
||||
|
Classroom |
TE109C |
||||
|
Days |
TTh |
||||
|
Time |
11:30am – 1:20pm |
||||
|
Texts |
Database Design, Application Development, & Administration, by Michael V. Mannino, McGraw-Hill, 2007 |
||||
|
Goal |
Each student will become familiar with relational database concepts, design and application development. Students will learn the basics of the SQL language, the design of a database using an entity-relation design tool, and the creation of applications using a development tools. Students will spend time in the lab learning to use the database tools and in developing applications. Students will build on the skills acquired in the Co-prerequisite: Math 1630. |
||||
|
Class |
Class will consist of lecture and discussion on topics related to the study guide. Questions and comments during class time are encouraged. It is expected that students will have read the covered chapters prior to the class on the topic. The instructor will also ask questions of
the students to ensure that learning is taking place. |
||||
|
Assignments |
There will be 9 SQL assignments, 2 normalization assignments, 2 ER Modeling assignments and 1 small research assignment. These will contribute 60% to your final grade. |
||||
|
Exams |
The course will have both a midterm and final exam. Both exams will be comprehensive. Both exams will be timed and will be taken online. Together they will contribute to 40% of your final grade. |
||||
|
Grading |
The final grade will be given based on point accumulated through
quizzes, exams and projects. Standard percentage grading will apply: 90+ A;
80-89 B; 70-79 C; 60-69 D; 59 and below E |
||||
|
Policies |
Exams can only be taken on the day given
unless arrangements are made to take them ahead of time. |
||||
|
Accommodations for disabilities |
Any student requiring accommodations or services due to a
disability must contact Services for Students with Disabilities (SSD) in room
181 of the |
||||
|
Cheating |
Cheating on assignments or exams will not be
tolerated. A separate statement
defining cheating policies will be handed out to students. |
Class Schedule & Study Guide
| Week of |
Reading Assignments | Topics | Assignments/Exams |
|---|---|---|---|
| 1 | Chapter 1 | Introduction to Database Management | Research Assignment |
| 2 | Sections 3.1 & 3.2 |
Relational Data Model |
SQL Assignment #1 |
| 3 | Sections 3.4.1 & 4.1.1 - 4.2.1 |
Relational Operators - Restrict and Project SQL SELECT - WHERE clause |
SQL Assignment #2 |
| 4 | Sections 4.2.3, 4.2.4 |
SQL SELECT - GROUP BY, ORDER BY clauses | SQL Assignment #3 |
| 5 | Sections 3.4.2, 4.2.2 & 4.5.1 - 4.5.4 |
SQL Joins and Aggregate functions | SQL Assignment #4 |
| 6 | Section 4.6 | SQL Data Modification Statements | SQL Assignment #5 |
| 7 | Sections 3.4.2, 4.2.2 & 4.5.1 - 4.5.4 |
SQL Multi-table and complex Joins | SQL Assignment #6 |
| 8 | Sections 3.4.4 - 3.4.7 & 9.1.1 - 9.2.4 |
SQL Outer Joins and HAVING Clause | SQL Assignment #7 |
| 9 | Sections 3.4.7, 9.2.1 - 9.4.3 |
SQL Nested Queries and solving divide problems | SQL Assignment #8 Midterm Exam |
| 10 | Chapters 2 & 5 | Database Development and Data Modeling | ERD Assignment #1 |
| 11 | Chapter 6 | Developing Data Models for Business Databases | ERD Assignment #2 |
| 12 | Sections 7.1.1 - 7.2.3 & 7.5.1 - 7.5.2 |
Normalization of Relational Tables | Normalization Assignment #1 |
| 13 | Sections 7.1.1 - 7.2.3 & 7.5.1 - 7.5.2 |
Normalization of Relational Tables | Normalization Assignment #2 |
| 14 | Sections 10.1 - 10.2 Review Chapters 1-7 & 9 |
Views Semester Review |
SQL Assignment #9 |
| Review Chapters 1 - 7 & 9 | Final Exam - Tuesday April 20th, 1:00 - 2:50pm | Final Exam |