Course Information
- Instructor: Dr. Aaron Garrett (garrettal@wofford.edu)
- Class Meeting (Olin 218): TR 9:30a-10:50a
- Office Hours (Olin 204E): MTWR 2:00p-4:30p; or by appointment
- Textbook: Concepts of Database Management by Pratt and Last
- Final Exam: 15 May 2018 from 2:00p-5:00p
Catalog Description
A study of data models, including relational, object-oriented, hierarchical, and network models. Topics include the theory of normal forms, database design, query languages, and implementation of databases.
Prerequisite: COSC 235 with a minimum grade of C.
Goals
- Understand the basic terminology and theory of relational algebra
- Understand functional dependencies and normalization
- Be able to construct conceptual models that map to normalized relational schemas
- Understand the fundamental concepts in database management systems
- Be proficient with Structured Query Language for defining schemas and manipulating data
- Be familiar with basic management tasks in MySQL
- Be capable of interacting with databases from standard programming languages
- Be familiar with semi-structured data such as XML
- Be familiar with the basic implementation approaches for database management systems
Grades
Your grade in the course will be based on a combination of assignments and exams.
- Assignments
- Assignments are short exercises that reinforce the core concepts.
- Projects
- The projects are larger, more complex design and implementation assignments.
| Artifact | Points |
|---|---|
| Assignments (~5) | 50 |
| Projects (~2) | 50 |
| Total | 100 |
The usual grading scale will be applied to the accumulated points: 93–100: A, 90–92: A-, 87–89: B+, 83–86: B, 80–82: B-, 77–79: C+, 73–76: C, 70–72: C-, 60–69: D, 0–59: F.
Policies
Attendance
You are expected to attend class meetings and come to class prepared. Refer to the General Policy Regarding Attendance in the Wofford College Student Handbook. The policy makes you responsible for catching up on missed classes. If you must be absent for class, please email me in advance to let me know.
Make-up exams are not available. If you have a legitimate, excused absence during the midterm exam, then you must make it up during the final exam period.
Assignment Deadlines
Late assignments will not be accepted without a legitimate excuse. All assignments are expected to be submitted by 11:55p ET on the posted deadline.
Academic Integrity
The Honor Code requires faculty, staff, and students to maintain a high standard of individual honor and integrity. While I may specify some assignments as collaborative, work represented as your own must be your own. If you have any doubt about what is appropriate for a given assignment, you should contact me for clarification.
Accommodations
If you have a disability that requires assistance or accommodation, or if you have questions related to any accommodations for testing, note takers, readers, etc., please contact Dean Beth Wallace by telephone at (864) 597-4371 or in person by visiting the Hugh R. Black Infirmary. You must arrange accommodations during the first week of classes.
Tentative Schedule
| Meeting | Chapter | Topics | Deadline |
|---|---|---|---|
| 06 Feb | motivation | ||
| 08 Feb | motivation | ||
| 13 Feb | terminology | ||
| 15 Feb | relational algebra | A1 | |
| 20 Feb | functional dependencies | ||
| 22 Feb | NO CLASS | ||
| 27 Feb | normalization | ||
| 01 Mar | normalization | A2 | |
| 06 Mar | E-R models | ||
| 08 Mar | UML models | ||
| 13 Mar | |||
| 15 Mar | SQL | A3 | |
| 20 Mar | SQL | ||
| 22 Mar | SQL | ||
| 27 Mar | SQL | ||
| 29 Mar | SQL | ||
| 10 Apr | using SQL in other languages | P1 | |
| 12 Apr | using SQL in other languages | ||
| 17 Apr | creating databases | ||
| 19 Apr | SQL views | A4 | |
| 24 Apr | XML | ||
| 26 Apr | XML | ||
| 01 May | |||
| 03 May | DBMS implementation | A5 | |
| 08 May | DBMS implementation | ||
| 10 May | P2 |
Note: This syllabus is subject to change with notice.