AI & Big Data Department
Database
Sec 001: Wednesday, 13:00 – 16:00, S2 401, 3 Credits
Sec 002: Thursday, 13:00 – 16:00, S2 401, 3 Credits
Sec 003: Tuesday, 13:00 – 16:00, S2 401, 3 Credits
Instructor Email Office Hours & Location
Dr. Hasan Tinmaz
[email protected] W19 232(By Appointment)
Description
Developing and managing efficient and effective database applications require an understanding of the
fundamentals of database management systems, techniques for database design, and principles of database
administration. This course emphasizes key database concepts, developments, and their practical use and
management in two main sections: database concepts and database practices (MS Access & SQL) where
relational database systems are the main focus. The course places emphasis on the practical design of
databases and the development of database applications using modern software tools.
Teaching Methods
This course will be taught through a series of lectures based on selected chapters of the textbook and
supplemental texts. Case studies, videos, in-class exercises (both group and individual), and take-home
assignments will be frequently used to enhance understanding through reflection and interaction. Students
are expected to review the materials and actively participate in class. All course materials will be posted
on SMART, so students are advised to check their message box on SMART regularly.
Course Goals and Learning Outcomes
Upon successfully completing this course, the student will:
• Understand the fundamentals of relational database systems, including data models, database
architectures, and database manipulations.
• Understand the theories and techniques involved in developing database applications and
demonstrate the ability to build databases using enterprise DBMS products such as SQL.
• Be familiar with managing database systems
• Understand new developments and trends in databases.
Course Requirements & Grading
Component Weight
Attendance 20%
Midterm Exam 15%
Final Exam 15%
Final Project 50%
Professor reserves right to make changes to expected assignments and due dates, provided changes are communicated in a clear and timely
manner.
Page 1
Evaluations
Midterm Exam: Students will take a closed-book exam covering theoretical aspects of databases.
Final Exam: Students will take an open-book exam covering practical aspects of databases.
Final Project: Students will collaborate in groups to prepare a database project.
Grading Curve (after excluding failing students)
A Category = 30%
B Category = 40%
C & D Categories = 30%
Course Text: Coronel, C. & Morris, S. (2019). Database Systems Design Implementation and
Management, Cengage Learning. ISBN-13: 978-1337627900
Additional Text: Rob. P. & Coronel C. (2009). Database Systems: Design, Implementation and
Management (8th ed.). ISBN-13: 978-1-4239-0201-0
Students are required to install MS-Access on their computers. Please note that MS-Access for Apple
computers can be problematic. It is advised to find a solution as early as possible.
Course Expectations & Guidelines
▪ Academic Integrity: Students are expected to produce their own work and, when using the work of
others, include clear citations. Failure to properly cite or attribute the work of others will affect your
grade for the project. Obvious plagiarism (especially via AI tools) will result in a 0% grade for the
project, and may entail larger consequences.
▪ Student Special Needs: If a student has a condition that affects their classroom learning (such as a
hearing disability), they should discuss special arrangements with the professor.
▪ Attendance and/or Participation: It is the student’s responsibility to inform their department in the
event of excused absences. The professor does not handle this process. Arriving more than 10 minutes
late will be reflected as absence in the attendance system. Missing 30% of classes will result in an
automatic failure.
▪ Extensions, Late Assignments, & Re-Scheduled/Missed Exams: There will be a 50% penalty
imposed on any assignments that are submitted after the established date. The professor reserves the
right to waive this penalty in the event of extenuating circumstances. The professor may accept late
submission of work, operating on a “better late than never, but better never late” policy. However,
expect significant deductions based on how late the work is. The professor reserves the right to
deduct however much he feels is appropriate in relation to the quality of the specific assignment and
your overall performance during the semester
▪ Student Use of Mobile Devices in the Classroom: Mobile phones may be used for in-class purposes,
provided they are not used excessively or disruptively. While some flexibility may be employed,
obvious uses of phones for non-class activities will likely result in loss of participation points for the
day.
▪ Additional Course Policies: Students are strongly encouraged to consult the Woosong Student
Handbook and the School website for additional information. No sleeping during the lectures is
welcomed. That will adversely affect your overall grade.
Page 2
▪ Using ChatGPT or other AI tools that generate text or content is considered as plagiarism and
cheating. Refrain from all of these tools, if you do not want to get a zero.
▪ You are not permitted to communicate with the course instructor through any social media platforms
regarding the course, problems, absences, etc., unless there is a genuine emergency.
▪ Use my email ([email protected]) (recommended initially) or LMS direct message.
Course Schedule
Week Topic Notes
Course Introduction.
1 Database Systems
The students will read chapter 1 from the textbook.
2 Data Models The students will read chapter 2 from the textbook.
3 The Relational Database Model The students will read chapter 3 from the textbook.
4 Entity Relationship (ER) Modeling The students will read chapter 4 from the textbook.
ER Modeling (continued) ER development exercises.
5
Advanced Data Modeling The students will read chapter 5 from the textbook.
6 Normalization of Database The students will read chapter 6 from the textbook
7 Database Design The students will read chapter 9 from the textbook.
8 Midterm Exam The students will get an in-class theoretical exam.
9 Learning MS-Access I Students will start learning about MS-Access database.
10 Learning MS-Access II Students will do more practices on MS-Access.
11 Learning MS-Access III Students will do more practices on MS-Access.
The students can read chapter 7 from the textbook.
12 Learning SQL I
Students will learn the fundamentals of SQL.
The students can read chapter 8 from the textbook.
13 Learning SQL II
Students will learn the fundamentals of SQL.
14 Final Project Submission Final project presentations
15 Final Exam The students will get an in-class practical exam.
The instructor reserves the right to modify this schedule based on new information, moderating circumstance, or student
performance. Students will be informed before any changes and due consideration will be given to grades and participation.
Page 3
