BYM301 Database ManagementInstitutional InformationDegree Programs Computer EngineeringInformation For StudentsDiploma SupplementErasmus Policy StatementNational Qualifications
Computer Engineering

Preview

Bachelor TR-NQF-HE: Level 6 QF-EHEA: First Cycle EQF-LLL: Level 6

Course General Introduction Information

Course Code: BYM301
Course Name: Database Management
Course Semester: Fall
Course Credits:
ECTS
7
Language of instruction: TR
Course Requirement:
Does the Course Require Work Experience?: No
Type of course: Necessary
Course Level:
Bachelor TR-NQF-HE:6. Master`s Degree QF-EHEA:First Cycle EQF-LLL:6. Master`s Degree
Mode of Delivery: Face to face
Course Coordinator : Dr.Öğr.Üyesi KEMAL ÇAĞRI SERDAROĞLU
Course Lecturer(s): Öğr. Üyesi Kemal Çağrı Serdaroğlu
Course Assistants:

Course Purpose and Content

Course Objectives: The aim of this course is to provide the principles and concepts of database management systems.
Course Content: Design algorithms and applications; entity-relationship model; hierarchical, network, relational databases; query languages; relational algebra and calculus; data dependencies; normal forms; concurrency, integrity and security issues; term project.

Learning Outcomes

The students who have succeeded in this course;
1) Adequate knowledge in database management systems concepts; ability to use theoretical and applied information in this area to model and solve engineering problems.
2) Ability to design and implement properly structured databases that match the standards based under realistic constraints and conditions.
3) Ability to use SQL language for constructing and utilizing database applications that meet the needs of engineering problems.

Course Flow Plan

Week Subject Related Preparation
1) Introduction to the Database Management Systems Textbook
2) The Entity-Relationship Model Textbook
3) Generalization, Aggregation, Design of an E-R Database Scheme Textbook
4) Relational Algebra Textbook
5) Query Processing Textbook
6) Modification of the Database, Views Textbook
7) Midterm Textbook
8) SQL I Textbook
9) SQL II Textbook
10) Integrity Constraints Textbook
11) Relational Database Design Textbook
12) Trigger and Procedures Textbook
13) Web Based Application Design, XML and XSLT Textbook
14) Normalization, Normal Forms Textbook

Sources

Course Notes / Textbooks: Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems, 3rd Edition, McGraw-Hill, 2003
References: Ders Notları, LAb Materyali

Course - Learning Outcome Relationship

No Effect 1 Lowest 2 Medium 3 Highest
       
Program Outcomes Level of Contribution
1) Adequate knowledge in mathematics, science and engineering subjects pertaining to the relevant discipline; ability to use theoretical and applied knowledge in these areas in complex engineering problems. 3
2) Ability to identify, formulate, and solve complex engineering problems; ability to select and apply proper analysis and modeling methods for this purpose. 3
3) Ability to design a complex system, process, device or product under realistic constraints and conditions, in such a way as to meet the desired result; ability to apply modern design methods for this purpose 3
4) Ability to devise, select, and use modern techniques and tools needed for analyzing and solving complex problems encountered in engineering practice; ability to employ information technologies effectively. 3
5) Ability to design and conduct experiments, gather data, analyze and interpret results for investigating complex engineering problems or discipline specific research questions. 2
6) Ability to work efficiently in intra-disciplinary and multi-disciplinary teams; ability to work individually. 2
7) Ability to communicate effectively in Turkish, both orally and in writing; knowledge of a minimum of one foreign language; ability to write effective reports and comprehend written reports, prepare design and production reports, make effective presentations, and give and receive clear and intelligible instructions. 2
8) Knowledge of the global and societal impacts of engineering practices on priority issues such as health, environment and safety and contemporary issues; knowledge of the legal aspects of engineering solutions. awareness of the consequences 2
9) Consciousness to behave according to ethical principles and professional and ethical responsibility; knowledge on standards used in engineering practice. 2
10) Information about business life practices such as project management, risk management, and change management; awareness of entrepreneurship, innovation, and knowledge about sustainable development. 2
11) Ability to design systems to meet desired needs 2
12) Ability to apply basic sciences in the field of computer engineering 2
13) Ability to implement designs by experiments 2
14) Recognition of the need for lifelong learning; ability to access information, to follow developments in science and technology, and to continue to educate him/herself. 2

Learning Activity and Teaching Methods

Bireysel çalışma ve ödevi
Labs
Homework
Proje Hazırlama
Rapor Yazma

Measurement and Evaluation Methods and Criteria

Yazılı Sınav (Açık uçlu sorular, çoktan seçmeli, doğru yanlış, eşleştirme, boşluk doldurma, sıralama)
Homework
Bireysel Proje
Raporlama

Assessment & Grading

Semester Requirements Number of Activities Level of Contribution
Laboratory 5 % 10
Homework Assignments 2 % 5
Project 1 % 15
Midterms 1 % 25
Final 1 % 45
total % 100
PERCENTAGE OF SEMESTER WORK % 55
PERCENTAGE OF FINAL WORK % 45
total % 100

İş Yükü ve AKTS Kredisi Hesaplaması

Activities Number of Activities Aktiviteye Hazırlık Aktivitede Harçanan Süre Aktivite Gereksinimi İçin Süre Workload
Course Hours 13 3 39
Application 13 2 26
Study Hours Out of Class 14 3 42
Project 1 44 44
Midterms 1 2 2
Paper Submission 1 40 40
Final 1 2 2
Total Workload 195