- Requirements
Assignments: 40%
Participation: 5 %
Tests (2 @ 15% each) 30%
Final: 15%
Project: 10%
-
Participation means attending class and participating in
discussions.
-
All tests are cumulative.
-
Assignments will be graded on functionality (i.e., do they work),
structure and style. Structure includes clear and efficiently
written code. Style includes documentation, indentation
and overall readability. Documentation includes comments.
Programs without comments are unclear and unreadable.
- Assignments are due at the beginning of class
on the date assigned. No late assignments accepted.
Please note that assignments count for 40% of the final
grade.
- While much of the material is from the book, a significant
portion will be from the lectures. You are responsible for all
material presented in class. If you do not attend, find someone
who can give you notes. Do not send email asking for
class summaries.
-
Assignment submissions:
-
Neatly printed and stapled. Clever edge and corner folding to
attach multiple pages will not be accepted nor will paper
clips.
-
Your name, the course, the date, the subject of the
assignment and the assignment number will appear in a comment
block at the beginning of each assignment. Non-complying
assignments will be not be accepted.
-
Assignments will not be accepted by email.
- No screen-caps unless graphic output is involved.
-
Makeup Tests
Makeup tests will be given only in
cases of documented and demonstrated need for causes such as serious illness,
family emergency or University sanctioned schedule conflict.
Note: all makeup tests will be essay format.
-
Final Grades
Final grades will not be available via email. If you want your
grade mailed to you, bring a stamped, self-addressed envelope to the
final.
-
Originality
If your work duplicates in whole or in part the work of someone
else, both works will receive a grade of 0.
If this occurs twice, a final grade of F will be assigned.
-
Classes
Classes are lecture format. Cell phones, pagers and PDA's
may not be used during class. You are encouraged to bring your book to
class and take notes.
You are responsible for all material presented in class.
If you elect not to attend, you are responsible for obtaining the
material you missed. Email requests to me for summaries of material
presented in class will not be answered.
Usage of laptops, PDAs, pagers and cell phones in class is not permitted.
This is due to problems in the past with people using these devices
in class to chat, IM, browse, play games, work on assignments for other classes,
display images/videos and send/rcv email.
These activities are incompatible with a college classroom and create a
distraction to neighbors and people seated in rows further back.
As a result, the faculty Senate has established a policy that these devices may not be
used without consent of instructor.
-
Tests
Test 1
TBA
Test 2
TBA
-
Objective
To understand data base systems
-
Book:
Database Systems: A Practical Approach to Design, Implementation and Management (5th Edition) (Paperback) by Thomas M. Connolly (Author), Carolyn E. Begg (Author)
Publisher: Addison Wesley; 5 edition (March 6, 2009)
ISBN-10: 0321523067
ISBN-13: 978-0321523068
- Topics
- File Systems and Databases
- The Relational Database Model
- An Introduction to Structured Query Language (SQL)
- Entity Relationship (ER) Modeling
- Normalization of Database Tables
- Database Design
- The University Lab: Conceptual Design
- The University Lab: Conceptual Design Verification, Logical Design, and Implementation
- Transaction Management and Concurrency Control
- Distributed Database Management Systems
- Object-Oriented Databases
- Client/Server Systems
- The Data Warehouse
- Database Administration
- Databases and the Internet
-
Database System
PostgreSQL - see below.
Software Needed
-
A host system.
The CNS Labs will have both Linux and Cygwin installed this fall.
You may need a flash drive to store your files.
Ubuntu (try installing it in VirtualBox).
Be sure LAMP, PostgreSQL and either C or Java are installed.
Mac OSX: You will need to install a web server, PostgreSQL and a development language, either C/C++ or Java.
Tutorial and Example Pages
PostgreSQL Tutorial
Some Interesting Database Examples
Ullman's notes of Relational algebra
PostgreSQL 8.2.4 Documentation
Cygwin Install Notes
Links
-
IBM 3390 DASD (1993).
-
IBM Mainframe Disk Capacity Table
-
Evolution of the DASD Storage Control
-
DSORG Summary
-
IBM Data Sets
Project - Due Mon Dec 8
Write a small hospital information system using PostgreSQL (or MySQL),
Apache and server-side scripts. Design the system to
construct appropriate queries to implement information
access by minimally computer trained staff.
Design web pages to enter queries and display results
Functions:
- Admissions and Discharge
- Lab reporting and data entry
- Lab result entry / update
- Lab results by patient
- Medications reporting and data entry - similar to labs
- Diagnosis reporting and data entry - similar to labs
- Vital signs reporting and data entry
- temperatures
- blood pressures
- Reports:
- For a given patient id, a display of all their data.
- For each diagnosis, a list of medications and lab results.
- Average systolic BP, diastolic BP, glucose, HCT and HGB for each patient and for all patients.
Running PostgreSQL, Apache and Mumps
-
Installing and running PostgreSQL on Ubuntu and Cygwin:
Click Here
-
Building a test data base in PostgreSQL: Click Here
- Installing and running Apache on Cygwin: Click Here
- Installing and running Apache on Ubuntu: Click Here
-
A hierarchical scripting language: Introduction to Mumps
- Running Mumps scripts under Apache and PostgreSQL
Click Here
-
Consolidated Mumps/Sql notes: http://math-cs.cns.uni.edu/~okane/114/MumpsSql.html
- Running a C program that talks to the PostgreSQL server
Click Here
- Brief overview of HTML FORM tag Click Here
- File operations in C
"The Americans with Disabilities Act of 1990 (ADA)
provides protection from illegal discrimination for
qualified individuals with disabilities. Students
requesting instructional accommodations due to
disabilities must arrange for such accommodation
through the Office of Disability Services. The ODS
is located at: 103 Student Health Center, and the
phone number is: 273-2676."
Because the Office of Disability Services has procedures in place
to determine the validity of disability claims as well as the need
for instructional accommodations, faculty are reminded that they are
to direct all students with accommodation requests to the above listed
office.
UNDER NO CIRCUMSTANCE SHOULD A FACULTY MEMBER MAKE AN ACCOMMODATION
INDEPENDENT OF THE OFFICE OF DISABILITY SERVICES.
Questions may be directed to: Disability Services
Coordinator, at 273-2676 or to this office at 273-2846.
|