CSC 3326 Syllabus
CSC 3326 Syllabus
CSC 3326 Syllabus
GENERAL INFORMATION
Prerequisite: CSC 3324
Prerequisite for: CSC 3374, CSC 5301, CSC 5355, CSC 5358
Offered in semester: Fall, Spring & Summer
Credit hours: 3
Contact hours: 5 h/week: 3 lecture hours + 2 lab hours
COURSE DESCRIPTION
The course covers the design and implementation of Relational databases. While significant
focus is placed on Entity-Relationship and Relational modeling, other models and current trends
in database are introduced. Relational Algebra and SQL are covered, including procedural SQL.
A Relational DBMS is used along with database application development as lab work and class
projects. Transactions and concurrency issues are also addressed.
TEXTBOOK / REFERENCES
• “Database Systems: Design, Implementation, & Management,” 13/e, C. Coronel & S.
Morris; 2019 Cengage Learning. eBook: Learning Tools - Main View | eBook MindTap | CSC
3326 01 | Portal
+ Reference (reserved): “Fundamentals of Database Systems,” 7/e, R. Elmasri & S. B.
Navathe; 2016 Pearson
1/4
INTENDED LEARNING OUTCOMES
1. Understand the fundamental concepts and techniques used in database systems, including
current trends;
2. produce good relational DB design;
3. use SQL to build and query a DB;
4. implement a DB using a DBMS, matching general DB concepts with the internals of the
DBMS, and connecting the DB to the Web and/or another GUI.
GRADING
Course grades will be based on the total points earned in the following categories:
Exam 1: 20% of course grade
Final: 25% ,,
Quizzes/Homework/Assignments: 15% ,,
Project/Labs: 30% ,,
Participation/Attendance: 10% ,,
To earn a non-zero grade in the course, a student must regularly attend course meetings; receive
at least 50% of the points available for the examinations, and at least 50% of the points available
for the assignments (quizzes and projects). The following scale will be used:
A+ [97%, 100%] B+ [87%, 90%[ C+ [77%, 80%[ D+ [67%, 70%[
A [93%, 97%[ B [83%, 87%[ C [73%, 77%[ D [60%, 67%[
A- [90%, 93%[ B- [80%, 83%[ C- [70%, 73%[ F < 60%
The instructor reserves the right to adjust the scale for course grades, if necessary. Contact your
instructor if you have any concerns about your performance in the class.
PROJECT / LAB ASSIGNMENTS
In your projects, in teams of two or three, you will bring together concepts and tools to develop
database applications. Project deliverables consist of:
1. a project proposal (10% of project grade) with requirements’ gathering and specification;
2. a detailed mid report (20% of project grade) describing the detailed design and ERD;
3. a comprehensive final report documenting the (revised) design and the complete
implementation of normalized database tables; and integration with a web interface and/or
another GUI. The final report constitutes 20% of the project grade, and the implementation
and overall work 25%.
Teams should present their project work in class and make a demo. The presentation and demo
constitute the remaining 25%.
There are laboratory sessions to assist you in becoming familiar with SQL, in preparing your
assignments and in developing your project applications. The scheduled laboratory sessions will
be used to complete practical exercises and to consult with the instructional staff about projects
and other aspects of the course.
You need your laptops during lab sessions to install and use the database server and utilities, and
sometimes during lecture sessions.
2/4
ATTENDANCE/PARTICIPATION
All students are expected to adhere to AUI's attendance regulations, which include the statement,
“Regular attendance and participation in all class meetings in which a student is registered are
expected. Beyond merely attending each class, students are expected to participate actively and
not remain passive learners. It is the instructor’s responsibility to set, and to communicate to
students, the participation requirements for each course. Except for excused absences authorized
by the University, the degree to which classroom participation is required, and whether or not
work missed by a student during an absence may be made up, is at the discretion of the
instructor.” (AUI Academic Catalog). The complete text of the Catalog is posted under:
http://www.aui.ma/AUI-Catalog2019-2021.pdf . When a student exceeds the ceiling of 7
absences (class and lab combined), the instructor may sign an administrative withdrawal form.
Each unauthorized absence results in 1% of course grade and will be deducted from the class
participation/attendance.
ACADEMIC INTEGRITY
Academic Misconduct
The university’s statement on academic integrity is found in AUI Catalog: “It is the aim of the
faculty to foster a spirit of honesty and a high standard of integrity. The instructor of a course is
responsible for initiating action against dishonesty or plagiarism that occurs in class.
In cases of convincing evidence of academic dishonesty such as cheating, plagiarism, or
falsification, an instructor should take appropriate action. Before taking such action, however,
the instructor should attempt to discuss the matter with the student.”
Academic dishonesty includes, but is not limited to, cheating, plagiarism, collusion, falsifying
academic records, misrepresenting facts, and any act designed to give unfair academic advantage
to the student (such as, but not limited to, submission of essentially the same written assignment
for two courses without prior permission of the instructor) or the attempt to commit such an act.
Examinations are to assess what you know individually; cheating on an exam will result in a
score of 0 (zero) for the test.
Avoid plagiarism on formal writing assignments by making liberal use of citing references.
Plagiarism will result in a score of 0 for the assignment; this includes the term project.
Cases of academic dishonesty will be reported to the SSE Dean. Students with serious or
multiple violations may be referred to the Student Disciplinary Committee for further discipline.
3/4
IMPORTANT NOTES
1. No make-ups for examinations may be arranged except for extenuating circumstances. A
written explanation (including supporting documentation) must be submitted to your
instructor. Makeup arrangements must be completed in advance whenever possible.
2. To be eligible for credit, an assignment solution must (1) fulfill the published
requirements, (2) be submitted by the published due date, and (3) be your own work.
3. Any extenuating circumstances that impact on your participation in the course should be
discussed with your lecture instructor as soon as those circumstances are known.
4. The instructor reserves the right to modify course policies, the course calendar, and
assignment specifications. Students will be notified by verbal notice and/or by email.
W Topics Readings
1-2 Course Overview
Database Systems Ch 1
Data Models Ch 2
3-4 The Relational Database Model Ch 3
Project proposal due Sun Feb 21
Introduction to SQL (Structured Query Language) Ch 7
5 Relational Algebra Handout
6, 7 Advanced SQL Ch 8
ER (Entity Relationship) Modeling Ch 4
*** Midterm, Thu Mar 18 ***
8 Normalization of Database Tables Ch 6
### Spring Break: Mon Mar 29 – Fri Apr 2 ###
9-10 Advanced Data Modeling Ch 5
Project mid report due Sun Apr 11
Database Design Ch 9
11-13 Transaction Management & Concurrency Control Ch 10
Project implementation progress due Sun Apr 25
14 Project final report due Sun May 9
Project presentations and demos, starting Tue May 11
### Holiday: Aid Al Fitr (To be confirmed), May 14-15 ###
15-16 Last Regular Class Day – Mon May 17
*** Final Exam, as scheduled by the University ***
Reading should be completed prior to lectures so that you can understand material to be covered
in class on that day. Chapter numbers refer to the course textbook.
4/4