COURSE DESCRIPTION

Course objectives:

  • To introduce elements of Web site design and creation
  • To introduce elements of database design, creation, and maintenance
  • To introduce relational database concepts
  • To explore the use of a database in an interactive Web application

The course will cover the following topics:

  • XHTML: basic text markup, images, links, lists, tables, forms
  • CSS: style sheet, selector, font properties, list properties
  • JavaScript and HTML documents
  • Database: Introduction
  • Database design: Entities, Attributes, Keys, Relationships, ER model
  • Database: Relational model, mapping an ER model to a Relational model
  • Database: DBMS Access, Access SQL
  • ASP: Introduction

RECOMENDED READINGS

left 

 

 

 

 

 

 

Database Illuminated.
C. Ricardo
Jones and Bartlet, 2004
ISBN:0-7637-3314-8

SebestaBook

 

 

 

Programming the World Wide Web
R.W Sebesta (5th edition or more)
Addison Wesley, 2009

ISBN-10: 0136076637;

ISBN-13: 978-0136076636



 

 


Grading Criteria/Course requirements

Test 1

15%

Test 2

20%

Final exam

35%

Assignments/Labs

PRISM LAB SCHEDULE

30%

 


 

 

 

 

TENTATIVE SCHEDULE

 

Please, be aware that
the content of the table below will change during the semester.
Have a look before every session of the course!

 

 

 

 

 

Week

Date

Subject

To read

Miscellaneous

 

 

 

 

1

January 10

  • Course introduction
  • Introduction to XHTML

About WWW

Introduction to XHTML

XHTM versus HTML    

 

Sebesta: Chapters: 1 - 2

HTML/XHTML editor: Arachnophilia

XHTML: link 1, XHTML Validator
CSS: link 1 , CSS Validator
Java Script: link
ASP: link

 

2010_Example_Forms.html

 

 

 

 

2

January 17

  • Introduction to XHTML  
  • Introduction to CSS

Introduction to XHTML (please print)

Introduction to CSS  (please print)

 

Sebesta: Chapters: 1 - 3

2010_Embed_CSS.html

2011_Simple_Selector.html

2011_example_1.html

2010_Img_Repeat.html

2010_Float.html

2010_CSS_Table_1.html

 

 

 

 

 

 

3

January 24

  • Introduction to CSS
  • Introduction to JavaScript

JS and XHTML  (please print)

Introduction to JavaScript: part 1 (please print)

 

Sebesta: Chapter 4

2010_js_example_0_0.html

2010_js_example_0_1.html

2010_external_js.txt

2010_external_js.html

2010_external_2.txt

2010_example_functions.html

2010_example_function_with_argument.html

2010_Example_Function_Return.html

2010_sesame.html

2010_open_sesame.html

2010_computing_1.html

Assignment 0 is on the Web (assignments page)

 

 

 

 

 

4

January 31

  • Introduction to JavaScript

 

Introduction to JavaScript: part 2 (please print)

Introduction to JavaScript: part 3 (please print)

2010_Strings_Functions.html

2010_Loops.html

2010_JS_Arrays.html

2010_Arrays_Functions.html

2010_IF_Example.htm

2010_borders.html

2010_borders.txt

2010_Loops.html

2010_Luhn_Algorithm.html

2011_Pattern_Matching.html

Assignment 1 is on the Web (assignments page)

 

 

 

 

5

February 7

  • Introduction to Databases
  • Entity-Relationship Model

From this point please print all documents below.

Database History

Database Design Steps

Database Users

Entity-Relationship Model

Hospital (problem) 1

Review Questions 1

 

 

 

 

6

February 14

  • Relational Model
  • Mapping EER to relational
  • Review for Test 1

Relational Model

Hospital (problem) 2

DB Museum (problem) 1

 

 

 

 

 

 

February 21

Family Day

No class

Reading week

 

 

 

 

 

7

 February 28

Test 1

  • Mapping EER to relational

Mapping EER to Relational Model

 

 

 

 

 

 

8

March 7

  • Normalization
  • Test 1 Solutions

Normalization

Hospital 2

 

 

 

 

 

9

March 14

§  Normalization

  • Access SQL

Hospital 3

DB Museum 2

ACCESS_SQL_1

 Review Questions 2 (these questions represent an addition to the previous list; consider both lists for your review)

 

 

 

 

10

March 21

Test 2

  • Access SQL

Study all the above.  It is a cumulative test.

ACCESS_SQL_2

 

 

 

 

 

11

March 28

 

  • Access SQL

Please, be aware that the first hour of the course we will discuss the XHTML document (already distributed in class) for assignment 3.

 

 

 

 

 

 

 

12

April 4

  • Access SQL
  • Introduction to ASP

How to install IIS on Windows 2000

How to install IIS on Windows XP or Windows 7

ASP_1

ASP_2

ASP_3

ODBC

HOSPITAL DATABASE

 

 

 

 

 

 

Final exam

 

 

Tuesday, April 19, 2011

14:00-17:00

CB 115

Study all the above.  It is a cumulative test.

 

Test Grade Annulment Form

 

 

 

 

 

 

 

·        Appeal Procedures

·        Available Help

·        Laboratory Work

·        Course Assessment and Grading

·        Information from Senate University