Database Systems
CSCI 3343 -  Fall 2009 - Tentative Schedule - 12:45 TT

All Labs/Assignments Are Due The Next Class Period Unless Specified Otherwise!

 Class 

Topic's)

 Reading Assignments 
& Handouts

 Laboratory 
Assignments 

 

# 1

1/15

R
Introduction To Class
Intro To Database
Tables
Records
Fields
About Access Database
Creating Database
Adding Records
Deleting Records
Modifying Records
Changing Design
AutoForm
Creating Forms
Form Layouts
 		 Read the Course Outline

 Form Guidelines

Access-CreateDatabase

Access-CreateDatabaseForm

Start Reading
Intro To MySQL

 Questionnaire

Install MySQL on Your Computer

CreateAccessDatabase-HW

CreateAccessForm-HW

 

# 2

1/20

T

 
MySQL - Table Management

SQL
Query
Launching The Command Window
Show Databases
Create Database
Create Table
Show Fields In Table
Show Tables In Database
Basic MySQL Datatypes
Select
Delete Table
Delete Database
 

Finish Reading
Intro To MySQL

DatabaseTableManagement

MySQL-IntroductionToSQL

 SQL-Database-Practice-I-With-MySQL-HW

 

# 3

1/22

R

 

 Quiz 1

Advanced SQL Queries
Entity Relationship Model

Introduction To Database Design
Library System

 MySQL-IntroductionToAdmin

MySQL-Import-Installation Lab

 

# 4

1/27

T

 

 Introduction To Database Design
Library System		 Access-2007-Create-Database-Form

MySQL-IntroductionToAdmin-1

 Create-Access-2007-Suppliers-Products-Forms

 

# 5

1/29

R

 
Relational Databases &
The Normalization Process

Database Interfaces
Command Line
Web Browser
Dedicated Application
ODBC
SQL
Server Architecture Model
Client Architectural Model
Internet Architectural Model
Web Servers - IIS - Apache
Middleware Languages - PHP - ASP - JSP
Edgar Codd - Father Relational Database
Larry Ellison - Oracle
Codd's Three Anomalies
Update, Edit, Delete
First, Second, Third Normal Forms
 

 Relational-Databases SQL-Database-Practice-II-With-MySQL-HW

SQL-Database-Practice-III-With-MySQL-HW

 

# 6

2/3

T

 

 Normalization & Design
Continued		 Kent-Five-Normal-Forms  

 

# 7

2/5

R

 

 

Introduction To Active Server Pages
Set Up ODBC Client On System
Discuss Internet Model

<HTML>  </HTML>
<HEAD>  </HEAD>
<BODY>  </BODY>
<TITLE>  </TITLE>
<B>  </B>
<U>  </U>
<I>  </I>
<P>  </P>
<CENTER>  </CENTER>
<H1>  </H1>
<H2>  </H1>
<H3>  </H3>
<H4>  </H4>
<H5>  </H5>
<H6>  </H6>
<HR>
<BR>
<IMG SRC> 
 <A HREF = “http//google.com”> GOOGLE </A>
 

ASP Functions

http://www.haneng.com/FunctionSearch.asp

ASP Variable Declarations  - Type-Free
DIM N, Conn, Name

If Then Else
If (N = 5) Then
   Response.Write "N = 5"
End If

If (N = 5) Then
   Response.Write "N = 5"
Else
     Response.Write "N <> 5"
End If

HTML Form Tag Sets
<FORM METHOD = POST
             NAME = "LoginForm"
             ACTION = "LogIn-Confirmation.asp" >
</FORM>

HTML INPUT Tag
<INPUT  TYPE = "TEXT"
              NAME ="UserName"
               STYLE= "Color: #840000; Font-Family: Ariel; Font-Weight: bold;
                              Font-Size: 14px; Background-color: #FFFFFF"
               SIZE ="54"
               MAXSIZE = 30>

HTML Submit Button
<INPUT TYPE ="Submit"
              NAME ="Login"
              VALUE ="Login Now!">

HTML Request
UserName = Trim(Request("UserName"))

ASP Response.Write
Response.Write "User Name = " & UserName & "<P>"

IntroHTML Review/Study
HTML, FORMS,Submit
TextBox
CheckBox
ComboBox
Radio Button
Transmission To Confirmation Page

 

# 8

2/10

T

 
Reasons For Learning HTML
Text Edit With Notepad
HTML
WWW
URL
DNS

Use Gimp To Create
Thumb-Nail Image & Link To Full Image

Add This ASP Code For Each ASP Page
<%@ LANGUAGE = VBScript %>
<% Option Explicit %>
<% Response.Expires = 0 %>

HTML Table Tags (2 rows & 3 columns)
<TABLE >
  <TR>
     <TD>    
     </TD>
     <TD>    
     </TD>
     <TD>    
     </TD>
  </TR>

  <TR>
     <TD>    
     </TD>
     <TD>    
     </TD>
     <TD>    
     </TD>
  </TR>
</TABLE >

Setting Focus To An Input Field
<body OnLoad="Document.LoginForm.UserName.focus()">

ASP Redirect
Response.redirect "Error.asp"

ASP Database Constants
'---------------------------------------------------------------------
' Declare ASP Database Constants
'---------------------------------------------------------------------
'---- CursorTypeEnum Values ----
Const adOpenForwardOnly = 0
Const adOpenKeyset = 1
Const adopendynamic = 2
Const adOpenStatic = 3

'---- LockTypeEnum Values ----
Const adLockReadOnly = 1
Const adLockPessimistic = 2
Const adLockOptimistic = 3
Const adLockBatchOptimistic = 4

Const adModeReadWrite = 3
 

Create a Connection Object
Set Conn = Server.CreateObject ("ADODB.Connection")

Open The LibraryApp MySQL Database
And Associate It With The Connection Object
Conn.Open "LibraryApp"

Associate A Simple Query With Variable SQL
SQL=   " SELECT First   "      &_
           " FROM Users     "   

Create A RecordSet Object
Set RecSet = Server.CreateObject( "ADODB.Recordset")


Fill The Record Set Object With The Results Of The Query
RecSet.Open SQL, Conn, adOpenDynamic, adLockOptimistic

Do While Loop

Counter = 1
Do While (Counter <= 10)
       Response.Write Counter
       Counter = Counter + 1
Loop

Do While Loop 1
Counter = 10
Do While (Counter >= 1)
      Response.Write Counter & "<BR>"
      Counter = Counter - 1
Loop

Do While Loop 2
Counter = 10
Do While (Counter >= 1)
      Response.Write Counter & "<BR>"
      Counter = Counter - 1
Loop

Do While Loop 3
Do While NOT RecSet.EOF
.
.
.
RecSet.MoveNext
Loop

Extract Fields From Record Set
First Name = <% = RecSet.Fields ("First")
 

Do While Through Records
<%
Do While NOT RecSet.EOF
Counter = Counter + 1
%>

First Name = <% = RecSet.Fields ("First") 

<%
RecSet.MoveNext
Loop
%>
 

  MySQLL-LibraryApp-Login Lab

 

# 9

2/12

R

 

 Review ASP Database Connections
Review Tables, Forms, Connection Strings, Record Sets, etc.

Add Major

Delete Major

Display Majors

  
Server Team Member I
Due By 5:00 PM On Friday 2/20

 MySQL-LibraryApp-Display-Users Lab

MySQL-LibraryApp-Add-User Lab

MySQL-LibraryApp-Delete-User Lab

 

Server Team Member II
Due By 5:00 PM On Friday 2/20

 MySQL-LibraryApp-Display-Books Lab

MySQL-LibraryApp-Add-Book Lab

MySQL-LibraryApp-Delete-Book Lab

All pages LibraryApp pages on your server (both team members) shall follow a common design format. Agree on something.

None of the pages should take you more than 30-60 minutes to do; you are welcome to do them together if you like.
 

 

# 10

2/17

T

 

 Exam I User-Friendly-ASP-Error-Messages  

 

# 11

2/19

R

 
Introduction To Asp Functions
Error.asp
Session Variables
Session("ErrorMessage") = "???"

Robustness

  
 

Server Team Member I

 MySQL-LibraryApp-Edit-User Lab

MySQL-LibraryApp-Delete-Revisited Lab


 Server Team Member II

 MySQL-LibraryApp-Edit-Book Lab

MySQL-LibraryApp-Delete-Revisited Lab

Server Team

MySQL-LibraryApp-Display-Transactions Lab

MySQL-LibraryApp-Add-Transaction Lab


 

 

# 12

2/24

T

 
SQL Injection
Database Security

Introduction To Asp Functions
Error.asp
Session Variables
Session("ErrorMessage") = "???"

ASP Functions

 SQL-Injection & Form Verificaton.pdf  

 

# 13

2/26

R

 
Data Validation
Data Representation
ASP Support Functions

ASP Include Files
<!--#include file="ASP-Database.inc"-->

Function CleanString
Function ValidateInteger
Function ValidateFloat
Function StrNumericString(String)
Function NumericString(No)
Function CompressMultipleBlanks(String)
Function StrMoneyString(String)
Function MoneyString(No)
Function Upper(String)
Function Lower(String)
Function Proper(String)
Function RPad (String, NoChars)
Function LPad (String, NoChars)

 

 FunctionSearch.asp MySQL-LibraryApp-Form-Validation Lab

 

# 14

3/3

T

 

 .NET
Microsoft SQL Server 2008

Introduction to .NET Forms Using C#


Windows-Forms-Basic-Form

Windows-Forms-Label-Textbox

Windows-App-Form-Buttons-Color-Picker

Form Guidelines  

 Make Sure You Have Done
All Three Of The Tutorials
Put Projects Created On Ananke
Use Different Colors Than I Did

 

# 15

3/5

R

 

 .NET
Menu Options &
Form Navigation		 Visual-Studio-Windows-App-Form-Menu-Multiple-Forms

Visual-Studio-Windows-App-Form-MenuStrip-Apps

  

 

 

3/10

T

 

 Spring Break

 

 

3/12

R

 

 Spring Break

 

 

# 16

3/17

T

 

 Indexing A MySQL Database
Importance Of Indexing

MySQL Backup-Recovery
MySQL Administrator vs Navicat

Hints About Installation
Using Management Studio Express
Importing MySQL Databases With Full Convert
Microsoft Studio Express Backup-Recovery

Install-SQL-Server-Advanced.pdf
SQL-Server-Express-2008-Adv-Install

MSSQL-Server-Management-Studio-DB-Construction

MSSQL-Server-Management-Studio-Import-Export-Backup
 

 Install SQL Server 2008 Advanced On Your System

Do All Three Tutorials
In Their Entirety

 

# 17

3/19

R

 

 Complete
.NET
Tutorial		   MSSQ-Database-Google-Windows-Form-App-1

MSSQ-Database-Google-Windows-Form-App-2

Tutorial Split In Half
Technical Difficulties Accessing Site
At Hotel

Do Both Tutorials
Understand Code
Put The Files You Develop On
Your Ananake Account

 

 

# 18

3/24

T

 

 Work On .NET
Project		   Do Both Tutorials
Understand Code
Put The Files You Develop On
Your Ananake Account

 

# 19

3/26

R

 

    Work On Take Home   MySQL-VS-Data-Grid-View-Net Lab

MSSQL-1 HW

MSSQL-2 Lab

 

# 20

3/31

T

 

 Remote System Administration
MySQL		   Remote MySQL

 

# 21

4/2

R

 

 Microsoft SQL Server
User Configuration

Record Lock Out

    

 

# 22

4/78

T

 

      

 

# 23

4/9

R

 

 Concurrency - Multi-User Rec-Lock-Out-Multi-User-LibraryApp-1  

 

# 24

4/14

T

 

  

SQL Server
Record  Lockout Application

 Rec-Lock-Out-Multi-User-LibraryApp-1 

Rec-Lock-Out-Multi-User-LibraryApp-2

Rec-Lock-Out-Multi-User-LibraryApp-3

 

  

 

# 25

4/16

R

 

 SQL Server
Record  Lockout Application		   Server Reinstall Lab
Due 4/21

 

# 26

4/21

T

 

 SQL Server
Systems Administration &
Authorization		 MSSQL-Server-Administration-1 Go Through Tutorial

Multi-User-NET-Library-App-Login Lab
Due 4/23

 

# 27

4/23

R

 

 SQL Server
Systems Administration &
Authorization
Develop Concurrency Model		 MSSQL-Server-Administration-1 Get Next, Previous, Top, Bottom
Working On Both Users &
Books

 

# 28

4/28

T

 

 Navigation Controls   Multi-User-NET-Library-App-Navigation
Due 4/30
Will Accept By Noon On
5/4 With No Late Penalty

Multi-User-NET-Library-App-Record-Lock-Out
Turn In When Finished
Will Not Be Accepted After 9:00 AM
Monday May 11th
 

 

# 29

4/30

R

 

 Edit & Normal Modes   Work On Project

5/4
5/5

 Reading Days Reading Days

 

5/7

 

 Record Lock-Out
Workshop
 

No assignments will be accepted after 9:00 AM on May 11th