The most important goal of this course is to introduce students to
the concepts of good Database Design. In addition, Database management systems
(DBMS) are a focus of study, and database administration and management are
also discussed. Techniques for conceptual, logical, and physical database
design are surveyed, with emphasis on relational databases. Topics also include
history of database management systems, ER modeling, normalization, SQL, stored
procedures and triggers, data integrity, performance, concurrency, transaction
processing, data warehouse, and security. The main focus in this course will be
on practical applications. Students will be using MS-SQL Server 2000 as the
DBMS for labs and group project, and Java as the programming language.
The prerequisites are CS 303e and CS 313e, each with a grade of C
or better. Prerequisites must be completed before enrolling in this
course. This course may not be counted toward a degree in computer science.
Office: PAI 5.44
Office Hours: Fri
Office Phone: 512-471-9754 (do not leave a message)
Mobile Phone:
512-791-0158
Email: ajay@cs.utexas.edu
For all questions relating to the course, including Java, SQL
Server, scores on tests/labs/quizzes, consult:
TBD
Office: TBD
Office Hours: TBD
Office Phone: TBD
Email: TBD
For all questions relating to lab acct, Java consult:
TBD
Office: TBD
Office Hours: TBD
Office Phone: TBD
Email: TBD
Spring 2005: http://www.cs.utexas.edu/users/ajay/2005/spring/cs327e/
Fall 2004: http://www.cs.utexas.edu/users/ajay/2004/fall/cs327e/
Spring 2004: http://www.cs.utexas.edu/users/ajay/2004/spring/cs327e/
Fall 2003: http://www.cs.utexas.edu/users/ajay/2003/fall/cs327eExt/
Fall 2003: http://www.cs.utexas.edu/users/ajay/2003/fall/cs327e/
Spring 2003: http://www.cs.utexas.edu/users/ajay/2003/spring/cs327e/
Fall 2002: http://www.cs.utexas.edu/users/ajay/2002/fall/cs327e/
Spring 2002: http://www.cs.utexas.edu/users/ajay/2002/spring/cs327e/
Fall 2001: http://www.cs.utexas.edu/users/ajay/2001/fall/cs327e/
Spring 2005: Course information and
announcements will be available here. This site will be updated during the
semester, and various items will be posted over time.
You are responsible for reading and
referring to these policies when you have questions during the semester. You
need to write down any changes or additions made in class announcements, to
keep yourself up-to-date.
Course grades will be determined as
a weighted average, based on the following:
20% Tests (2)
30% Group Project (1)
42% Labs/Assignments (6)
8% Pop Quiz (1)
There will be no Final Exam for
this course.
Note: For the purposes of
discussion, I will loosely refer to Tests, Project, Assignments/Labs, and pop
quizzes as “Exams”.
The weightage, and the number of
tests/assignments/pop quizzes may change during the course.
The course grade will be determined
after the project submission, based on overall course performance and assigned
as follows:
>=90 A
>=80 and < 90 B
>=70 and < 80 C
>=60 and < 70 D
< 60 F (not passing)
The instructor
reserves the right to alter the grading scale to the benefit of the students.
SQL
Server
4) Querying
SQL Server System Catalogs
7) Choosing
from 7 different editions of SQL Server 2000 (.zip file)
8) SQL
Server 2000 Product Guide (.zip file)
9) How
to connect to SQL Server from Enterprise Manager (at home or in the lab)
10) How
to connect to SQL Server from a Java application (at home or in the lab)
(.zip file)
11) SQL
Server Transact-SQL syntax (SQL Syntax for SQL Server 2000)
12) SQL
Server CREATE PROCEDURE and CREATE TRIGGER syntax (reference a) (.zip file)
13) User
and Security Management (reference a) (.pdf file)
14) MS SQLServer Training and
certification program
15) SQL Server
Stored Procedure example
SQL/JAVA/ODBC/JDBC/XML/JSP/PHP/DB
DESIGN
17) Java
Database Connections: IBM Learning Services. Free tutorial on
connecting to databases using Java.
18) Free Tutorials from
SUN including JDBC
19) What is XML?
20) JSP
Tutorial
22) http://www.xml.org/xml/resources_focus_beginnerguide.shtml
23) http://www.xml.org/xml/resources_sites.shtml
30) http://www.w3schools.com/xml/default.asp
33) http://www-106.ibm.com/developerworks/xml/
35) http://msdn.microsoft.com/library/default.asp?url=/library/en-s/xmlsdk30/htm/xmtutxmltutorial.asp
36) JDBC and
Stored Procedures
39) PHP and
mySQL Web Development
40) PHP and
mySQL
41) Stored
Procedures and mySQL
42) Microsoft
ODBC Architecture
ORACLE
45) To join Oracle
Technology Network, your free
resource for developing applications on the Oracle Internet platform.
47) Oracle
Books for material on Oracle 9i.
48) XML and Oracle.
49) Oracle Product Documentation
Online
50)
Oracle
and Java, JSP, SQLJ, JDBC etc.
51) Tomcat, Oracle, and JSP
sample code
Data
Modeling/MISC
54) Modeling
Matters
55) DeZign Databases:
ER Modeling tool (limited version for free). Other tools include Visio and ERWin.
56) Table Designer ER Modeling tool (1
month trial version free)
Last Updated: 8/10/2005 11:53:52 AM