MYP217


Course Title Course Code Program Level
DATABASE I MYP217 Computer Programming Associate Degree

Course Term
(Course Semester)
Teaching and Learning Methods
Credits
Theory Practice Lab Projects/Field Work Seminars/Workshops Other Total Credits ECTS Credits
03
(Fall)
28 28 56 3 5

Teaching Staff
Language of Instruction Türkçe (Turkish)
Type Of Course Compulsory
Prerequisites
Recommended Optional Programme Component
Course Objectives
Course Content
Learning Outcomes (LO) To help students learn • Basic concepts about database management systems, • The designs of data models aimed at database design, • Querying, optimization, transaction processing and coupling, • Database system architectures • The required skills at the level of cognition and practice for the purpose of completing the tasks ,which are in the concept of database manager, such as application development,backup,disaster recovery etc...
Mode of Delivery Face to face
Course Outline
Week Topics
1. Week Introduction To Database And Database Management Systems
2. Week Relational Database Design and Development (Analysis, Conceptual, Logical and Physical Design Phases), Tools Which Are Related With Them
3. Week ER and Entity-Relation Modeling with UML (Conceptual Design)
4. Week Relational Data Models and Transformations (Logical Design)
5. Week Functional Dependency and Integrity Constraints
6. Week Normalization (1NF, 2NF, 3NF, BCNF)
7. Week Normalization and A Case Study Example
8. Week Midterm
9. Week Basic Operations In Database Management (Defining and Creating Objects Such As Database,Schema,User,Table, etc... )
10. Week SQL: Defining and Updating Tables/Objects, Integrity Constraints and Their Applications
11. Week SQL: Querying, Data Processing, Updating and Their Applications
12. Week SQL: Multilevel, Nested Querying, Query Optimization,Functions and Their Usages
13. Week PL/SQL: Introduction To Embeded Databases, Functions and Defining The Packets
14. Week PL/SQL: Assignment, Control and Loops
Assessment
  Percentage(%)
Mid-term (%) 40
Quizes (%)
Homeworks/Term papers (%)
Practice (%)
Labs (%)
Projects/Field Work (%)
Seminars/Workshops (%)
Final (%) 60
Other (%)
Total(%) 100
Course Book (s) and/or References Ünal Yarımağan, Veri Tabanı Sistemleri, Akademi Yayınevi, 2010. Mannino, Michael V, Database Design, Application Development and Administration, McGraw-Hill, 2007. Connolly, T.M. and Begg, C.E. Database Systems: A Practical Approach to Design, Implementation, and Management, addison-Wesley, 2005. A. Silberschatz, H.F. Korth ve S. Sudarshan. Database Systems Concepts 6th Edition. McGraw Hill, 2010. Elmasri and Navathe, Fundamentals of Database Systems, Sixth Edition, Pearson Education, 2010 Raghu Ramakrishnan and Johannes Gehrke, “Database Management Systems”, Third Edition, McGraw-Hill, 2002. Oracle 12g Administration Fundamentals I & II ve Oracle ile ilgili bütün açık kaynaklar. Çağıltay, N. E ve Tokdemir, G. Veritabanı Sistemleri Dersi: Teoriden Pratiğe. Seçkin Yayıncılık, Ankara, 2010.
Work Placement(s)
The Relationship between Program Qualifications (PQ) and Course Learning Outcomes (LO)