Stanford - Database Course

Recursion Q1 - Version 2

Ken Evans — Sun, 17 Mar 2013 15:39:51 GMT

I find it easier to understand diagrams rather than words.

This PowerPoint presentation is my second attempt to represent Question 1 in diagrammatic form.

The presentation shows the first cycle in the recursion process.

It is provided here so that my fellow students on the Stanford University "Introduction to Databases" course can make suggestions on how to improve the presentation so that it gives a correct representation of Question 1 in the Recursion quiz in particular. I hope that this also gives an insight into SQL recursion in general.

Browser warning: This download works well in Chrome but not in IE9. (at least that is the case on my Win 7 64 bit system)

Transactions in Web Apps

Ken Evans — Wed, 13 Mar 2013 01:10:01 GMT

This presentation was developed to answer a student's question about transactions in the "Introduction to Databases" course run by Professor Jennifer Widom of Stanford University in California.

Recursion Q1 - Version 1

Ken Evans — Tue, 12 Mar 2013 20:37:40 GMT

I get a much better understanding of things when I use diagrams rather than words.

This PowerPoint slide is my attempt to represent Question 1 in diagrammatic form.

I know that this diagram is not complete.
It is provided here so that my fellow students on the "Introduction to Databases" course can make suggestions on how to improve the diagram so that it gives a correct representation of Question 1 in the Recursion quiz.

For ease of reference, the "Notes" part of the slide contains the text of question 1.

Finding keys using Functional Dependency Theory

Ken Evans — Tue, 12 Feb 2013 10:46:11 GMT

This file shows you how to analyse functional dependencies in order to find keys.

You watch a 10 minute video (link in the document) and then use the analysis sheet.

IE9 - Class2go error message

Ken Evans — Thu, 07 Feb 2013 08:57:52 GMT

This is the message that I get when I browse to the clss2go website (6 & 7 February)

DDL for the SQL database videos

Ken Evans — Wed, 30 Jan 2013 15:21:24 GMT

This is the DDL for the "stanford" database that is used in the online Database course taught by Prof Jennifer Widom of Stanford University (CA).

The zip file contains two files:

One is the original file and the other is DDL for the same schema but in T-SQL.

DDL for Denise

Ken Evans — Wed, 30 Jan 2013 10:15:37 GMT

This zip file contains five files:

1. An image that shows a schema that represents the data that is stored in an Excel spreadsheet that was shown by DeniseD on the database course run by Stanford University.

2: Three files that contain the DDL

2.1 DDL for MS SQL Server

2.2 DDL for MySQL

2.3 DDL for ANSI Standard SQL (should work with any RDBMS)

3. An XSD file of the schema (useful for understanding the difference between a schema represented in DDL and the same schema represented in XSD.

Database Schema for Denise

Ken Evans — Tue, 29 Jan 2013 22:53:05 GMT

This image shows a schema that represents the data that is stored in an Excel spreadsheet that was shown by DeniseD on the database course run by Stanford University.

Integer Data Types - SQL Server 2012

Ken Evans — Wed, 23 Jan 2013 15:01:15 GMT

Shows the data types and value ranges for the integer data types in SQL Server 2012

Person

Ken Evans — Mon, 21 Jan 2013 21:27:28 GMT

table image