CS 4/53005: Introduction to Database Systems Design
Fall 2010

MW 05:30 pm - 06:45 pm
MSB 115

Instructor
Office Hours
 

Email 
Telephone

Dr. Feodor Dragan 
Room 254 MSB
MW 1:00 – 3:00 PM
and by appointment 
dragan at cs dot kent dot edu
(330) 672-9058

Teaching Assistant
Office Hours
 

Email 

Muad Abu Ata
Room 160 MSB 
MW 4:00 – 5:00 pm
and by appointment
mabuata@cs.kent.edu

  • WWW:  http://www.cs.kent.edu/~dragan/CS53005-F10.html
  • Prerequisites:     CS 33001 Data Structures
                              CS31011 - Discrete Structures
                              Structured Programming (C++)
                              Software Engineering topics related to project documentation
                              Or Consent of the Instructor
  • Course Overview:  This course is an introduction to the design, use, and internal workings of database management systems. We consider here systems that are based on relational model - that is, users data is represented as a set of two dimensional tables. During the class we learn the ways to organize the data into relations so that the user applications may concurrently manipulate the data from database quickly and reliably. We briefly discuss the relational model and then concentrate on relational query language SQL. We continue with the study of relational database design. Finally, we study database internal storage organization and concurrency control issues.
  • Attendance is required for this class.
  • Textbook:  Database System Concepts, Fifth Edition, McGraw-Hill, ISBN 0-07-295886-3 (by A. Silberschatz, H.F. Korth, S. Sudarshan)  Book's web site (go to Fifth Edition)
  • Projects and Exams: There will be three exams during the semester. In addition, there will be a final exam. Final exam is all inclusive. Each student is expected to do a project. List of projects will be available on or before Oct 15th, 2010. Students must select the project from the list and send an email notification of their selection to dragan@cs.kent.edu by Oct 31st, 2010. Once project is selected, no project change is allowed without the instructor's permission. The project deadline is Dec 10, 2010 and no late project will be accepted or given any credit.
  • Grading Policy: A student's grade will be determined as a weighted average of exam 1 (15%), exam 2 (20%), exam 3 (15%), final exam (25%), project (20%), and attendance (5%). There are no make-up exams.
  • Registration Requirement: The official registration deadline for this course is 09/12/10.  University policy requires all students to be officially registered in each class they are attending.  Students who are not officially registered for a course by published deadlines should not be attending classes and will not receive credit or a grade for the course.  Each student must confirm enrollment by checking his/her class schedule (using Student Tools in FlashFast) prior to the deadline indicated.  Registration errors must be corrected prior to the deadline. The last day to withdraw is 11/07/10.
  • Student Accessibility Policy: University Policy 3342-3-01.3 requires that students with disabilities be provided reasonable accommodations to ensure their equal access to course content.  If you have a documented disability and require accommodations, please contact the instructor at the beginning of the semester to make arrangements for necessary classroom adjustments.  Please note, you must first verify your eligibility for these through Student Accessibility Services (contact 330-672-3391 or visit www.kent.edu/sas for more information on registration procedures).
  • STUDENT CHEATING AND PLAGIARISM:  Condensed Version [For the complete policy and procedure, go to http://www.kent.edu/policyreg/policydetails.cfm?customel_datapageid_1976529=2037779]

Cheating and plagiarism constitute fraudulent misrepresentation for which no credit can be given and for which appropriate sanctions are warranted and will be applied. The university affirms that acts of cheating and plagiarism by students constitute a subversion of the goals of the institution, have no place in the university and are serious offenses to aca­demic goals and objectives, as well as to the rights of fellow students.

"Cheat" means to intentionally misrepresent the source, nature, or other conditions of aca­demic work so as to accrue undeserved credit, or to cooperate with someone else in such mis­representation. Cheating includes, but is not limited to:

1.       Obtaining or retaining partial or whole copies of examinations, tests or quizzes before these are distributed for student use;

2.       Using notes, textbooks or other information in examinations, tests and quizzes, except as expressly permitted;

3.       Obtaining confidential information about examinations, tests or quizzes other than that released by the instructor;

4.       Securing, giving or exchanging information during examinations;

5.       Presenting data or other material gathered by another person or group as one's own;

6.       Falsifying experimental data or information;

7.       Having another person take one's place for any academic performance without the specific knowledge and permission of the instructor;

8.       Cooperating with another to do one or more of the above;

9.       Using a substantial portion of a piece of work previously submitted for another course or program to meet the requirements of the present course or program without notifying the instructor to whom the work is presented; and

10.    Presenting falsified information in order to postpone or avoid examinations, tests, quizzes, or other academic work.

 

“Plagiarize” means to take and present as one’s own a material portion of the ideas or words of another or to present as one’s own an idea or work derived from an existing source without full and proper credit to the source of the ideas, words, or works. As defined, plagiarize includes, but is not limited to:

 

a.       The copying of words, sentences and paragraphs directly from the work of another without proper credit;

b.       The copying of illustrations, figures, photographs, drawings, models, or other visual and nonverbal materials, including recordings of another without proper credit; and

c.        The presentation of work prepared by another in final or draft form as one's own without citing the source, such as the use of purchased research papers.

 

Academic Sanctions,  From Section D The following academic sanctions are provided by this rule for offenses of cheating or plagia­rism. Kent campus instructors shall notify the department chairperson and the student conduct office each time a sanction is imposed. Regional campus instructors shall notify the regional campus dean and the student conduct officer each time a sanction is imposed. Regional campus student conduct officer shall notify the Kent student conduct office each time a sanction is im­posed by a regional campus Instructor. The following academic sanctions are provided by this rule for offenses of cheating or plagiarism. In those cases the instructor may:

 

1.       Refuse to accept the work for credit; or

2.       Assign a grade of "F" or zero for the project, test, paper, examination or other work in which the cheating or plagiarism took place; or

3.       Assign a grade of "F" for the course in which the cheating or plagiarism took place; and/or;

4.       Recommend to the department chair or regional campus dean that further action specified in the rule be taken. The department chairperson or regional campus dean shall determine whether or not to forward to the academic dean or to the vice president for the extended university a recommendation for further sanction under this rule.

 

Procedures for invoking sanctions.    (From Section E)

 

(1)            Academic administrative procedures pertaining to paragraph (D)(1)(a) of this rule. In the event that an instructor determines that it is more probable than not that a student in a course or program under the instructor's supervision has presented work for university credit which involves an act of cheating, plagiarism or cooperation in either, then the instructor shall:

 

(a)            Inform the student as soon as is practical, in person or by mail, of the belief that an act of cheating or plagiarism has occurred. If the student cannot be reached in a reasonable period of time, the instructor may proceed with sanctions, notifying the student in writing as promptly as possible of the belief and the procedural steps the instructor has taken.

(b)            Provide the student an opportunity to explain orally, in writing, or both, why the student believes the evaluation of the facts is erroneous.  

(c)            If the explanation is deemed by the instructor to be inadequate or if no explanation is offered, the instructor may impose one of the academic sanctions listed in paragraph (D)(1)(a) of this rule. Where appropriate, the instructor may recommend the imposition of academic sanctions listed in paragraph (D)(1)(b) of this rule. In addition, the instructor may refer the matter to the dean of the college, campus, or school in which the student is enrolled for imposition of academic sanctions listed in paragraph (D)(1)(b) of this rule.  

(d)            The instructor shall notify the office of judicial affairs of the circumstances and action taken. Such notification will be used as background information in the event that formal conduct charges are initiated against the student.  

(e)            The instructor shall inform the student in writing of the right to appeal, and the procedure to follow.  

(f)             The instructor shall keep the evidence of cheating or plagiarism in a secure place and provide it upon request to any appeals officer or the conduct officer. The instructor shall provide copies on request to the student at the student's expense.  

(g)            The instructor shall cooperate with academic and student conduct personnel in any appeal of the decision, and/or in adjudication of any disciplinary proceedings.



F. F. Dragan
dragan at cs dot kent dot edu
Fall 2010