MYP124


Course Title Course Code Program Level
DATABASE I MYP124 Informatics Security Technology Associate Degree

Course Term
(Course Semester)
Teaching and Learning Methods
Credits
Theory Practice Lab Projects/Field Work Seminars/Workshops Other Total Credits ECTS Credits
02
(Spring)
28 42 28 35 128 3 5

Teaching Staff Dr. Öğr. Üyesi Mehmet Ali ÇİNİCİ
Language of Instruction Türkçe (Turkish)
Type Of Course Vocational
Prerequisites
Recommended Optional Programme Component Teaching consists of lectures, questions and answers, seminars, lab applications and practical studies and case studies (database designs). Practical work is done in groups or individually. It is compulsory to attend these events.
Course Objectives The competencies of analyzing database needs, making conceptual / physical design, creating, querying, and using database administrative functions will be gained.
Course Content Course content: • Basic concepts of database management systems, • Design of data models for database design, • Query processing and optimization issues, • Database system architectures, etc. To gain the necessary skills at the comprehension and application level of the subjects.
Learning Outcomes (LO) After completion of this course the students will be able: LO.1: Designing a database at a conceptual and physical level; LO.2: Advanced-reverse engineering; LO.3: To understand the basic database assets and the relationships between these entities; LO.4: Creating-deleting the database; LO.5: Basic/advanced querying in the database; LO.6: Performing basic data operations in the database.
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)
3. Week Entity-Relationship Modeling (Conceptual Design) with ER and UML, and Related Tools
4. Week Basic database entities and integrity constraints
5. Week Converting conceptual database design to physical database design
6. Week Physical database design (creating tables and specifying their properties)
7. Week SQL: Querying, Data Processing, Updating and Their Applications
8. Week MIDTERM EXAM
9. Week SQL: Multilevel, Nested Querying, Query Optimization,Functions and Their Usages
10. Week Data Definition Language (DDL) / Data Manipulation Language (DML)
11. Week Editing the table structure
12. Week Forward/reverse engineering
13. Week Advanced SQL operations and bulk data transfer
14. Week PL/SQL: Introduction To Embeded Databases, Functions and Defining The Packets
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 1. Prof. Dr. A. Ünal YARIMAĞAN (2000). Veritabanı Sistemleri. Akademi & Türkiye Bilişim Vakfı. 2. Ramez Elmasri & Shamkant B. Navathe (2016). Fundamentals of Database Systems. Pearson Higher Education. 7th Global Edition.
Work Placement(s)
The Relationship between Program Qualifications (PQ) and Course Learning Outcomes (LO)
 

PQ.1

PQ.2

PQ.3

PQ.4

PQ.5

PQ.6

PQ.7

PQ.8

PQ.9

PQ.10

PQ.11

LO.1

4

5

5

5

 

2

2

 

 

 

 

LO.2

5

5

5

5

3

 

3

 

 

2

 

LO.3

5

5

5

5

 

4

2

 

 

 

3

LO.4

5

 

5

5

2

3

3

 

3

 

 

LO.5

5

5

5

5

4

 

3

 

 

 

 

LO.6

5

5

5

5

 

3

3

 

 

2