Instructor

Name	Office	Office Hours	Phone	Email
KwangSoo Yang	EE 428		561-297-1205	yangk@fau.edu

Course description

In-depth coverage of database management systems and data model query languages. Topics include fundamental concepts of database systems, SQL, database design (e.g., conceptual, logical, and physical data models), techniques (e.g., query optimization, transaction processing, concurrency control, and recovery), and new trends (e.g., xml, data warehousing & OLAP, data mining, big-data processing platforms, etc.)

Text Book

Elmasri, Navathe, Fundamentals of Database Systems, 7th Edition, Addison Wesley, ISBN-10: 0-13-608620-9

Supplementary Materials

Nenad Jukic, Svetlozar Nestorov, Susan Vrbsky, Database Systems: Introduction to Databases and Data Warehouses, 1th Edition, Pearson, ISBN-10: 978-0132575676

Hellerstein, Joseph M., and Michael Stonebraker. Readings in database systems. MIT Press, 2005.

Examination and Homework

There are two exams and two homeworks. Each homework includes both questions and programming tasks. There is a group presentation for extra credits; Rsearch topic should be related to database systems. Grades will be assigned based on the following weights:

1. Homework: 40 % (20% each)
2. Midterm: 30 %
3. Final Exam: 30 %
4. Extra credit 10 %

Cheating/Collaboration

Copying someone else's assignment, or the common solution of written or programming assignments will be considered cheating. Interaction for the purpose of understanding a problem is not considered cheating and will be encouraged. However, the actual solution to problems must be one's own.

Code of Academic Integrity Policy Statement

Students at Florida Atlantic University are expected to maintain the highest ethical standards. Academic dishonesty is considered a serious breach of these ethical standards, because it interferes with the university mission to provide a high quality education in which no student enjoys an unfair advantage over any other. Academic dishonesty is also destructive of the university community, which is grounded in a system of mutual trust and places high value on personal integrity and individual responsibility. Harsh penalties are associated with academic dishonesty. For more information, see University Regulation 4.001. Plagiarism is unacceptable in the University community. Academic work that is submitted by students is assumed to be the result of their own thought, research, or self-expression. When students borrow ideas, wording, or organization from another source, they are expected to acknowledge that fact in an appropriate manner. Plagiarism is the deliberate use and appropriation of another's work without identifying the source and trying to pass-off such work as one’s own. Any student who fails to give full credit for ideas or materials taken from another has plagiarized. This includes all discussion board posts, journal entries, wikis, and other written and oral presentation assignments. If in doubt, cite your source!

Grading Scale

Each homework, midterm, and final will be graded on a standard scale: 90-100 for "A" and "A-"; 80-89 for "B+", "B", or "B-"; 70-79 for "C+", "C", or "C-"; 60-69 for "D+", "D" ,or "D-"; 50 and below: "F"

Policy on makeup tests, late work, and incompletes

Assignments are to be submitted on time, with possible point penalties for late submissions. In no case will an assignment be accepted after the graded papers for that assignment have been returned to the students. However, appropriate accommodations will be made for students having a valid medical excuse for being unable to work on an assignment during its two week period. Unless there is solid evidence of medical or otherwise serious emergency situation incomplete grades will not be given.