WDIM331 Database Management Concepts Syllabus WDIM 331 Section A Summer 2010 3 credits Tues 12:45 – 4:30pm Room 216 Instructor: Tom Wheeler Contact Information firstname.lastname@example.org 360-326-5076 www.wheelercreek.com FINAL day. date, and time Tues Sep 14, 12:45 Required Texts Concepts of Database Management, Sixth Ed. Phillip J. Pratt and Joseph J. Adamski, Thomson Course Technology 2008 Course Description Database design for dynamic web content management. Emphasis on database concepts, the relational database model, and translating a client's requirements into a working database design. Course Outcomes Students will learn to: Define terminology involved with database design and management Analyze an organization's needs and design relational table structures to meet these needs Construct QBE and SQL queries to pull the appropriate data from tables Describe the relational model and create entity-relationship diagrams Prepare normalization strategies Create and manage databases Prerequisite WDIM 262 – Web Scripting 2 Required Materials Removable storage media (USB). Grading Weekly assignments = 20 points each Final Project = 140 points. 95%-100% = A 77%-79% = C+ 90%-94% = A- 74%-76% = C 87%-89% = B+ 70%-73% = C- 84%-86% = B 67%-69% = D+ 80%-83% = B- 64%-66% = D Attendance and Participation Be on time for class Be considerate of others work and presentations Participate in class If you have a problem or a question, ask it! Campus Email Policy Please note that only your official campus email address will be used. Lab Policies Leave food and drink outside the class. Disciplinary action will be taken toward any student found using the equipment in an inappropriate manner, taking cell phone calls or surfing the web. Disruptive, disrespectful or rude behavior will not be tolerated. Plagiarism Presenting the writings, images or paraphrased ideas of another as one’s own, is strictly prohibited at the Art Institute of Portland. Properly documented excerpts from other’s works, when they are limited to an appropriate amount of the total length of a student’s paper, are permissible when used to support a researched argument. Attendance Policy for the Art Institute of Portland Students who are absent from all scheduled classes over a 14-day period (2 weeks) are subject to automatic attendance suspension—from the Institute, not just from this course. This means the student is administratively withdrawn from all courses and cannot attend classes or continue in the current quarter unless he/she successfully appeals for reinstatement. Students who anticipate violating the attendance policy should contact their Academic Advisor or Academic Department Director immediately to discuss options such as withdrawing from the Institute or navigating the appeals process. Absences Policy Regular attendance is required for successful completion of this course. A student who misses the equivalent of three (3) classes will not pass this class. Exceptions for extenuating circumstances will be considered at the discretion of the instructor. Tutoring Free, one-on-one tutoring is available to you across all subjects through the Tutoring Center. The goal of tutoring is to help you learn and master skills so you can then confidently apply them on your own. Tutoring is helpful for students at all levels—freshman through senior, whether you want to move from a failing to a passing grade or whether you want to cement an ―A.‖ Our tutors are faculty or, most often, fellow students who have excelled in the subject. You may find a tutor by visiting aidepartments.com or dropping by the Tutoring Center in Room 328 inside the Education Department. The Director of the Tutoring Center is Sara Cartmel, whom you are welcome to contact at 503-382-4811 or email@example.com. Students with Disabilities It is AiPD policy not to discriminate against qualified students with a documented disability in its educational programs, activities or services. If you have a disability-related need for adjustments or other accommodations in this class, contact the Disability Services Coordinator. Mara Sievers, 503-382-4836 firstname.lastname@example.org Evacuation Procedures Please proceed to the nearest exit when the strobe lights flash and an audible alarm occurs. AiPD’s th evacuation location is 10 and Davis; wait there for further instructions. **ALWAYS ASSUME ANY EVACUATION IS REAL** Course Calendar Week 1 Introduction to database management, basic terminology, describe database management systems, advantages and disadvantages of database processing. Introduce the sample database for Henry Books. Introduction to MS Access. Assignment: Read Chapter 1 in the book. Do review questions 1,3,4,6,12 and 21. Do all the Premiere Products exercises (except #8). Week 2 The relational model, QBE. Simple queries, simple criteria, computed fields, calculating statistics, grouping, sorting. Joining tables, update queries and delete queries. Assignment: Chapter 2, Do review questions 1-10. Do all the Premiere Products exercises QBE, skip the relational algebra section, and do the Henry Books exercises. Week 3 The relational model, SQL. Same concepts as last week but this time writing the SQL code. Compound conditions, computed fields, special operators. Built-in functions, sorting, grouping, joining tables. Updating and creating tables with SQL. Assignment: Chapter 3, Do all the review questions. Do all the Premiere Products exercises. Week 4 Intro to MySQL, various GUIs for MySQL. Migrate the Henry Books Case db to MySQL. The relational model – primary keys and integrity rules. Assignment: Do the Henry Books Case exercises from chapter 3 in MySQL. Work on design wireframes for your final project. Week 5 The relational model – other advanced SQL topics. Indexes, security, integrity rules, primary keys. Making structural changes. st Assignment: Read chapter 4. Do the database design (1 Part only) for the Small Business Accounting tool – posted to my website. Week 6 Database Design – Normalization. Functional dependence. Keys. First Normal form, second normal form, third normal form. Review the Small Business Accounting Database designs. Assignment: Chapter 5. Build the actual Small Business Accounting database and input sample data. Write the 6-7 different queries for the required views. Week 7 Review the Accounting Database designs, and queries. Introduction to PHP, connecting a database to the web, building web forms. A basic PHP and mySQL application to query a database. Assignment: Do the database design assignment for the Manhattan Physicians Centers, which is posted on my website. Week 8 Go through the Manhattan Physicians Centers project. Web forms and web database continued. Executing SQL commands commands through PHP (add, delete, update). Assignment: Build the Manhattan Physicians Database, and populate with sample data. Write 5-6 different queries for the required views. Week 9 Review the Manhattan Physicians queries and views. Review of PHP & MySQL. Introduce final project. Assignment: Begin final project assignment, database design. Posted to wheelercreek.com. Week 10 Final database designs due. – I normally have students complete visual designs along with the database, due to our shortened time-frame that may not end up being a requirement. We’ll see as we get closer!