GAZI UNIVERSITY INFORMATION PACKAGE - 2019 ACADEMIC YEAR

COURSE DESCRIPTION
DATABASE AND DATABASE MANAGEMENT-I/BİL110
Course Title: DATABASE AND DATABASE MANAGEMENT-I
Credits 4 ECTS 4
Course Semester 2 Type of The Course Compulsory
COURSE INFORMATION
 -- (CATALOG CONTENT)
 -- (TEXTBOOK)
 -- (SUPPLEMENTARY TEXTBOOK)
 -- (PREREQUISITES AND CO-REQUISITES)
 -- LANGUAGE OF INSTRUCTION
  Turkish
 -- COURSE OBJECTIVES
 -- COURSE LEARNING OUTCOMES
Designing and creating a database
To make database normalization operations
To make basic table operations
Querying the database
Advanced queries, trigger, write views

 -- MODE OF DELIVERY
  Face to face training, practice, demonstration
 --WEEKLY SCHEDULE
1. Week  To recognize databases and to use interface components.
2. Week  Database needs analysis and normalization
3. Week  To create a database, to recognize data types, to create tables and properties
4. Week  To create a database, to recognize data types, to create tables and properties
5. Week  Normalization
6. Week  Using DML (Data Manipulation Language) commands and creating queries
7. Week  Using DML Queries
8. Week  Create advanced query and use variants
9. Week  Create and use advanced queries and subqueries
10. Week  Prepare a query with related tables
11. Week  Prepare a query with related tables
12. Week  Advanced queries and views
13. Week  Advanced queries triggers
14. Week  Using DDL (Data Definition Language) commands
15. Week  
16. Week  
 -- TEACHING and LEARNING METHODS
 -- ASSESSMENT CRITERIA
 
Quantity
Total Weighting (%)
 Midterm Exams
1
40
 Assignment
0
0
 Application
0
0
 Projects
0
0
 Practice
0
0
 Quiz
0
0
 Percent of In-term Studies  
40
 Percentage of Final Exam to Total Score  
60
 -- WORKLOAD
 Activity  Total Number of Weeks  Duration (weekly hour)  Total Period Work Load
 Weekly Theoretical Course Hours
14
3
42
 Weekly Tutorial Hours
14
1
14
 Reading Tasks
0
 Searching in Internet and Library
10
2
20
 Material Design and Implementation
0
 Report Preparing
0
 Preparing a Presentation
0
 Presentation
0
 Midterm Exam and Preperation for Midterm Exam
1
10
10
 Final Exam and Preperation for Final Exam
1
15
15
 Other (should be emphasized)
0
 TOTAL WORKLOAD: 
101
 TOTAL WORKLOAD / 25: 
4.04
 Course Credit (ECTS): 
4
 -- COURSE'S CONTRIBUTION TO PROGRAM
NO
PROGRAM LEARNING OUTCOMES
1
2
3
4
5
1Has the mathematical and computational knowledge required by the field.X
2Analyze the needs related to computer software with the knowledge learned in the fieldX
3Plans computer software development processes with the knowledge learned in the fieldX
4Develops computer software with the knowledge learned in the fieldX
5Tests the computer software with the knowledge learned in the fieldX
6Has basic theoretical and practical knowledge in internet programming and web design.X
7Use the algorithmic thinking and planning approach in their applications.X
8Detects hardware failures that may occur in computer systems.X
9Fixes hardware failures that may occur in computer systems.X
10Develops interface designs used in software applications.X
11Work effectively individually or in teams by researching, finding solutions when faced with unforeseen situations with the basic knowledge acquired in the field.X
12With the awareness of the necessity of lifelong learning, follows the recent developments in information and communication technologies.X
13Communicates verbally and in writing; use at least one foreign language at least at the level of European Language Portfolio A2 General Level, monitor information in the field of informatics and computer science and communicate with colleagues.X
14Be aware of occupational and ethical responsibility in the field, taking care of occupational ethics in information applications, care about occupational health and safetyX
 -- NAME OF LECTURER(S)
   (Inst. Ertuğrul DUMAN)
 -- WEB SITE(S) OF LECTURER(S)
   (www://websitem.gazi.edu.tr/site/dumanertugrul)
 -- EMAIL(S) OF LECTURER(S)
   (dumanertugrul@gazi.edu.tr)