Class Information (text, goals, etc)
Academic Integrity and Decorum
CPSC 211 or 221 (Data Structures)
June 1 Monday, class begins
June 4 Thursday, 5 p.m. Last day for adding/dropping courses.
July 1 Wednesday, Mid-term Exam
July 20 Monday, 5 p.m. Last day to drop courses with no penalty (Q-drop).
August 5, Wednesday, Last class day for this course
August 10, Monday, Final Exam, 4-6pm
Ronnie Ward
HRBB 315B, Office Hours: 2-4pm MW
Please send me an email to arrange an appointment
http://faculty.cse.tamu.edu/ward
Name: Huei-Fang Yang
Office: HRBB 322A
Office Hours: 2-4pm TR
Email: hfyang@cse.tamu.edu
Database Design and Implementation, Ed Sciore, Wiley, 2008.
Website: Student Companion Site
Other material:
"SimpleDB: A Simple Java-Based Multiuser System for Teaching Database Internals." Proc. ACM SIGCSE Conference on Computer Science Education, March 2007, by Edward Sciore [PDF]
Derby Database Management System
Eclipse Development Environment for Java
File structures and access methods; database modeling, design and user interface; components of database management systems; information storage and retrieval, query languages, high-level language interface with database systems.
1. Understand database application design, and implementation
2. Learn SQL and use Java to implement database applications
3. Learn to use open source database systems MySQL and DERBY
4. Understand database management system (DBMS) implementation
5. Learn the implementation of the SimpleDB database system
TAMU email address that you monitor daily
Two exams
8 Weekly homework assignments
2 development projects in Java and SQL using open source DBMS systems such as Derby or MySQL
Work in project teams
Textbook reading as well as reading other assigned materials
Attend class, take notes, and participate in class discussion
Students will have to spend around 15 hours per week in addition to class time.
|
June 1 |
Introduction: Why a Database Systems |
Chapter 1 |
|
|
Clients and servers |
Chapter 7 |
|
|
Eclipse, SimpleDB, Derby environments |
Documentation |
|
June 3 |
Relational model, keys, constraints |
Chapter 2 |
|
|
Class diagrams, functional dependencies, |
Chapter 3 |
|
|
normalization |
|
|
June 8 |
Relational Algebra and SQL |
Chapter 4 |
|
|
Derby demonstrations |
Documentation |
|
June 10 |
Assertions, triggers, stored functions |
Chapter 5 |
|
|
Materialized views, indexing |
Chapter 6 |
|
|
Derby demonstrations |
|
|
June 15 |
Development using JDBC |
Chapter 8 |
|
|
SimpleDB and Derby demonstrations |
|
|
June 17 |
Domain modeling, ORM, JPA |
Chapter 9 |
|
June 22 |
XML data exchange |
Chapter 10 |
|
June 24 |
Web-server Database clients |
Chapter 11 |
|
June 29 |
Project Progress Presentations |
|
|
July 1 |
Mid-term Exam |
|
|
July 6 |
Disk and File Management |
Chapter 12, SimpleDB code |
|
|
Log file management, buffer management |
Chapter 13, SimpleDB code |
|
July 8 |
Transaction management |
Chapter 14, SimpleDB code |
|
July 13 |
Representing Data Elements |
Chapter 15, SimpleDB code |
|
|
Metadata management |
Chapter 16, SimpleDB code |
|
July 15 |
Query processing |
Chapter 17, SimpleDB code |
|
July 20 |
Parsing |
Chapter 18, SimpleDB code |
|
|
Planning |
Chapter 19, SimpleDB code |
|
July 22 |
Putting it all together as a server |
Chapter 20, SimpleDB code |
|
July 27 |
Index implementation |
Chapter 21, SimpleDB code |
|
July 29 |
Sorting and materialization |
Chapter 22, SimpleDB code |
|
August 3 |
Effective Buffer Utilization |
Chapter 23, SimpleDB code |
|
August 5 |
Query optimization |
Chapter 24, SimpleDB code |
|
August 10 |
Final Exam, 4-6pm |
|
Homework is assigned about once per week, and projects in the first and second halves of the course.
July 1, Wednesday Mid-term
August10, Monday Final Exam
All assignments will be announced in class and posted on the course web page. If you miss class for any reason, it is your responsibility to find out what assignments you missed.
Your grade will be based on three components:
· exams 40% - There will be one midterm exam and one final exam, 20% each.
· homework 40% - There will be 8 homework assignments
· projects 20% - There will be 2 programming projects.
No late assignments will be accepted. There will be no make-up exams except for university-excused absences. Please discuss unusual circumstances in advance with the instructor.
Note: One copy of group work is graded and all group members receive the same grade
Turn in a hardcopy of assignment solutions with a cover page at the start of class on the due date. Also post your solutions to CSNet. Turn in answers or console output as a .txt file and code as a .java file. Zip all files for an assignment into one file and post it to CSNet.
Assigned according to the scale:
A for 90% or above of the total points,
B for 80 to 89%,
C for 70 to 79%,
D for 60 to 69%, and
F for less than 60%.
No incomplete grades will be given
Please don’t eat in class. Please don't surf the net in class. Please turn off your mp3 player.
If you want to take a nap, that’s okay, but leave the classroom unless you want special attention.
To be added during the semester
To be added during the semester
To be added during the semester
The Aggie Honor Code states "An Aggie does not lie, cheat or steal or tolerate those who do". More information on academic integrity, plagiarism, etc. is available at the Aggie Honor System Office web site http://www.tamu.edu/aggiehonor, including:
For the assignments in this class, discussion of concepts with others is encouraged, but all assignments must be done on your own, unless otherwise instructed. If you use any source other than the text, reference it/him/her, whether it be a person, a book, a solution set, a web page or whatever. You MUST write up the solutions in your own words. Copying is strictly forbidden. Every assignment must be turned in with the cover sheet below, which lists all sources you used. Cheating on an exam, plagiarizing, or any other form of academic dishonesty is discouraged. The instructor reserves the right to assign a grade of "F" for the course should circumstances warrant.
The Americans with Disabilities Act (ADA) is a federal antidiscrimination statute that provides comprehensive civil rights protection for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the Department of Student Life, Services for Students with Disabilities in Cain Hall, Rm. B118, or call 845-1637.
CPSC 310 / CPSC 603
Assignment Cover Page
Summer 2009
|
Name: |
|
|
Email: |
|
|
Assignment: |
|
|
Grade (filled in by grader): |
|
Please list below all sources (people, books, webpages, etc) consulted regarding this assignment (use the back if necessary):
|
CPSC 310/603 Students |
Other People |
Printed Material |
Web Material (give URL) |
Other Sources |
|
1. |
1. |
1. |
1. |
1. |
|
2. |
2. |
2. |
2. |
2. |
|
3. |
3. |
3. |
3. |
3. |
|
4. |
4. |
4. |
4. |
4. |
|
5. |
5. |
5. |
5. |
5. |
Recall that TAMU Student Rules define academic misconduct to include acquiring answers from any unauthorized source, working with another person when not specifically permitted, observing the work of other students during any exam, providing answers when not specifically authorized to do so, informing any person of the contents of an exam prior to the exam, and failing to credit sources used. Disciplinary actions range from grade penalty to expulsion.
"On my honor, as an Aggie, I have neither given nor received unauthorized aid on this academic work. In particular, I certify that I have listed above all the sources that I consulted regarding this assignment, and that I have not received or given any assistance that is contrary to the letter or the spirit of the collaboration guidelines for this assignment."
|
Signature: |
|
|
Printed Name: |
|
|
Date: |
|