CMPS 460

CMPS460 COURSE INFORMATION SPRING 2011

Class Syllabus in open office PDF
Class Notes Part 1: Intro material WORD & PDF
Class Notes Part 2: Entity Relationship Model PDF & BASEBALL REQ & C ERM & A ERM
Class Notes Part 3: Relational Model WORD & PDF
Class Notes Part 4: SQL WORD & PDF
Class Notes Part 5: Embedded SQL WORD & PDF
Class Notes Part 6: Normalization WORD & PDF
Class Notes Part 7: Query Optimization WORD & PDF

ASSIGNMENTS

Assignment #1: Database design ER Diagram PDF
Assignment #2: ER Diagram mapping PDF
Assignment #3: Relational algebra problems PDF
Assignment #4: MySQL test drive. All files are given below WORD
Assignment #5: The big project. Requirements, Graduate requirements, Grad form1, Grad form2, Grad form3

GRADER: Brandon Primeaux
E-MAIL: bmp7996@louisiana.edu
OFFICE: Oliver Hall Room 105 (The door is locked, knock)

PHONE: 482-1659

OFFICE HOURS:

Monday

NONE

Tuesday

1:45 - 5:00

Wednesday

NONE

Thursday

1:45 - 5:00

Friday

NONE

ERM STUFF (DATABASE DESIGN)

Visio How To Guide WORD & PDF & EXAMPLE
Dia How To Guide WORD & PDF

PHP/MySQL STUFF

PHP/MySQL README

Form for acct table update: AcctChForm.html

PHP script for acct table update: AcctChQuery.php

PHP script for acct table display: AcctDisplay.php

Create the acct table: acct.create

Load data into the acct table: dataload.sql

Acct table data: acct.data

Two simple queries against the acct table: acct.sql acctbal.sql

A PHP script to test PHP and the mail facility: hello.php

View the Apache log file: http://armagnac.ucs.louisiana.edu/

jne1390@louisiana.edu

Computer Science Department		phone: (337) 482-6609
Box 41771 - USL Station			fax: (337) 482-5791
Lafayette, LA 70504