Get account data from web form
Var EmailExp = /^[\w\-\.\+]+\@[a-zA-Z0-9\.\-]+\.[a-zA-z0-9]{2,4}$/
If not Email matches EmailExp
	Throw error message "Email Invalid"
Endif
If not Email is unique
	Throw error message "Email already exists"
Endif
If not Password is 10 characters in length and contains at least one number
	Throw error message "Password Invalid"
Endif
BEGIN WORK
	Increment last student ID
	Create row in student table using new student ID
	Create row in address table and link to student
	If error
		ROLLBACK
		Return false
	Else
		COMMIT
         

Get student from session and course offering data from web form
BEGIN WORK
Check availability of offering
If total number enrolled is less than max students
	Create row in enrollment table for student and offering
	Set enrollment date to current date
	Increment number enrolled in offering
	Add offering fee to amount due in student
Else
	Set error
Endif
If error
	ROLLBACK
	Return false
Else
	COMMIT
	Return true
         

Get student from session and credit card and amount from web form
If amount is less than total amount due for student
	Throw error message "Invalid Amount"
Endif
BEGIN WORK
	Validate payment against credit card web service (Not Implemented)
	If not payment validated
		Throw error message "Credit Card Declined"
	Endif
	Increment last payment ID
	Create row in payment table using new payment ID
	Decrement amount due for student by payment amount
	If error
		ROLLBACK
		Return false
	Else
		COMMIT
		Return true
         

DROP TABLE Address;
DROP TABLE Course;
DROP TABLE CourseEnrollment;
DROP TABLE CourseOffering;
DROP TABLE Instructor;
DROP TABLE Payment;
DROP TABLE Student;

CREATE TABLE Address (
	AddressID Integer NOT NULL,
	StudentID Integer NOT NULL,
	Street Text(50),
	City Text(50),
	State Text(2),
	PostalCode Text(20),
	Country Text(50)
);

CREATE TABLE Course (
	CourseID Integer NOT NULL,
	Name Text(50) NOT NULL,
	Description Memo
);

CREATE TABLE CourseEnrollment (
	StudentID Integer NOT NULL,
	CourseOfferingID Integer NOT NULL,
	EnrollmentDate DateTime NOT NULL
);

CREATE TABLE CourseOffering (
	CourseOfferingID Integer NOT NULL,
	CourseID Integer NOT NULL,
	InstructorID Integer NOT NULL,
	Year Integer NOT NULL,
	Term Integer NOT NULL,
	Classroom Text(50),
	Fee Currency NOT NULL,
	MaxStudents Integer NOT NULL
);

CREATE TABLE Instructor (
	InstructorID Integer NOT NULL,
	Name Text(50) NOT NULL
);

CREATE TABLE Payment (
	PaymentID Integer NOT NULL,
	StudentID Integer NOT NULL,
	Amount Currency NOT NULL
);

CREATE TABLE Student (
	StudentID Integer NOT NULL,
	EmailAddress Text(50) NOT NULL,
	Password Text(20) NOT NULL,
	Name Text(50) NOT NULL,
	AmountDue Currency NOT NULL
);


ALTER TABLE Address ADD CONSTRAINT PK_Address PRIMARY KEY (AddressID);

ALTER TABLE Course ADD CONSTRAINT PK_Course PRIMARY KEY (CourseID);

ALTER TABLE CourseEnrollment ADD CONSTRAINT PK_CourseEnrollment
PRIMARY KEY (StudentID, CourseOfferingID);

ALTER TABLE CourseOffering ADD CONSTRAINT PK_CourseOffering
PRIMARY KEY (CourseOfferingID);

ALTER TABLE Instructor ADD CONSTRAINT PK_Instructor PRIMARY KEY (InstructorID);

ALTER TABLE Payment ADD CONSTRAINT PK_Payment PRIMARY KEY (PaymentID);

ALTER TABLE Student ADD CONSTRAINT PK_Student PRIMARY KEY (StudentID);

ALTER TABLE Student ADD CONSTRAINT UQ_Student_EmailAddress UNIQUE (EmailAddress);

ALTER TABLE Address ADD CONSTRAINT FK_Address_Student FOREIGN KEY (StudentID)
REFERENCES Student (StudentID);

ALTER TABLE CourseEnrollment ADD CONSTRAINT FK_CourseEnrollment_Student
FOREIGN KEY (StudentID) REFERENCES Student (StudentID);

ALTER TABLE CourseEnrollment ADD CONSTRAINT FK_CourseEnrollment_CourseOffering
FOREIGN KEY (CourseOfferingID) REFERENCES CourseOffering (CourseOfferingID);

ALTER TABLE CourseOffering ADD CONSTRAINT FK_CourseOffering_Course
FOREIGN KEY (CourseID) REFERENCES Course (CourseID);

ALTER TABLE CourseOffering ADD CONSTRAINT FK_CourseOffering_Instructor
FOREIGN KEY (InstructorID) REFERENCES Instructor (InstructorID);

ALTER TABLE Payment ADD CONSTRAINT FK_Payment_Student
FOREIGN KEY (StudentID) REFERENCES Student (StudentID);
	

A:link { color: #330000; }
A:visited { color: #330000; }
A:active { color: #330000; }
A:hover { color: #993300; }
td { font-family: batang, arial, sans-serif; font-size: 10pt}
.orange1 {
	font-family: batang, arial, sans-serif;
	font-size: 10pt;
	color: #993300;
	font-weight:bold; }
.orange2 {
	font-family: batang, arial, sans-serif;
	font-size: 10pt;
	color: #993300; }
.gray1 {
	font-family: batang, arial, sans-serif;
	font-size: 8pt;
	color: #CCCCCC; }
.gray1 {
	font-family: batang, arial, sans-serif;
	font-size: 8pt;
	color: #999999; }
          

• Programs
• Course Schedule
• Upcoming Events
• Contact Us

1. There will be a logo on the left upper side. Across from it will be a search capability tool and log on. The rest of the page will contain a menu to other links, a flash/graphics section, calendar, and important news events icons, or advertisements.
2. The navigation menu which will be on the left side will contain the following: About, Programs, Course Calendar, Event Calendar, Faculty, Contact, Studen Sign On, Faculty Sign On
3. The ad spaces will change frequently and it will show our sponsors

1. Mission statement - This page will give the mission statement and can be accessed from either about menu, or about us page.
2. Community Partnerships - will give a list and description of our sponsors, and a link to become a sponsor.
3. Press Information - Gives the information about our media contact and past news features and information.

1. Beginner - This page will have the info to all the beginner's programs. It will also include links surveys, some basic music level placement tests and other info that would be related to beginner's level
2. Intermediate - This page is targeted to non-beginners who would like to continue their studies. It will contain info about different programs, and different paths where a musician can go.
3. Advanced - This page is intended for students that will like to become professionals. It will contain step by step information on how to achieve this goal.

1. Search Courses - This will be a link where a search can be done on more specific criteria. E.g. Time, days, class name, professor. IT will contain a link to Course Registration
2. Course Registration - This is the page where a student signs up for classes. It contains profile info, classes that he is registering for, and tuition.

1. This page will display all the events related to school. (Except for the classes). E.g. Concerts, recitals, faculty events, fund-raisers.

1. This contains Faculty profile and class history

1. This page will contain the contact to different departments.

1. This page is designed for current students to check their class/event schedule, assignments, submit assignments and see tuition

1. This page is designed for current faculty to update their profile, schedules, submit hours, assign homework.

1. Create student account (Reference DD 2.2.1)
2. Enroll into course (Reference DD 2.2.2)
3. Make a payment (Reference DD 2.2.3)
4. Fill out contact form (Reference DD 2.1.6)
5. Faculty login (DD 3.1.11)

1. Load test on 0-200 concurrent users will use the system from 11:00pm-6:00am
2. Load test on 200-750 concurrent users will use the system from 7:00am-3:30pm
3. Load test on 1,000-2,500 users will use the system from 3:30pm-11:00PM
4. Test on failover servers with 2,500 concurrent users during peak hours from 3:30pm-11:00PM