COURSE: COSC 386 Database Implementation
TERM:  Spring 2016
INSTRUCTOR: DEAN DEFINO
TELEPHONE: OFFICE: 410-543-6145 HOME: 410- 546-5461

TEXTBOOK:       "A Guide to MySQL" by Philip Pratt, International Thomson Publishing, 2006.  Class Notes by Dean DeFino

Any PHP text such as: 

 “Learning PHP, MySQL, JavaScript,  & CSS” 2^nd Edition by Nixon, O’Reilly Publishing, 2012, ISBN: 978-1-449-31926-7 

 “PHP for the World Wide Web” by Larry Ullman, Peachpit Press, Second Edition, 2004,  ISBN 0-321-24565-2.

 “PHP and MySQL Web Development” by Luke Welling and Laura Thomson, Third Edition,  PearsonTechGroup.com and Sams Publishing, ISBN 0-672-32672-8

 

 "PHP Programming with MySQL" by Gosselin, Kokoska and Easterbrooks, Second Edition, Course Technology, 2011 ISBN-13: 978-0-5387-4584-0 or ISBN-10: 0-5387-4584-3

PURPOSE: This course concentrates on the implementation of databases using the relational database model.  Students will learn vocabulary, DBMS functionality as well as database administration.  Students will design, build and manipulate a large database project as well as create web pages to access the database.  Languages used in the course include html, MySQL and PHP.  Students will learn how to integrate these languages to produce a large database project accessible from the Internet.

PROCEDURES:

Classroom (lecture) work will consist of discussion, demonstration, student participation, labs  and assignments.  All tests and exams are comprehensive and are to be taken on the assigned date unless the instructor, in cases of emergency, gives special permission.  If you are a member of an athletic team and will not be in town on the date of an exam, you may take the exam PRIOR to the scheduled exam date.  Please supply me with your athletic team’s schedule.  Makeup exams are given only to those students who have an absence that has been approved by the instructor. 

 

Projects and homework assignments are due at the beginning of the class on the date that they are due.  Late projects will be penalized 10% per day including weekends.  Projects  more than five (5) days late will receive a grade of 0%.  No homework will be accepted late. 

 

Quizzes , both announced and unannounced may be given periodically during the semester.  Please also note that some assignments will be given and completed during the class meeting period.  Quizzes are not counted separately but are included in the assignments portion of the course.

 NEITHER Cell phones NOR MP3 players (or other audio/visual equipment)  are  to be used during class or lab time.   (No calls and no text messaging during class)  Silence your phones for all classes.  If you must leave the class early for a legitimate reason, please inform the instructor before the class starts.  Leaving a class early without notifying the instructor is the same as an absence.   If an emergency arises that you must leave the class (even if you return), please inform the instructor at the end of the class.  Food and drinks are not to be taken into the classroom or labs.

GRADING:

  Exams             30%

  Assignments   30%

  Projects          40%

 

 

GRADING SYSTEM

A 90-100
B 80- 89
C 70- 79
D 60- 69
F 0- 59

ATTENDANCE:  Attendance is a vital part of the learning experience and each student is expected to be present each time.
After three un-excused absences, .5 will be deducted from the final grade for each un-excused absence.

OFFICE: Devilbiss Hall  room 105

Office Hours: MWF   9:00- 9:50  11:00-11:50    

 

Final Exam:  

  Wednesday May 18   8:00 - 10:30    Held in the classroom