COMP SCI 451 Database Application and Design-- Fall 2009

 Professor:  William Shay             Office:  MAC C308             Phone:  465-2316/5038

Click here to get the course syllabus

Click here to get the course policies


During the semester I will be posting some powerpoint notes that outline course lectures:

  1. Introduction to database and relevant data structures.
  2. Data Modeling with ER Diagrams.
  3. Creating tables from ER diagrams.
  4. Working with SQL Server.
  5. Understanding SQL.
  6. C# and ADO.NET.
  7. Normalization.
  8. Relational Algebra and Optimization.
  9. Concurrency, security, recovery.

For Fall 2009 we will use C# to build database applications and I will provide some demo programs. When they are ready I will make them available below.

  1. C# and ADO.NET program to run against a simple Packers player database.
  2. Multiform project with abilities to update the database and produce lists consisting of data from multiple tables.

 


If you have any questions or need to contact me, please send email to Bill Shay at the University of Wisconsin-Green Bay

Last update on: December 1, 2009