CSCI 366 - Database Systems (Spring 2019)

Lecture Details

Instructor: Muhammad Zubair Malik (My given name is Zubair)
Email Address: zubair.malik@ndsu.edu
Phone Number: (701) 231-7248
Office: QBB 258 B8
Office hours: Tuesday and Thursday (11AM - 1PM)
TA/Grader:Vishwajeet Marathe
Classroom: Quentin Burdick Bldg, 106
Class hours: TuTh 9:30AM - 10:45AM

Description

This course relies on primary readings from the database community to introduce undergraduate students to the foundations of database systems, focusing on basics such as the relational algebra and data model, schema normalization, query optimization, and transactions. It is designed for students with no prior database.

Course Objectives

The key objectives of the course are to teach:

• How programs are translated into the machine language
  • And how the hardware executes them
• The hardware/software interface
• What determines program performance
  • And how it can be improved
• How hardware designers improve performance
• What is parallel processing

Required Student Resources

1. A First Course in Database Systems, 3rd edition by Ullman and Widom (U/W). (Required) Amazon
2. Stanford CS 245 (Reference)
3. Berkeley CS 186 (Reference)

Schedule

Lecture	Topic	Reading /Assignment
1	Data introduction	Chapter 1, Slides
2	Data modeling for db	Chapter 1, Slides

Evaluation procedures and criteria

The following grade distribution is used:

• Assignments: 25% (6 assignments; 5 best scores are used for total; 5% each)
• 3 Exams: 25% each

Evaluation procedures and criteria

Grading Scale:

• Grade >= 90 is A
• 80 >= Grade < 90 is B
• 70 >= Grade < 80 is C
• 60 >= Grade < 70 is D
• Grade < 60 is F

Attendance Statement

“According to NDSU Policy 333 , attendance in classes is expected.” The course instructor must clearly inform students on the first day of class and in writing in the syllabus of their (1) policy regarding class absence and (2) policy, if any, for making up missed assignments. If class attendance is a component of the course grade, the course instructor must clearly communicate this to the class in writing in the syllabus. See NDSU Policy 333 for faculty and student responsibilities related to attendance, including for university-sponsored activities. Faculty are encouraged to provide the following statement on syllabi: “Veterans and student service members with special circumstances or who are activated are encouraged to notify the instructor as soon as possible and are encouraged to provide Activation Orders.”

Americans with Disabilities Act for Students with Special Needs Statement

The following statement must appear on all syllabi: “Any students with disabilities or other special needs, who need special accommodations in this course, are invited to share these concerns or requests with the instructor and contact the Disability Services Office (www.ndsu.edu/disabilityservices) as soon as possible.”

Academic Honesty Statement

“The academic community is operated on the basis of honesty, integrity, and fair play.NDSU Policy 335: Code of Academic Responsibility and Conduct applies to cases in which cheating, plagiarism, or other academic misconduct have occurred in an instructional context. Students found guilty of academic misconduct are subject to penalties, up to and possibly including suspension and/or expulsion. Student academic misconduct records are maintained by the Office of Registration and Records. Informational resources about academic honesty for students and instructional staff members can be found at Owww.ndsu.edu/academichonesty.