CSE691 - Comparative Platfroms

Lecture #5 - Relational Data Model

Revised: 19 June 2007
Home Courses Code Handouts CoreTech Books Articles Math Research Masters Projects SWDev WebDev News OtherLinks SiteDesign Graduates AllPages Office Hours Notices Contents
CSE681-SWMAA CSE686-IP CSE687-OOD CSE691-CP CSE775-DO CSE776-DP CSE778-AWP CSE784-SWS
Lecture #01 Lecture #02 Lecture #03 Lecture #04 Lecture #05
Lecture #06 Lecture #07 Lecture #08 Lecture #09 Lecture #10
Lab #01 Lab #02 Lab #03 Lab #04 Lab #05 Lab #06 Lab #07 Lab #08
Contents Syllabus

Web Resources:

Color Lab Color Codes HTML tags Everything HTML XML, HTML, Scripting Win32, COM, MFC webdeveloper.earthweb devx... W3Schools Web Developer's Virtual Library World-Wide Web Consortium WebReference devCentral

Office Hours:

Instructor & TAs

Content:

This lecture is concerned with Relational Databases and Active Data Objects and focuses on Examples relevant to the Final Project.

SQL Server:
SQL Data Types, Time Interval Data Types,
Structured Query Language (SQL) Tutorials:
steelarrow, SqlZoo, w3schools, Microsoft PDC, GeoCities, sqlTeam, sqlCourse2, sql-tutorial, XML to and from SQL, Introduction to SQL, SQL - Cal State Lecture Notes, SQL Tutorial, firstsql,
Active Data Objects (ADO):
Accessing Data with ADO.NET, Accessing Data with ASP.NET,
  1. Syllabus describes topics to be covered, reading material for you to digest before coming to class, and due dates for the assigned projects.
  2. Final Project

  3. Relational DB Tutorial

    Cal State Class Notes

  4. ADO Tutorials

    GotDotNet ADO
    GotDotNet ASP with Data
    Single Table Commands

  5. Security

    Excellent .Net Security Tutorial
    Understanding .Net Code Access Security

    6. Relation Data Model

  6. The Relational Database Model
  7. Database Project
  8. Books Database
  9. Northwind Database
  10. Console Database
  11. Murat's Queries with Joins Presentation

    12. AspSQL Examples

    College server does not have SQL Server installed, so the following demos are running on my laptop. Projects need configured virtual directories to run. These links will function only on my laptop. I expect that SQL Server will be installed on the college server soon. When that happens, I will modify the links so they will work for you in the computer labs or at home.
  12. SWProductsDB ASPX Data Reader
  13. ASP.NET/ADO Managing XML
  14. SimpleDataReader Demo, SimpleDataReader folder
  15. SimpleDataSet Demo, SimpleDataSet folder
  16. DataGrid Details Demo, DataGrid Details folder
  17. Lab Assignment #7
  18. Lecture #7 folder contains a page of links to presentations and code discussed in this class. The Lecture folders will occasionally hold physical files of interest as well. Usually, however, all the materials of interest to the class are in the presentations and code folders. The contents of these folders will grow as you progress through the course.