| Course Description |
|
| Course Name |
: |
Databases |
|
| Course Code |
: |
MT 487 |
|
| Course Type |
: |
Optional |
|
| Level of Course |
: |
First Cycle |
|
| Year of Study |
: |
4 |
|
| Course Semester |
: |
Fall (16 Weeks) |
|
| ECTS |
: |
5 |
|
| Name of Lecturer(s) |
: |
Lecturer YOLDAŞ ERDOĞAN
|
|
| Learning Outcomes of the Course |
: |
Learns how to create tables in a relational database.
Learns how to insert and retrieve data to and from a table using SQL.
Learns the normal forms used in creating a relational database.
Learns set valued functions and searching for data using OUTER JOIN.
Learns to write stored procedures.
Learns to write user defined scalar or table valued functions.
Learns the basic principles of security.
|
|
| Mode of Delivery |
: |
Face-to-Face |
|
| Prerequisites and Co-Prerequisites |
: |
ENF204 Introduction to Computer Programming
MT 373 Visual Basic Programming
|
|
| Recommended Optional Programme Components |
: |
None |
|
| Aim(s) of Course |
: |
Students will encounter in different applications to transfer large chunks of data to a computer on a regular basis. The components of the data retrieval methods. Different Database Management Systems, Using standard SQL statements to access data are taught. |
|
| Course Contents |
: |
What is Database?, Why Use a Database?, DBMS Components, Database Models, multi-user DBMS Architecture.
Components associated with the Database Model, Table, Record, Field, Index, Key, normalization rules, different types of relationships between tables.
Clustering Arithmetic Expressions and Functions SUM, AVG, COUNT, MAX, MIN, TOP N.
Using more than one table, query, INNER JOIN, RIGHT JOIN, LEFT JOIN, UNION.
Table Creation, Modification tables, INSERT / UPDATE / DELETE |
|
| Language of Instruction |
: |
Turkish |
|
| Work Place |
: |
Laboratory |
|
|
Course Outline /Schedule (Weekly) Planned Learning Activities |
| Week | Subject | Student's Preliminary Work | Learning Activities and Teaching Methods |
|
1 |
Introduction to data structures in computers |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
2 |
Creating tables in a database |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
3 |
Inserting, updating and access to a database using simple SQL |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
4 |
Data access by joining more than one table |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
5 |
Data access using JOIN in more than one table |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
6 |
Normal Forms |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
7 |
Set valued functions |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
8 |
Midterm exam |
Review |
Written Exam |
|
9 |
System functions |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
10 |
Use of OUTER JOIN |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
11 |
Stored Procedures |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
12 |
Examples of Stored Procedures |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
13 |
User defined scalar and table valued functions |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
14 |
Security |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
15 |
Security |
Reading the relevant parts of the course notes |
Lecture and hands on application |
|
16/17 |
Final Exam |
Review |
Written Exam |
|
|
| Contribution of the Course to Key Learning Outcomes |
| # | Key Learning Outcome | Contribution* |
|
1 |
Is able to prove Mathematical facts encountered in secondary school. |
0 |
|
2 |
Recognizes the importance of basic notions in Algebra, Analysis and Topology |
0 |
|
3 |
Develops maturity of mathematical reasoning and writes and develops mathematical proofs. |
3 |
|
4 |
Is able to express basic theories of mathematics properly and correctly both written and verbally |
5 |
|
5 |
Recognizes the relationship between different areas of Mathematics and ties between Mathematics and other disciplines. |
2 |
|
6 |
Expresses clearly the relationship between objects while constructing a model |
4 |
|
7 |
Draws mathematical models such as formulas, graphs and tables and explains them |
3 |
|
8 |
Is able to mathematically reorganize, analyze and model problems encountered. |
2 |
|
9 |
Knows at least one computer programming language |
3 |
|
10 |
Uses effective scientific methods and appropriate technologies to solve problems |
5 |
|
11 |
Knows programming techniques and is able to write a computer program |
0 |
|
12 |
Is able to do mathematics both individually and in a group. |
0 |
|
13 |
Has sufficient knowledge of foreign language to be able to understand Mathematical concepts and communicate with other mathematicians |
0 |
|
14 |
In addition to professional skills, the student improves his/her skills in other areas of his/her choice such as in scientific, cultural, artistic and social fields |
0 |
| * Contribution levels are between 0 (not) and 5 (maximum). |
|
|