To comprehend the basic terms and concepts of database. Relational data model, table data structure, relational algebra operations, basic SQL and advanced SQL queries, ODBC, programming of stored procedures and functions, triggering and developing database applications
Course Content
This course contains; Introduction to Database Management System,Relational Model Database Model,Database design-ER Data Model,SQL-Data definition language, Data update language,SQL-SELECT Query,SQL-Data manipulation language-INSERT,UPDATE,DELETE,SQL-Query-Set operations, UNION, INTERSECT, EXCEPT,Midterm,SQL-JOIN,SQL-GROUP BY, HAVING,SQL-Sorgulama-Subquery,SQL-Triggers,SQL-Stored Procedure,SQL-Index, View.
Dersin Öğrenme Kazanımları
Teaching Methods
Assessment Methods
1. will be able to learn database concept and file systems.
6
A
1.1. Defines the concept of data.
14, 6
A
1.2. Lists file systems.
6
A
2. will be able to understand the advantages of database management system.
6
A
2.1. Defines atomicity.
6
A
2.2. Simultaneous access explorations.
6
A
2.3. Explains data security.
6
A
2.4. Explores the ease of finding data in the framework of DB.
6
A
3. will be able to schematically set up the relational model for any software.
6
A
3.1. Lists the basic properties of the relational database.
6
A
3.2. Explains the concepts of relationship and key.
6
A
4. Will be able to query on the database in SQL language.
6
A
4.1. Performs add, delete, update operations with SQL commands.
6
A
4.2. Explains the operators and tasks used in the SQL.
6
A
4.3. Applies the filtering operations on the data.
6
A
4.4. Uses interrogation inside.
6
A
5. Will be able to use SQL language in languages such as C #, VB.
6
A
5.1. Runs the SQL Server services.
6
A
5.2. Develops views.
6
A
6. will be able to design web based database applications.
6
A
6.1. Inserts database connection.
6
A
6.2. Designs own functions.
6
A
7. will be able to look at the whole software with the database.
14, 6
A
7.1. Develops advanced SQL commands.
6
A
Teaching Methods:
14: Self Study Method, 6: Experiential Learning
Assessment Methods:
A: Traditional Written Exam
Course Outline
Order
Subjects
Preliminary Work
1
Introduction to Database Management System
2
Relational Model Database Model
3
Database design-ER Data Model
4
SQL-Data definition language, Data update language
Database Management Systems, R. Ramakrishnan, J.Gehrke, Third Edition – Mc Graw Hill.
Second Edition: https://xuanhien.files.wordpress.com/2011/04/database-management-systems-raghu-ramakrishnan.pdf
Reading List:
1. Database Systems: A Practical Approach to Design, Implementation, and Management, 6th edition, Thomas Connolly, Carolyn Begg
2. Database Mangement Systems, R. Ramakrishnan, J.Gehrke, Third Edition – Mc Graw Hill.
3. Database System Concepts Avi Silberschatz, Henry F. Korth, S. SudarshanSeventh Edition, 2019
4. Veritabanı Sistemleri Dersi: Teoriden Pratiğe, N. ERCİL-ÇAĞILTAY ve G. TOKDEMİR, 2010
5. Veritabanı kavramı ve MS-SQL uygulamaları, Telciler, Coşkun, yazar, 2013
Course Contribution to Program Qualifications
Course Contribution to Program Qualifications
No
Program Qualification
Contribution Level
1
2
3
4
5
1
Defines the theoretical issues in the field of information and management.
X
2
Describes the necessary mathematical and statistical methods in the field of information and management.
X
3
Uses at least one computer program in the field of information and management.
X
4
Sustains proficiency in a foreign language requiredor information and management studies.
X
5
Prepares informatics/software projects and work in a team.
X
6
Constantly updates himself / herself by following developments in science and technology with an understanding of the importance of lifelong learning through critically evaluating the knowledge and skills that s/he has got.7. Uses theoretical and practical expertise in the field of information and management
X
7
Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication skills.
X
8
Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication.
X
9
Adopts organizational / institutional and social ethical values.
10
Within the framework of community involvement adopts social responsibility principles and takes initiative when necessary.
11
Uses and analyses basic facts and data in various disciplines (economics, finance, sociology, law, business) in order to conduct interdisciplinary studies.
X
12
Writes software in different platforms such as desktop, mobile, web on its own and / or in a team.
X
Assessment Methods
Contribution Level
Absolute Evaluation
Rate of Midterm Exam to Success
40
Rate of Final Exam to Success
60
Total
100
ECTS / Workload Table
Activities
Number of
Duration(Hour)
Total Workload(Hour)
Course Hours
0
0
0
Guided Problem Solving
0
0
0
Resolution of Homework Problems and Submission as a Report
0
0
0
Term Project
0
0
0
Presentation of Project / Seminar
0
0
0
Quiz
0
0
0
Midterm Exam
0
0
0
General Exam
0
0
0
Performance Task, Maintenance Plan
0
0
0
Total Workload(Hour)
0
Dersin AKTS Kredisi = Toplam İş Yükü (Saat)/30*=(0/30)
0
ECTS of the course: 30 hours of work is counted as 1 ECTS credit.
Detail Informations of the Course
Course Description
Course
Code
Semester
T+P (Hour)
Credit
ECTS
DATA BASE and DATA BASE MANAGEMENT SYSTEMS
MIS3112177
Fall Semester
3+0
3
4
Course Program
Prerequisites Courses
Recommended Elective Courses
Language of Course
English
Course Level
First Cycle (Bachelor's Degree)
Course Type
Required
Course Coordinator
Name of Lecturer(s)
Lect. Nada A. M. MISK
Assistant(s)
Aim
To comprehend the basic terms and concepts of database. Relational data model, table data structure, relational algebra operations, basic SQL and advanced SQL queries, ODBC, programming of stored procedures and functions, triggering and developing database applications
Course Content
This course contains; Introduction to Database Management System,Relational Model Database Model,Database design-ER Data Model,SQL-Data definition language, Data update language,SQL-SELECT Query,SQL-Data manipulation language-INSERT,UPDATE,DELETE,SQL-Query-Set operations, UNION, INTERSECT, EXCEPT,Midterm,SQL-JOIN,SQL-GROUP BY, HAVING,SQL-Sorgulama-Subquery,SQL-Triggers,SQL-Stored Procedure,SQL-Index, View.
Dersin Öğrenme Kazanımları
Teaching Methods
Assessment Methods
1. will be able to learn database concept and file systems.
6
A
1.1. Defines the concept of data.
14, 6
A
1.2. Lists file systems.
6
A
2. will be able to understand the advantages of database management system.
6
A
2.1. Defines atomicity.
6
A
2.2. Simultaneous access explorations.
6
A
2.3. Explains data security.
6
A
2.4. Explores the ease of finding data in the framework of DB.
6
A
3. will be able to schematically set up the relational model for any software.
6
A
3.1. Lists the basic properties of the relational database.
6
A
3.2. Explains the concepts of relationship and key.
6
A
4. Will be able to query on the database in SQL language.
6
A
4.1. Performs add, delete, update operations with SQL commands.
6
A
4.2. Explains the operators and tasks used in the SQL.
6
A
4.3. Applies the filtering operations on the data.
6
A
4.4. Uses interrogation inside.
6
A
5. Will be able to use SQL language in languages such as C #, VB.
6
A
5.1. Runs the SQL Server services.
6
A
5.2. Develops views.
6
A
6. will be able to design web based database applications.
6
A
6.1. Inserts database connection.
6
A
6.2. Designs own functions.
6
A
7. will be able to look at the whole software with the database.
14, 6
A
7.1. Develops advanced SQL commands.
6
A
Teaching Methods:
14: Self Study Method, 6: Experiential Learning
Assessment Methods:
A: Traditional Written Exam
Course Outline
Order
Subjects
Preliminary Work
1
Introduction to Database Management System
2
Relational Model Database Model
3
Database design-ER Data Model
4
SQL-Data definition language, Data update language
Database Management Systems, R. Ramakrishnan, J.Gehrke, Third Edition – Mc Graw Hill.
Second Edition: https://xuanhien.files.wordpress.com/2011/04/database-management-systems-raghu-ramakrishnan.pdf
Reading List:
1. Database Systems: A Practical Approach to Design, Implementation, and Management, 6th edition, Thomas Connolly, Carolyn Begg
2. Database Mangement Systems, R. Ramakrishnan, J.Gehrke, Third Edition – Mc Graw Hill.
3. Database System Concepts Avi Silberschatz, Henry F. Korth, S. SudarshanSeventh Edition, 2019
4. Veritabanı Sistemleri Dersi: Teoriden Pratiğe, N. ERCİL-ÇAĞILTAY ve G. TOKDEMİR, 2010
5. Veritabanı kavramı ve MS-SQL uygulamaları, Telciler, Coşkun, yazar, 2013
Course Contribution to Program Qualifications
Course Contribution to Program Qualifications
No
Program Qualification
Contribution Level
1
2
3
4
5
1
Defines the theoretical issues in the field of information and management.
X
2
Describes the necessary mathematical and statistical methods in the field of information and management.
X
3
Uses at least one computer program in the field of information and management.
X
4
Sustains proficiency in a foreign language requiredor information and management studies.
X
5
Prepares informatics/software projects and work in a team.
X
6
Constantly updates himself / herself by following developments in science and technology with an understanding of the importance of lifelong learning through critically evaluating the knowledge and skills that s/he has got.7. Uses theoretical and practical expertise in the field of information and management
X
7
Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication skills.
X
8
Follows up-to-date technology using a foreign language at least A1 level, holds verbal / written communication.
X
9
Adopts organizational / institutional and social ethical values.
10
Within the framework of community involvement adopts social responsibility principles and takes initiative when necessary.
11
Uses and analyses basic facts and data in various disciplines (economics, finance, sociology, law, business) in order to conduct interdisciplinary studies.
X
12
Writes software in different platforms such as desktop, mobile, web on its own and / or in a team.
