This course is designed to enable the student to understand the concepts of database and database management systems. It also provides necessary information about data modelling, database architectures, SQL language, Storage structures, Table Content, Query evaluation and optimization and transaction management, recovery and backup.
Prerequisite(s)
Course Code Course Name…
Corequisite(s)
Course Code Course Name…
Special Requisite(s)
The minimum qualifications that are expected from the students who want to attend the course.(Examples: Foreign language level, attendance, known theoretical pre-qualifications, etc.)
Instructor(s)
Assoc. Prof. Fadime ÜNEY-YÜKSEKTEPE
Course Assistant(s)
-
Schedule
The course is not offered this semester.
Office Hour(s)
The course is not offered this semester.
Teaching Methods and Techniques
-
Principle Sources
- Elmasri R., Navathe S.B., Fundamentals of Database Systems, 7th edition, Pearson Education, 2016.
- Ramakrishnan R., Gehrke J., Database Management Systems, McGraw Hill, 2003.
Other Sources
-
Course Schedules
Week
Contents
Learning Methods
1. Week
Introduction to databases, database system concepts and architectures
Oral presentation
2. Week
Data modelling using the entity-relationship (ER) model
Oral presentation, Laboratory
3. Week
Relational data model and relational database constraints, basic sql
Oral presentation, Laboratory
4. Week
SQL: complex queries, triggers, views
Oral presentation, Laboratory
5. Week
SQL queries
Oral presentation, Laboratory
6. Week
SQL queries, Access application
Oral presentation, Laboratory
7. Week
Midterm
8. Week
The relational algebra and relational calculus
Oral presentation, Laboratory
9. Week
Introduction to SQL programming techniques, web database programming using PHP, XML
Oral presentation, Laboratory
10. Week
Basics of functional dependencies and normalization for relational databases
Oral presentation, Laboratory
11. Week
Disk storage, basic file structures, hashing, and modern storage architectures, indexing structures for files and physical database design
Oral presentation, Laboratory
12. Week
Strategies for query processing, query optimization, introduction to transaction processing, Concurrency control techniques, database recovery techniques,
Oral presentation, Laboratory
13. Week
Distributed database concepts, NOSQL databases and big data storage systems, big data technologies based on MapReduce and Hadoop
Oral presentation, Laboratory
14. Week
Data mining concepts, overview of data warehousing and OLAP, database security
Oral presentation, Laboratory
15. Week
Final Exam
16. Week
Final Exam
17. Week
Final Exam
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
35
Project(s)
1
25
Final Exam
1
40
Program Outcomes
PO-1
Knowledge about management processes and management skills
PO-2
Knowledge and application skills related to the methods and competencies required for solving engineering problems
PO-3
Knowledge about developing areas of manufacturing and service sectors
PO-4
Ability to work in multi-disciplinary engineering teams
PO-5
Experience and knowledge of scientific research and publishing within the frame of academic ethics
Learning Outcomes
LO-1
Help students understand the role of database in various types of information systems and its importance in real world applications.
LO-2
Be familiar with commercial relational database systems (SQLite, MS Access, SAP).
LO-3
Discuss the concepts and fundamental principles involved in database systems.
LO-4
Develop data models using ER/EER diagramming.
LO-5
Use SQL to create, query, and maintain relational tables
LO-6
Be familiar with basic database storage structures and access techniques: file and page organizations, indexing methods including B-tree, and hashing.