Spring 2012 CSE 3330 Database Systems and File Structures

Course Information:

Time: Tue/Thu 9:30-10:50am
Classroom: GACB 105
Class number: 22553
Homepage: http://crystal.uta.edu/~cli/cse3330

Instructor: Chengkai Li

Office hours: Tue/Thu 11:00-12:00pm, 3:30-4:30pm
Office: Engineering Research Building 652
Phone: (817) 272-0162
E-mail: cli [AT] uta [DOT] edu
Homepage: http://ranger.uta.edu/~cli

TA: Naeemul Hassan (Naffi)

Office hours: Mon/Wed 02:00-04:00 pm
Office: ERB 514
Phone:
E-mail: naeemul [DOT] hassan [AT] mavs [DOT] uta [DOT] edu

Course Description: This is an introductory course on database. We will study database system architecture; file structures for databases, including indexing, hashing, and B+-trees; the relational model and algebra; the SQL database language; Entity-Relationship data modeling; functional dependencies and basic normalization.

Prerequisites: CSE 2320 [ALGORITHMS & DATA STRUCTURES] or CSE 2321 [DATA STRUCTURES FOR NON-ENGINEERS]

Textbook

(Required) Ramez Elmasri and Shamkant Navathe. Fundamentals of Database Systems (6th Edition), Addison-Wesley Publishers, April 2010. ISBN 0136086209.
(Reference) Abraham Silberschatz, Henry Korth, and S. Sudarshan, Database System Concepts, McGraw-Hill Publishers, 2010. ISBN 0073523321.
(Reference) Hector Garcia-Molina, Jeffrey D. Ullman and Jennifer Widom, Database Systems: The Complete Book (2nd Edition), Prentice Hall. 2008. ISBN 0131873253.
(Reference) Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems (3rd Edition), McGraw-Hill Publishers, 2002. ISBN 0072465638.

Grades

Midterm Exam 20% (Thursday, March 8th, 9:30am-10:50am, WH210)
Final Exam 30% (Thursday, May 10th, 8:00am-10:30am, WH210)
Homework (HW) 20% (4 HW assignments, 5% each. Must be done independently)
Projects 30% (3 programming assignments, 10% each. Must be done independently)

Announcements: Stay tuned and make sure to check Blackboard frequently. Important announcements will be posted there.

Assignments and Deadlines

All the assignments must be submitted through Blackboard. We will NOT take hardcopy or email submission, unless the school verifies that Blackboard was malfunctioning or unavailable.
Everything is due by 11:55pm on the due date. The deadline is automatically managed by Blackboard. You can still turn in assignment after the deadline. However, you automatically lose 5 points per hour after the due time, till you get 0. (Each individual assignment is 100 points.) We cannot waive the penalty, unless there was a case of illness or other substantial impediment beyond your control, with proof in documents from the school.

Regrading: Regrading request must be made within 7 days after we post scores in Blackboard. TA will handle regrade requests. If student is not satisfied with the regarding results, you get 7 days to request again. The instructor will regrade, and the decision is final.

Blackboard: Log in to Blackboard with your NetID and password. We use Blackboard for: (1) Announcements; (2) Assignment Submission; (3) Discussion Group; (4) Releasing materials, assignments, scores and grades.

Ethics Policies and Academic Integrity: The College cannot and will not tolerate any form of academic dishonesty by its students. This includes, but is not limited to cheating on examinations, plagiarism, or collusion (explained in the document below). Students are required to read the following document carefully, sign it, return the signed copy to the instructor, and keep a copy for their own records. Hardcopies of this document will be provided to the students in the first class, and also can be picked up in the instructor's office. If you print by yourself, please make it double-sided.

Statement on Ethics, Professionalism, and Conduct for Engineering Students

Miscellaneous: If you require accommodation based on disability, I would like to meet with you in the privacy of my office during the first week of the semester to ensure that you are appropriately accommodated. Please read the page of the office for students with disabilities.

Schedule:

Date	#	Lecture	Assignment		Lecture Notes
Date	#	Lecture	Out	Due	Lecture Notes
01/17	1	Course Overview			[overview]
01/19	2	Introduction			[Ch1] [Ch2]
01/24	3	Relational Data Model			[Ch3]
01/26	4	Relational Data Model	HW1
01/31	5	SQL 1			[Ch4]
02/02	6	SQL 2	P1
02/07	7	SQL 3
02/09	8	SQL 4
02/14	9	SQL 5			[Ch5]
02/16	10	SQL 6	HW2	HW1(Feb. 17th)
02/21	11	SQL 7
02/23	12	SQL 8
02/28	13	SQL programming techniques (by Naeemul Hassan)		P1	[Ch13]
03/01	14	Relational Algebra			[Ch6]
03/06	15	Relational Algebra	P2	HW2
03/08	Midterm Exam (Thursday, March 8th, 9:30am-10:50am, WH210)
03/13	spring break
03/15	spring break
03/20	16	Relational Algebra
03/22	17	Entity-Relationship Model	HW3		[Ch7]
03/27	18	Entity-Relationship Model
03/29	19	Relational Database Design (ER to Relational Mapping)			[Ch9]
03/30	Last day to drop class
04/03	20	Relational Database Design (ER to Relational Mapping)
04/05	21	Relational Database Design (Normalization)		P2	[Ch15]
04/10	22	Relational Database Design (Normalization)	P3
04/12	23	Relational Database Design (Normalization)	HW4		[Lecture Note]
04/17	24	Web database programming using PHP (by Naeemul Hassan)			[Ch14]
04/19	25	Basic file structures and hashing		HW3	[Ch17]
04/24	26	Basic file structures and hashing
04/26	27	Indexing			[Ch18]
05/01	28	Indexing		P3
05/03	29	Overview of Data Mining, Database Research Course Review		HW4	[Data Mining] [review]
05/10	Final Exam (Thursday, May 10th, 8:00am-10:30am, GACB105)

University calendar: Spring 2012