- Credits: 5.0
- Quarter: Spring 2018
- Location: BE 3179
- Days: MW
- Time: 7:15pm - 9:20pm
- Dates: 04/02/2018 - 06/12/2018
- Instructor: Joshua Wedekind
- Office: BE 3175 C. Call/text to verify my current location. (206) 930-2645
- Office Hours: MW 4:00pm - 5:00pm
- E-Mail: joshua.wedekind@seattlecolleges.edu
- Website: https://github.com/SeattleCentral/WEB130
- Github: halfnibble
This course covers current concepts in database theory and use, with a focus on design, implementation, and utilization of database management systems. The main topics of the course include database requirements, ER modeling, relational modeling, database constraints, update anomalies, normalization, SQL, the database front-end, data quality, and database administration.
Prerequisites: BTM 111 with a 2.0 or higher, or instructor permission.
Upon Completion of this course, students will be able to:
- Understand the basics of database design.
- Learn the terminology used to discuss database systems.
- Competently visualize database requirments using ER modeling.
- Understand relationships in a relational database management systems.
- Know the different forms of normalization and how to apply them.
- Be capable of basic database administration.
- Become familiar with SQL.
Database Systems – Introduction to Databases and Data Warehouses
Jukic, Vrbsky, Nestorov
Available at the College Bookstore.
ISBN-10: 1943153191
ISBN-13: 978-1943153190
And also on amazon.com
Regular assignments will be posted in Canvas. All assignments are designed to give the student practice with new skills, concepts, and tools covered in class.
Your homework must be turned in on time. Late submissions may be granted partial credit when accompanied by an ingenuitive excuse. Generally speaking, students will learn more if coursework is up-to-date with the lecture. Unfortunately, assignments turned in after course end will receive 0 points.
There will occasionally be quizzes designed to test knowledge retention and evaluate class progression.
There will also be a Midterm and Final exam, both of which will constitue of large portion of your final grade. (See the schedule for dates).
Evaluation will be based on Assignments, Quizzes, the Midterm and Final Exam.
USB Drive or Cloud Storage and/or Personal Laptop.
While regular attendance is not technically mandatory, in practice, it usually is. This is by design to mimic “real life” scenarios. Often times, showing up is the most important thing. And being present for lectures, quizzes, and code reviews will greatly improve your grade.
This is a programming class and you need to be prepared to work hard and to spend an adequate amount of time outside of the classroom studying and practicing.
I encourage you to work with other class members, which is how real life software is produced. However, you must hand in your own assignments. If found cheating, you will receive no credit and be subject to college disciplinary action. For more information, refer to your Academic Dishonesty Policy in the college catalog or student handbook.
Students with documented disabilities requesting class accommodations, requiring special arrangements in case of building evacuation, or have emergency medical information the instructor should know about are asked to contact the disability support services office (DSS) in BE1112. Once the disability is verified with DSS the student will be given a letter of accommodation (LOA) to be handed to instructor.
Week 1
- Introduction
- Chapter 1: Terms and Basic Concepts
Week 2
- Chapter 2: Database Requirements and ER Modeling
Week 3
- Chapter 2: Database Requirements and ER Modeling, cont.
- Practice with ERDPlus
Week 4
- Chapter 3: Relational Database Modeling
Week 5
- Chapter 3: Relational Database Modeling
- Practice with ERDPlus
Week 6
- Chapter 4: Database Normalization
Week 7
- Chapter 4: Database Normalization, cont.
Week 8
- Chapter 5: Intro to SQL.
Week 9
- Chapter 6: Database Implentation and Use
Week 10
- Chapter 10: Database Administration
Week 11
- NoSQL and Non-Relational Database Systems
*No class on
May 28th, 2018 - Memorial Day
See College Holidays
Students with documented disabilities requesting class accommodations, requiring special arrangements in case of building evacuation, or have emergency medical information the instructor should know about are asked to contact the disability support services office (DSS) in BE1112. Once the disability is verified with DSS the student will be given a letter of accommodation (LOA) to be handed to instructor.
-
If a student contacts the instructor about an accommodation request the instructor will refer the student to the Disability Support Service office in BE1112 for an appointment to discuss accommodation needs.
-
If the DSS office determines that the student does indeed have a disability the student will be given a letter of accommodation (LOA) that will state the accommodation to be implemented.
-
The student’s responsibility is to hand the LOA to the instructor. The instructor will sign the letter (if there is agreement with the accommodation) and give it back to the student. Student will return the LOA to DSS.
Seattle College District has a zero-tolerance policy on sexual harassment, discrimination, sexual violence, rape, bullying, or hazing. Please see District Policy and Procedure 419 https://inside.seattlecolleges.edu/policies/content/polPro.aspx?policyID=pro419
for the process on investigating and responding to reports of sexual harassment and sexual discrimination. Those who have experienced sexual harassment or discrimination, sexual violence, bullying, or are aware of an incident involving these violations, are encouraged to report immediately to: Christina Nelson (Title IX Coordinator): 206.934.4017, Christina.M.Nelson@seattlecolleges.edu or Jennie Chen (District Compliance Officer): 206.934.3873, jennie.chen@seattlecolleges.edu.
Seattle Colleges faculty and staff are required to report incidents of sexual misconduct to the Title IX Coordinator.