CSE 412/598 Database Management

Fall 2005 Semester Syllabus

http://www.eas.asu.edu/~cse412

PROFESSOR: Charles J. Colbourn

OFFICE: Brickyard 444

OFFICE HOURS: W2-3, Th 2-3 (Tentative)

PHONE: 480 727-6631 (rarely answered, email works much better!)

EMAIL: Charles.Colbourn@asu.edu

TEACHING ASSISTANT: Yang Xiao

OFFICE HOURS FOR TA: M9-10, T 4-5 in BY490

EMAIL: yang.xiao@asu.edu

CLASS SCHEDULE: TuTh 9:15-10:40 BYAC 240

CATALOG DESCRIPTION:

Introduction to DBMS concepts. Data models and languages. Relational database theory. Database security/integrity and concurrency.

PREREQUISITE: CSE 310 (Data Structures). This is mandatory.

REQUIRED TEXTS:

Fundamentals of Database Systems, R. Elmasri and S. B. Navathe, Addison Wesley, 4th Ed., 2004.

Understanding Relational Database Query Languages, S. W. Dietrich, Prentice Hall, 2001.

OPTIONAL TEXT FOR ACCESS and ORACLE:

The Dietrich text provides some coverage of Microsoft Access (see Chapter 7). There are many books available on Access and Oracle. Since students differ in the type of information that they are looking for from a book (tutorial, overview, in-depth), an optional text has not been ordered. However, it is highly recommended that you find a tutorial or reference manual on the database products according to your own level of experience with the tool.

ADDITIONAL REFERENCES:

Database Systems Concepts, A. Silberschatz, H. Korth and S. Sudarshan, McGraw Hill.

An Introduction to Database Systems, R. Ramakrishnan and J. Gehrke, McGraw Hill

An Introduction to Database Systems, C. J. Date, Addison Wesley.

A First Course in Database Systems, J. Ullman and J. Widom, Prentice Hall

Database Systems Using Oracle: A Simplified Guide to SQL and PL/SQL, N. Shah, Prentice Hall

OBJECTIVES OF THE COURSE:

This course is intended to give students an understanding of data modeling concepts and the relational data model for the storage and retrieval of information. The retrieval of information emphasizes the formal query languages and the industry-standard query language SQL. Detailed course objectives and outcomes are provided on the Beginning of Semester survey that must be completed by each undergraduate student by the end of the first week of classes. The course objectives are also available on myASU.

COURSE OUTLINE (see COURSE CALENDAR for a detailed timetable):

Topic Elmasri & Navathe (4 th ed.) Dietrich

Introduction Ch 1, 2 Ch 1.1

Database Design Ch 12.2

Entity-Relationship Model Ch 3 Ch 1.2

Relational Model Ch 5 Ch 1.1

ER-to-Relational Mapping Ch 7.1 Ch 1.3

Relational Algebra Ch 6.1-6.5 Ch 2

Query Process, Optimization Ch 15.7 Ch 2.5

Microsoft Access Ch 7

Relational Database Design Ch 10, 11.1-11.2

Relational Calculus Ch 6.6–6.7 Ch 3, 4

SQL Ch 8, 9.1–9.2 Ch 5

Security and Authorization Ch 23.1–23.4 Ch 5.6.3

Transactions, Recovery and

Concurrency Ch 17, 18, 19

ASSESSMENT:

Assessed Component Weight Activity

Project Group & Individual

Phase 1: Requirements Analysis & Conceptual Design 5% Group

Phase 2: Relational Database Design and Prototyping 10% Group

Phase 3: Implementation 10% Individual

WinRDBI Homework Assignments Individual

Relational Algebra 6% Individual

Relational Calculus (DRC and TRC) 7% Individual

SQL 7% Individual

Midterm Exam 25% Individual

Comprehensive Final Exam 30% Individual

Total 100%

ONLINE EXPECTATIONS AND PROCEDURES:

CSE 412 is an online-enhanced course utilizing myASU. All participants in the course (instructor, teaching assistants, and students) are to visit the course site for announcements and check their registered email address on a daily basis (Mon-Fri). Every effort should be made to respond to email, if required, within two working days. Assignments are submitted electronically on myASU and by hardcopy in class. Groups will be set up using myASU to facilitate group communication.

IMPORTANT! Materials on the cse412 web site (http://www.eas.asu.edu/~cse412) may differ from those on myASU. You MUST follow the information provided on myASU under Course Documents -> Group Projects.

LATE ASSIGNMENTS ARE NOT ACCEPTED!

WinRDBI individual homework assignments and the different phase deliverables of the project will be turned in at the beginning of class on each due date. WinRDBI assignments will be submitted through myASU before the start of class (as well as a hardcopy in class) and solutions to the WinRDBI assignments will be posted on myASU at the start of class.

MAKE-UP EXAMS ARE NOT GIVEN!

Midterm Exam: Thursday, 6 October 2004 9:15-10:30am

Final Exam: Thursday, 8 December 2004 7:40-9:30am

TEAM PROJECT:

The incorporation of a semester-long team project into the introductory database course was developed through a funded grant that was received by Dr. Suzanne Dietrich and Dr. Susan Urban from the National Science Foundation for the purpose of incorporating cooperative learning concepts and hands-on database experience into the undergraduate educational process. The project is also designed to allow students to experience different leadership roles and to develop communication skills, in addition to the development of technical knowledge about database systems. The project is divided into three major phases. The first two phases are group activities, leading to a prototype relational database implementation in Microsoft Access. The third phase is individual, requiring the implementation of the database in Oracle. Graduate and honors students will have additional implementation requirements in phase 3. Teams will be formed and phase 1 of the project will begin by the second week of the semester.

ACADEMIC INTEGRITY AND CODE OF CONDUCT

ASU Academic Integrity Policy: http://www.asu.edu/studentlife/judicial/integrity.html

CSE 412/598 follows the ASU Academic Integrity Policy in the administration of all course examinations and assignments.