CS 2550

Database Design and Application Spring Semester 2012

Instructor

Rob Hilton	Office: TE110G Phone: 801-626-6086 Email: cs.rbhilton@gmail.com Web: http://rbhilton.com/wsucs
Office Hours	Mon & Tue 8:30-9:30am, Thu 7:30-9:30am, 11:30-12-30pm , or by appointment

Classroom

TE103C

Class Times

Monday & Wednesday 11:30am - 1:20pm (CRN: 30960)
Tuesday & Thursday 9:30am - 11:20am (CRN: 30949)

Texts

Oracle SQL by Example
by Alice Rischert, Prentice Hall/Pearson Education
Fourth Edition (ISBN: 978-0-13-714283-5)
*available as an EBook

Goal

Each student will become familiar with relational database concepts,theory and design. Students will learn the basics of the SQL language and gain expertise in formulating complex SQL queries. Experience will also be gain in the design of a database using an entity-relation design tool. Students will spend time in the lab learning to use the database tools and in working with SQLS. 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.
Approximately half of class time will be devoted to SQL, design and modeling lab work.

Assignments

There will be 10 SQL assignments and 3 design assignments. These assignments will contribute approximately 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.
Exams and quizzes may not be taken after the scheduled date.
Assignments may be turned in late but will receive a late penalty (1st late 75%, 2nd late 50%, 0% thereafter).

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 Student Service Center. SSD can also arrange to provide course materials (including this syllabus) in alternative formats if necessary.

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
(This schedule is tentative and may be subject to modification during the semester)

Week	Reading Assignments	Topics	Assignments/Exams
1	Chapter 1.1	Syllabus / SQL and Data
2	Chapter 1.2 Chapter 1.3	Data Normalization and Table Relationships The Student Schema	Design Assignment #1
3	Chapter 2 Chapter 3	SQL: The Basics The WHERE and ORDER by Clauses Holiday Jan 16th Review Day Jan 17th	SQL Assignment #1
4	Chapter 4	Character, Number and Misc Functions	SQL Assignment #2
5	Chapter 5	Date and Conversion Functions	SQL Assignment #3
6	Chapter 6	Aggregate Functions GROUP BY and HAVING	SQL Assignment #4
7	Chapter 7	Equijoins	SQL Assignment #5
8	Chapter 8	Subqueries Holiday Feb 20th Review Day Feb 21st	SQL Assignment #6
9	Chapter 8	Subqueries	SQL Assignment #7 Midterm Exam
10	Chapter 9	Set Operators	SQL Assignment #8
11	Chapter 10	Complex Joins	SQL Assignment #9
12	Chapter 11 Chapter 12 Chapter 13	INSERT, UPDATE and DELETE CREATE, ALTER and DROP tables Indexes, Sequences, Views	SQL Assignment #10
13	Chapter 1.2 and Web Resources	Normalization of Relational Tables	Design Assignment #2
14	Chapter 1.2 and Web Resources	Normalization of Relational Tables	Design Assignment #3
	Review	Final Exam - Date/Time TBA	Final Exam