The goals of this course are to teach students about the concepts of a database, data modeling and logical design which enables them to store and efficiently manage the relational data that can be encountered in many areas of daily life; to teach students about Structured Query Language (SQL) which allows them to define and manipulate data in a database and to provide students to develop database applications using Microsoft Access and Microsoft SQL Server, the two relational database management systems which have widespread use.
Prerequisite(s)
None.
Corequisite(s)
None.
Special Requisite(s)
Basic programming skills and (in order to follow the course resources) basic English knowledge are necessary and sufficient.
Instructor(s)
Assist. Prof. Dr. Levent CUHACI
Course Assistant(s)
None
Schedule
Monday, 13:00-14:45
Tuesday, 15:00-16:45
Office Hour(s)
Tuesday, 13:00-15:00 via IKU-CATS
Teaching Methods and Techniques
- Lecture
- Visual presentation
- Developing applications on a widely used relational database management system.
Principle Sources
- Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 5th ed., Pearson Education, Inc, Boston, MA, 2007.
- Richard T. Watson, Data Management : Databases and Organizations, 5th ed., John Wiley & Sons, Inc, 2006.
Other Sources
- J.G.Hughes, Object-Oriented Databases, Prentice Hall International (UK) Ltd, University Press, Cambridge, 1991.
Course Schedules
Week
Contents
Learning Methods
1. Week
Data, Information and Knowledge
Oral presentation
2. Week
Historical Evolution of Database Management Systems
Oral and visual presentation
3. Week
Data Modeling, The Entity-Relationship Model (ER Model)
Oral presentation, implementation
4. Week
Relational Data Model and Relational Database Constraints
Oral presentation, implementation
5. Week
Relationship Types : 1-1, 1-N, N-M Relationships
Oral presentation, implementation
6. Week
Logical Design
Oral presentation, implementation
7. Week
SQL pt.I : (DDL) – Data Definition Language
Oral presentation, implementation
8. Week
Midterm Exam I
Exam
9. Week
SQL pt.II : (DML) – Data Manipulation Language
Oral presentation, implementation
10. Week
Advanced SQL : Complex Queries
Oral presentation, implementation
11. Week
Database Normalization and Normal Forms
Oral presentation
12. Week
Midterm Exam II
Exam
13. Week
Object Oriented Databases
Oral presentation
14. Week
Database Connection Through User Applications
Implementation
15. Week
Finals Week
Exam
16. Week
Finals Week
Exam
17. Week
Finals Week
Exam
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
40
Final Exam
1
60
Program Outcomes
PO-1
Interpreting advanced theoretical and applied knowledge in Mathematics and Computer Science.
PO-2
Critiquing and evaluating data by implementing the acquired knowledge and skills in Mathematics and Computer Science.
PO-3
Recognizing, describing, and analyzing problems in Mathematics and Computer Science; producing solution proposals based on research and evidence.
PO-4
Understanding the operating logic of computer and recognizing computational-based thinking using mathematics as a discipline.
PO-5
Collaborating as a team-member, as well as individually, to produce solutions to problems in Mathematics and Computer Science.
PO-6
Communicating in a foreign language, and interpreting oral and written communicational abilities in Turkish.
PO-7
Using time effectively in inventing solutions by implementing analytical thinking.
PO-8
Understanding professional ethics and responsibilities.
PO-9
Having the ability to behave independently, to take initiative, and to be creative.
PO-10
Understanding the importance of lifelong learning and developing professional skills continuously.
PO-11
Using professional knowledge for the benefit of the society.
Learning Outcomes
LO-1
The student recalls the conventional file usage which he/she previously learned and he/she becomes aware of the inefficiencies of this system.
LO-2
The student gains the ability to analyse the requirements of storing and manipulating the data which he/she may encounter in different areas of daily life.
LO-3
The student learns about data modeling and logical design.
LO-4
The student knows the basic characteristics of widely used relational database management systems.
LO-5
The student gains the ability to make structural adjustments in the database as well as to insert, to delete and to update data and to build complex queries on a database.
LO-6
The student designs high quality database by using the top-down approach
of normalization process and its normal forms.
LO-7
The student manages the data through a modern programming language by establishing a database connection.