Course Information


Class Description

The course descriptions in the SBU CS website are as follows:

CSE305: "The design of database management systems to obtain consistency, integrity, and availability of data. Conceptual models and schemas of data: relational, hierarchical, and network. Students undertake a semester project that includes the design and implementation of a database system."

CSE532: "The course will cover advanced topics in modern database systems, including object-oriented databases, rule-based databases, temporal and active databases, parallel and distributed databases, distributed object model, data mining, on-line analytical processing, data warehousing, multimedia databases."

Instructor

Assistant Professor Sael Lee
Office: Academic Bldg. B422
Email: sael at sunykorea dot ac dot kr
Phone: +82 (32) 626-1215

Meeting Time

[lecture] Tu/Th 15:30~16:50 Academic Bldg. B203

Office Hours

Office Hours: TBA (or send emails for appointments) at B422

Prerequisites

None

Prerequisites

CSE305: C or higher: CSE 219 or CSE 260; CSE major
CSE532: CSE305

Course Outcomes

CSE305:
- An ability to design database management systems through E/R design and the theory of normalization.
- An ability to use relational query languages.
- An ability to design and implement a database system, via a significant project.

TextBook

Required: Kifer, Bernstein, Lewis, Database Systems: An Application-Oriented Approach (Complete Version, 2nd Edition), Addison-Wesley, ISBN 0321268458.
Recommended: Database Systems: The Complete Book 2nd Ed (2008), by Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom

Grading

- Participation: 5%;
- Assignments: 10%;
- Projects: 35%
- Midterm: 25%;
- Final Exam: 25%;




Notice



Pdf version of this syllabus can be found here.



Project



Project Description

Project Part1 due April 27th beginning of class

Project Part2 due May 11th beginning of class

Demo Data

Project Part3: Demo Day and Final Document Due on June 8th



Advanced Topic List


+ 23rd 1. Object DB - Yousun
+ 23rd 2. In memory DB - Hangil
+ 25th 1. Distributed DB - Pratik
+ 25th 2. NoSQL - Vasundhara
+ 25th 3. Semi struct data / XML - Kyungjoo



Course Materials




# DATE CONTENT SLIDES
1 2/28 Introduction: Overview of Databases ch1
3/2 The Big Picture Ch2
2 3/7 SQL Ch3
3/9 SQL cont.
3 3/14 Conceptual Modeling ch4
3/16 Conceptual Modeling cont.
5 3/21 Relational Algebra ch5
3/23 Relational Algebra cont.
5 3/28 NO CLASS - Business trip (makeup class on 6/8)
3/30 Relation Normalization ch6
6 4/4 Relation Normalization cont.
4/6 Project Description
7 4/11 Relation Normalization cont.
4/13 Relation Normalization cont.
8 4/18 MIDTERM EXAM
4/20 Physical Data Organization and Indexing ch9
9 4/25 Physical Data Organization and Indexing cont.
4/27 Query Processing ch10
10 5/2 Query Processing cont.
5/4 NO CLASS: Adjustment Day
11 5/9 NO CLASS: Election Day
5/11 Query Optimization ch11
12 5/16 Query Optimization cont.
5/18 Data Mining cont.
13 5/23 Advance DB Topics
5/25 Advance DB Topics
5/30 Data Mining cont.
6/1 Review - Go over selected sample problems
15 6/6 NO CLASS: Memorial Day
6/8 PROJECT PRESENTATION Duration: 3 hourses; Presenters: everyone; Class time includes the Makeup class (3/28)
6/22 FINAL EXAM




Course Policy


Attendance policy

Everyone is strongly urged to attend class regularly and actively participate. You will be responsible for learning all the materials covered in class. Lecture slides and supplementary handouts will cover most of the material; however, in-class participation through engaging in discussions and asking questions should be valued learning activity.

The SUNY Korea Attendance Policy states "If a student has over 20% unexcused absence, the student's final course grade will be an 'F'."

Assignments grading policy

Assignment will be handed out in class and are due at the start of class of the due date. Legible handwritten copies of the assignments should be turned in.

Total points of each assignment will be different depending on the difficulty of the problems. However, the maximum total point of an assignment will be less than or equal to two times the minimum total point of an assignment. Expect to see difficult problems towards the end of semester.

I will drop the lowest grade from among your assignment scores. No late assignments will be accepted.

Project grading policy

You will be required to propose and execute a final project based on the contents we will learn in class. The class grading will be based on 10% of the content of the proposal, 25% on the final report, and 5% project presentation which add up to 60% of your grade. SUNY-SB Blackboard facility will be used for submissions. The Blackboard facility will mark your time of submission. It is your responsibility to check if the uploads are done properly and to check if you received a proper grade. Grades will be e-mailed to you individually in a timely fashion.

Academic misconduct policy

There is no excuse in cheating. Cheating will be considered as an academic misconduct and handled according to the Stony Brook regulations. If cheating has occurred during exam or is evident in submitted assignments, your will get a grade of F. Discussion of assignments is acceptable, however, returned assignments must show originality. This means near duplicate assignments with your peers or duplications of materials found on the web will be considered cheating. All involved personals in cheating will be penalized.




University Policy


Americans with Disabilities Act

If you have a physical, psychological, medical or learning disability that may impact your course work, please contact Disability Support Services, ECC(Educational Communications Center) Building, Room 128, (631)632-6748. They will determine with you what accommodations, if any, are necessary and appropriate. All information and documentation is confidential.Disability Support Services.

Academic Integrity

Each student must pursue his or her academic goals honestly and be personally accountable for all submitted work. Representing another person's work as your own is always wrong. Faculty is required to report any suspected instances of academic dishonesty to the Academic Judiciary. Faculty in the Health Sciences Center (School of Health Technology & Management, Nursing, Social Welfare, Dental Medicine) and School of Medicine are required to follow their school-specific procedures. For more comprehensive information on academic integrity, including categories of academic dishonesty please refer to the academic judiciary website at Academic Judiciary

Critical Incident Management

Stony Brook University expects students to respect the rights, privileges, and property of other people. Faculty are required to report to the Office of University Community Standards any disruptive behavior that interrupts their ability to teach, compromises the safety of the learning environment, or inhibits students' ability to learn. Faculty in the HSC Schools and the School of Medicine are required to follow their school-specific procedures. Further information about most academic matters can be found in the Undergraduate Bulletin, the Undergraduate Class Schedule, and the Faculty-Employee Handbook.