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 optimisation and transaction management, recovery and backup.
Prerequisite(s)
None
Corequisite(s)
None
Special Requisite(s)
None
Instructor(s)
Assoc. Prof. Emre ALPTEKİN
Course Assistant(s)
Oğuz Emir
Schedule
This course is not offered in this semester.
Office Hour(s)
This course is not offered in this semester.
Teaching Methods and Techniques
-PowerPoint Lectures,
-Case Studies
-Reseach and Application,
-Laboratory
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 conecpts 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
16. Week
Final
17. Week
Final
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
25
Homework / Term Projects / Presentations
3
10
Project(s)
1
25
Final Exam
1
40
Program Outcomes
PO-1
Ability to apply theoretical and practical knowledge gained by Mathematics, Science and their engineering fields and ability to use their knowledge in solving complex engineering problems.
PO-2
Ability of determining, defining, formulating and solving complex engineering problems; for that purpose develop the ability of selecting and implementing suitable models and methods of analysis.
PO-3
Ability of designing a complex system, process, device or product under real world constraints and conditions serving certain needs; for this purpose ability of applying modern design techniques
PO-4
Ability of selecting and using the modern techniques and devices which are necessary for analyzing and solving complex problems in engineering implementations; ability of efficient usage of information technologies.
PO-5
Ability of designing experiments, conducting tests, collecting data and analyzing and interpreting the solutions to investigate of complex engineering problems or discipline-specific research topics.
PO-6
Ability of working efficiently in intra-disciplinary and multi-disciplinary teams; individual working ability and habits.
PO-7
Ability of verbal and written communication skills; and at least one foreign language skills, ability to write effective reports and understand written reports, ability to prepare design and production reports, ability to make impressive presentation, ability to give and receive clear and understandable instructions
PO-8
Awareness of importance of lifelong learning; ability to access data, to follow up the recent innovation in science and technology for continuous self-improvement.
PO-9
Conformity to ethical principles; knowledge about occupational and ethical responsibility, and standards used in engineering applications.
PO-10
Knowledge about work life implementations such as project management, risk management and change management; awareness about entrepreneurship and innovativeness; knowledge about sustainable development.
PO-11
Knowledge about effects of engineering applications on health, environment and security in global and social dimensions, and on the problems of the modern age in engineering; awareness about legal outcomes of engineering solutions.
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.