Summer 2012   CSE 3330/5330   Database Systems and File Structures (DB I)

Course Information: Time: Tue/Thu 3:30-5:20pm Classroom: NH110 Class number: 53786 Homepage:  http://idir.uta.edu/~nyan/cse3330

Instructor: Ning Yan Office hours: Wednesday 3:00-5:00pm Office: Engineering Research Building 514 Phone: (682) 227-9412 E-mail: ning [DOT] yan [AT] mavs [DOT] uta [DOT] edu Homepage: http://idir.uta.edu/~nyan

TA: Abolfazl Asudehnaee Office hours: Monday 3:00-5:00pm Office: Engineering Research Building 550 Phone: E-mail: abolfazl [DOT] asudehnaee [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) Hector Garcia-Molina, Jeffrey D. Ullman and Jennifer Widom, Database Systems: The Complete Book (2nd Edition), Prentice Hall. 2008. ISBN 0131873253.
• (Reference) Jeffrey D. Ullman and Jennifer Widom. First Course in Database Systems (2nd Edition), Prentice Hall. 2001. ISBN 0130353000. (Recommend. First part of “Database Systems: The Complete Book”. Get used one for $5)
• (Reference) Abraham Silberschatz, Henry Korth, and S. Sudarshan, Database System Concepts, McGraw-Hill Publishers, 2010. ISBN 0073523321.
• (Reference) Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems (3rd Edition), McGraw-Hill Publishers, 2002. ISBN 0072465638.

Grades

• Midterm Exam                                    25%    (Tuesday, July 10th 3:30pm-5:20pm NH110)
• Final Exam                                         35%    (Tuesday, August 14th 3:30pm-5:20pm NH110)
• Homework (HW1~2)                           20%    (2 HW assignments, 10% each. Must be done independently)
• Programming (P1~2)                           20%    (2 programming assignments, 10% each. Must be done independently)

Announcements: 

·         Project2 is available on BlackBoard. Due day is the end of August 10th (Friday).

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.

MySQL: Use MySQL on UTA Omega server [help] or install MySQL on your own machine [download]. An introduction to database and MySQL from Google Code University [link].

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	Reading Materials
			Out	Due
06/05	1	Course Overview			[overview]
06/07	2	Introduction			[Ch1] [Ch2]	Database History
06/12	3	Relational Data Model			[Ch3]
06/14	4	Basic SQL 1	HW1		[Ch4]	SQL
06/19	5	Basic SQL 2				MySQL CheatSheet  LAB
06/21	6	Basic SQL 3		HW1
06/26	7	More SQL 1	P1		[Ch5]	Join
06/28	8	More SQL 2				Trigger
07/03	9	Relational Algebra			[Ch6]	Relational Algebra
07/05	10	Relational Algebra		P1
07/10	Midterm Exam (Tuesday, July 10th 3:30pm-5:20pm NH110)
07/12	12	Entity-Relationship Model	HW2		[Ch7] [ER]	ER
07/17	13	Relational Database Design (ER to Relational Mapping)			[Ch9] [ER2]
07/19	14	Entity-Relationship Model & Relational Database Design (ER to Relational Mapping)
07/19	Last day to drop class
07/24	15	SQL programming techniques	P2	HW2	[Ch13]	Embedded SQL1 2 SQLJ
07/26	16	Web database programming using PHP			[Ch14]	PHP PHP MySQL API
07/31	17	Functional Dependencies & Normalization			[Ch15]	Lecture Notes FD NORM
08/02	18	(Canceled)
08/07	19	Basic file structures and hashing			[Ch17]	Extendible Hashing
08/09	20	Indexing		P2	[Ch18]
08/14	Final Exam (Tuesday, August 14th 3:30pm-5:20pm NH110)

University calendar: Summer 2012