 |
Ann #46: 22/05/2012
HW5
grades are posted
here.
You can view your homework at 4th floor on this Thursday 15:40-17:30 - May
24th |
|
Ann #45: 18/05/2012
Answers (and questions) of all HWs (1-2-3-4-5-6) are now downloadable via Moodle. Login to the
Moodle course page to access these files. |
|
Ann #44: 18/05/2012 Makeup exams for the midterm, final and the hw sessions will be held on
23 May Wednesday at 9:30. The classroom is EE03 (located in the EE building). Don't forget to bring the documents (medical report, etc.) showing your
legal excuse.
|
|
Ann #43: 14/05/2012 Final
Exam will be on 22 May, Tuesday at 15:30 (EB101,102,103,104). The exam will be CLOSED BOOK/NOTES and
will cover the following subjects:
Relational Calculus, SQL, QBE, Functional
Dependencies,Normalization of Relations, Query Processing and
Optimization, Transaction Management, Concurrency Control,
Recovery. |
|
Ann #42: 11/05/2012
PROJECT DEMO SCHEDULE: Demos will be held
on 16 May (Wednesday) in E211 (EE). Demo
schedule is posted
here.
You may be graded individually, so I suggest you get ready for any
questions regarding your contribution to the project. |
|
Ann #41: 07/05/2012
Grading Criteria
for the project
demo
is posted
here (subject
to change).
|
|
Ann #40: 03/05/2012
HW Session 6 will be on
May 8, Tuesday, 17:40-19:40 ( BZ01, BZ02, BZ04,
BZ05). Topics
covered: Transaction Management &
Concurrency Control. Class distribution will be the same with the last
hw session. |
|
Ann #39: 02/05/2012
Programming Assignment
grades are posted
here.
You can view your homework at 4th floor on this Monday 13:40-15:30 - May
07th |
|
Ann #38: 25/04/2011
UPDATE PROJECT
DEMOS and FINAL Reports:
Project
Demos will be held on 16 MAY and the due date for the final report is 11 May.
You need to include the following
information in your final reports
 |
A brief
description of your application system. (At most one page) |
|
|
Final E/R |
|
|
Final list of
tables |
|
|
Implementation
details (At most 1 page) |
|
|
Advanced DB
features used in your project. See an example
here . (At most 2 page) |
|
|
A User's
Manual describing the usage of your system. |
|
|
Ann #37: 20/04/2012 HW Session 5 will be
on April 25, Wednesday, 17:40-19:40 (BZ01,
BZ02, BZ04, BZ05). Topics
covered: Query Processing & Optimization. Class distribution will be same |
|
Ann #36: 20/04/2012
HW4
grades are posted
here.
|
|
Ann #35: 16/04/2012
Programming
Assignment Due Date is postponed to April 20, 2012 till 23:59. |
|
Ann #34: 13/04/2012
Midterm Grades are
posted here.
You can view your papers on Tuesday afternoon (April 17th) (10:40-18:30) |
|
Ann #33: 13/04/2012
There
is a
FAQ section available regarding your programming assignment. For
those of you students who are having trouble to test your files globally
(i.e., via http://dijkstra.ug.bcc.bilkent.edu.tr/~username/) work locally (via
http://localhost/). |
|
Ann #32: 13/04/2012
Seminar
slides are now available.
Slide 1,
Slide 2 and
Slide 3. |
|
Ann #31: 11/04/2012
Programming
Assignment is posted
here. Due Date:
April 18, 2012 till 23:59. If you have any problems regarding the
homework contact Çağrı Toraman (ctoraman@bilkent.edu.tr). |
|
Ann #30: 07/04/2012
TUTORIAL
on Web-based database applications. April
11, Wednesday on 17:40 at EE01, (all
sections). Attendance is
strongly recommended since
the tutorial is related to your project implementation and you will have
a Programming Assignment related to this tutorial. |
|
Ann #29: 07/04/2012
Your Design
Reports will be available on Monday (April 09) afternoon at EA407.
Please get your reports (and feedbacks from the respective TA). You are encouraged to start the implementation
immediately. |
|
Ann #28: 05/04/2012
Update HW3
grades are posted
here.
You can view your homework at 4th floor on this Thursday 15:40-17:30 - April
12th |
|
Ann #27: 04/04/2012
Answers (and questions) of HW 1-2-3-4 are now downloadable via Moodle. Login to the
Moodle course page to access these files. |
|
Ann #26: 02/04/2012
As indicated at the beginning of the semester, regular attendance at
classes is required for successful completion of the course. Failure to
attend class regularly can result in a lower grade. From the STARS system
you can view your attendance data recorded since the beginning of the
semester. |
|
Ann #25: 01/04/2012
Update HW2
grades are posted
here.
You can view your homework at EA407 on this Tuesday 13:40-15:30 - April
03rd |
|
Ann #24: 29/03/2012
Midterm Exam will be on 7 April, Saturday at 13:30 (EB101, EB102, EB103, EB104). The exam will be CLOSED BOOK/NOTES and cover the
following subjects:
Relational Calculus (Chapter 4)
SQL (Chapter 5)
QBE (Online Chapter)
Functional Dependencies and Normalization (Chapter 19)
|
|
Ann #23: 29/03/2012 HW Session 4 will be
on April 04, Wednesday, 17:40-19:40 (BZ01,
BZ02, BZ04, BZ05). Topics
covered: Functional Dependencies and Normal Forms. |
|
Ann #22: 25/03/2012
You can submit your design (and previous proposal)
report to the office EA407 or TA mail-boxes in the department secretary
before 17.00 tomorrow. |
|
Ann #21: 20/03/2012 A copy of the Design
and Final report from previous years can be found in the Library reserve
department. Due date for design report is March 26th. Some few points
regarding the design state are:
Advanced Database
components: In this part of your report, you should design
your reports, views, triggers, constraints and stored procedures. i) For
reports you are required to give the actual SQL statement and the
description of the report (what this report finds) in one sentence. ii)
For views, you should also give the actual SQL statement for creating
the view, and also explain what this view will be used for. iii) For
triggers, constraints and stored procedure, you can just give the
description of these constructs and its use in your project. You are not
required to give the actual SQL code.
We expect your relations to be at least in 3NF. |
|
Ann #20: 16/03/2012
HW Session 3 will be
on March 21, Wednesday,. 17:40-19:40 (Mithat Çoruh Amfi). Topics
covered: QBE and Functional Dependencies.
|
|
Ann #19: 13/03/2012
Project
Design Report Due Date: March 26, 2012. (Do not forget to get your proposal report for E/R
feedbacks). Tentative Grading Criteria for Design Report is given below.
Please pay attention while doing this report since its grade will
correspond to %30-%35 (tentatively) of your overall project grade.
Revised E/R: 10 pts
Table schemas: 25 pts
FD and Normalization of Tables: 5 pts
Functional components: 10
pts
User interface design and corresponding SQL
statements: 35 pts
Advanced database components: 15 pts
Please read the corresponding part in term project
description document for details of the design report.
|
|
Ann #18: 12/03/2012
Update
The date of MIDTERM EXAM has been CHANGED to APRIL 7th, SATURDAY at 13:30. |
|
Ann #17: 11/03/2012
Your project proposal documents have
been evaluated. You can get your project report starting tomorrow from 407 and 425. You have to contact your project TA's to get your report and
feedback. |
|
Ann #16: 02/03/2012 Reminder:
HW Session
2 will be on March 6, Tuesday, 17:30-19:30 (BZ01, BZ02, BZ04, BZ05. Topics covered: SQL. Class
distribution is as follows (by surname):
| BZ-01 (BCC) |
Acarlar - Büyükgebiz |
| BZ-02 (BCC) |
Cöcen - Kandiş |
| BZ-04 (BCC) |
Kanoğlu - Özkıdık |
| BZ-05 (BCC) |
Özyazıcı - Zorer |
|
 |
Ann #15: 29/02/2012
HW1
grades are posted
here.
(You can view your homework at EA407 on this Monday 13:40-15:30 -March
05th) |
|
Ann #14: 27/02/2012
Due date for project proposal is Mar 05, Monday.
Your project proposal should include description of your application,
its requirements and limitations. Most importantly, it should include
the conceptual design of your database using the E/R model. Finally you
are expected to prepare a web site (or Moodle wiki page for your group)
for your term project and publish your proposal on this site (in
addition to submitting the printed proposal on its due date).
Please read the corresponding part in term project
description document for details of the project proposal.
In your E/R diagram, you are
expected to explicitly
indicate the cardinality
of relationships (on the lines connecting entities) as 1-1(One-to-One) ,
1-M (One-to-Many) or M-M (Many-to-Many).
How to submit:
You
should submit your printed proposal report to the office EA407 or TA
mail-boxes in the department secretary before 17.00. |
 |
Ann #13:
23/02/2012 The responsible TAs for each
project topic are as follows. Please contact your responsible TA if you have
any question regarding your project.
|
|
Erdem
Sarıgil:
Library Management System, Course Registration System |
|
|
Burak
Sazoğlu:
Bus Company Data Management System, TA Management System |
|
|
Çağrı
Toraman:
Cargo Company, Resort Data Management System |
|
|
Elif
Eser:
HyperStore Data Management System, Banking Enterprise |
|
|
|
Ann #12: 23/02/2012
Project groups are listed
here.
Topic assignments are listed
here.
Check the lists carefully and email to esarigil@bilkent.edu.tr immediately if you see any problem
with your project group. Check this
document that gives a brief
description for each project topic..Start working on
your project proposal. |
|
|
Ann #11: 23/02/2012
Our department has gained access to the Oracle Academy. You can use Oracle products for your projects. For this, you must each have your own oracle.com account. You can create an account by clicking
here. (http://www.oracle.com/us/syndication/subscribe/index.html).
For activation, Navigate to http://oukc.oracle.com/static05/akc/new_account.html?52L2A1059723046 and get started.
You can download softwares from https://edelivery.oracle.com/. and
http://www.oracle.com/technetwork/index.html. Activation Key will be sent via e-mail. |
|
Ann #10: 20/02/2012 Reminder:
HW Session 1 will be on February 21, Tuesday, 17:40-19:40 (BZ01, BZ02,
BZ04, BZ05). Topics covered: Relational Calculus. Class
distribution is as follows (by surname):
| BZ-01 (BCC) |
Acarlar - Büyükgebiz |
| BZ-02 (BCC) |
Cöcen - Kandiş |
| BZ-04 (BCC) |
Kanoğlu - Özkıdık |
| BZ-05 (BCC) |
Özyazıcı - Zorer |
|
|
Ann #9:
20/02/2012
PROJECT
GROUP DEADLINE:
Note that
today is the last day for emailing your project group members to
esarigil@bilkent.edu.tr. Also do not forget to enroll in moodle page
for CS352. |
|
Ann #8:
16/02/2012
ABOUT HW
SESSIONs:
Open textbook and printout of lecture slides
No
other books or notes are allowed
All electronic equipment should be kept in bags
Cell phones should be kept
turned off
Sharing any materials during the session is strictly prohibited |
|
Ann #7:
16/02/2012 HW Session 1 will be on February 21,
Tuesday, 17:40-19:40 (BZ01, BZ02, BZ04, BZ05). Topics covered:
Relational Calculus. |
|
Ann #6: 10/02/2012
Please start forming project groups, which should include exactly 3 students.
Groups of 2 students will be allowed only in exceptional cases. Please read
Ann #3
for further details.
Project groups may include students from different
sections.
You must form your
group and e-mail to
esarigil@bilkent.edu.tr until February
20, 2012 |
|
Ann #5: 10/02/2012
COURSE
ATTENDANCE POLICY:
Regular
attendance at classes is required
for successful completion of the course. Attendance will be taken by
circulating a class roll during class. Signing the
class roll for a student who is not present will be considered a case of
academic dishonesty and will lead to punishment through disciplinary
procedures. |
|
Ann #4: 10/02/2012
CS352 MOODLE PAGE:
We will use Moodle service in our course in this semester. You must log into
the moodle through STARS system first. For detailed information click
here.
You can use forums in this page to communicate
with other students in this course. |
|
Ann #3:
03/02/2012
term project description document is posted.
Please read the instructions. There will be more announcements about the
term project soon. |
|
Ann #2: 03/02/2012
Click here to
learn about the course syllabus, classes and textbook. |
|
Ann #1: 03/02/2012
Please visit this page very frequently
to learn about latest announcements, regular assignments, office hour
changes, exam information and other relevant stuff. |
