CS 327E - Elements of Databases: Home Page

# CS 327E (extension course) - Elements of Databases: Home Page

# The University of Texas at Austin

# University Extension Course

# Fall 2003

# Class Unique #: 65085

# Class Location: Parlin Hall Building-PAR 304

# Class Timing: Thu: 6.00pm – 9.00 pm

## Objectives

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.

## Prerequisites

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.

## Course Text (s)

## Instructor

Ajay Bhargava

Office: PAI 5.44

Office Hours: Fri 10 a.m.- 11 a.m., and by appt.

Office Phone: 512-471-9723 (do not leave a message)

Mobile Phone: 512-791-0158

Email: ajay@cs.utexas.edu

## Teaching Assistant

For all questions relating to the course, including scores on tests/labs/quizzes, consult:

Mallela, Subramanyam

Office: PAI 5.40

Office Hours: Wed 2 p.m.- 4 p.m.

Office Phone: (512) 232 7412

Email: manyam@cs.utexas.edu

## Proctor

For all questions relating to lab acct, Java, SQL Server, consult Prashanth in the Elements Lab:

    Prashanth Govindarajan

Office: PAI 5.38

Office Hours: Tue: 11-1:30pm, 3:30-7pm; Thu: 11-1:30pm, 3:30-5pm

Office Phone: (512) 471-9735

Email: pgovinda@cs.utexas.edu

## Course Web Site

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/

Fall 2003: Course information and announcements will be available here. This site will be updated during the semester, and various items will be posted over time.

## Course Policies

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.

## Grading

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.

## Attendance

## Lab Assignments/Tests/Quizzes Policies

### Labs

Lab 1

Lab 2

Lab 2 Solution

Lab 3

Lab 3 Solution

Lab 4

Lab 4 Solution

Lab 5

Lab 5 Solution

### Quiz

### Tests

Test 1 Solution

Test 2 Solution

## Group Project

## Other Policies

## Parking

Parking facilities can be found by going to the link above. Typically, shuttle buses are available from different parking lots. Also, for the different parking garages, there is a night pass available for the semester.

## Use of UT Libraries

You can get a courtesy borrower’s card by taking your course receipts to the PCL Circulation Desk. This will allow you to use reserve materials, special databases, and to check out books. If you need remote access to the library, then you need to come by the extension office to activate your EIDs.

## Important Dates

## Other Useful Links

SQL Server

1) SQL Server Home Page

2) SQL Server Books

3) SQL Server Documentation

4) Querying SQL Server System Catalogs

5) SQL Server Service Pack 3

6) ODBC and SQL Server

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

16) SQL Sever Communities

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

21) http://www.xml.org/

22) http://www.xml.org/xml/resources_focus_beginnerguide.shtml

23) http://www.xml.org/xml/resources_sites.shtml

24) http://xml.apache.org/

25) http://www.w3.org/XML/

26) http://www.xml.com/

27) http://www.ucc.ie/xml/

28) http://java.sun.com/xml/

29) http://xml101.com/

30) http://www.w3schools.com/xml/default.asp

31) http://www.chez.com/xml/

32) http://xml.oreilly.com/

33) http://www-106.ibm.com/developerworks/xml/

34) http://www.xml.it:23456/

35) http://msdn.microsoft.com/library/default.asp?url=/library/en-s/xmlsdk30/htm/xmtutxmltutorial.asp

36) JDBC and Stored Procedures

37) PHP and SQLServer

38) PHP and mySQL Web Development

39) Microsoft ODBC Architecture

40) ODBC OpenLink Software

41) ODBC Object Tools

ORACLE

42) To join Oracle Technology Network, your free resource for developing applications on the Oracle Internet platform.

43) SQLJ and JDBC sample code

44) Oracle Books for material on Oracle 9i.

45) XML and Oracle.

46) Oracle Product Documentation Online

47) Oracle and Java, JSP, SQLJ, JDBC etc.

48) Tomcat, Oracle, and JSP sample code

49) http://wdvl.internet.com

50) Oracle Certification

Data Modeling/MISC

51) Modeling Matters

52) DeZign Databases: ER Modeling tool (limited version for free). Other tools include Visio and ERWin.

53) Table Designer ER Modeling tool (1 month trial version free)

54) Grades Program for cs327e (.zip file)

Last Updated: 11/10/2003 9:51:55 PM