Relational Database Writings C J Date

Document Sample
Relational Database Writings C J Date Powered By Docstoc
					WDIM331 Database Management Concepts

WDIM 331 Section A

Summer 2010 3 credits
Tues 12:45 – 4:30pm
Room 216

Instructor: Tom Wheeler

Contact Information

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

WDIM 262 – Web Scripting 2

Required Materials
Removable storage media (USB).

          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.

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.

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 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

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

Evacuation Procedures
Please proceed to the nearest exit when the strobe lights flash and an audible alarm occurs. AiPD’s
evacuation location is 10 and Davis; wait there for further instructions.
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.
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,
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

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!

Shared By:
Description: Relational Database Writings C J Date document sample