TÜRKÇE
ENGLISH
Information
| Unit | KOZAN VOCATIONAL SCHOOL |
| Code | BL120 |
| Name | Database-I |
| Term | 2021-2022 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 3-1 (T-A) (17 Week) |
| ECTS | 5 ECTS |
| National Credit | 3.5 National Credit |
| Teaching Language | Türkçe |
| Level | Ön Lisans Dersi |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Öğr. Gör. Dr. ADNAN GÖKTEN |
| Course Instructor |
Öğr. Gör. Dr. ADNAN GÖKTEN
(Bahar)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
Recognition database and relational database concepts, to design the database, the database control, access and use administrative tools, to develop the ability to use the SQL language.
Course Content
TThe database and relational database concept, design, normalization and the use of SQL language.
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | The database knows the concepts and relational database. |
| LO02 | Knows the principles of database design. |
| LO03 | Make the correct associations between the tables |
| LO04 | Recognizes the basic database programs. |
| LO05 | Database control, access, and knows to use administrative tools. |
| LO06 | Effectively use the MS Access program. |
| LO07 | Efficiently use the SQL language. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | - | Explain the basic scientific concepts related to Computer Technologies. | 0 |
| PLO02 | - | Explains the functions of the electronic circuit elements that make up the computer subcomponents. | 0 |
| PLO03 | - | Explains the basic concepts in the field of computer technologies. He / she installs and uses word processing, spreadsheet and presentation programs. | 0 |
| PLO04 | - | Has the ability to solve problems in the field of computer programming. | 0 |
| PLO05 | - | Explains basic concepts about computer hardware, makes simple installation, solves problems that do not require expertise. | 0 |
| PLO06 | - | Know basic database systems, design and implement client / server software. | 0 |
| PLO07 | - | In Computer Technologies, students use graphical programs used in interface design and 3D modeling in web pages at basic level. | 0 |
| PLO08 | - | Explains, designs and installs network systems. | 0 |
| PLO09 | - | Uses Internet technologies, develops server-side working internet applications. | 0 |
| PLO10 | - | It is able to carry out a basic study related to its field in independent or disciplined teams and has the confidence to take responsibility. | 0 |
| PLO11 | - | By taking into consideration the necessity of lifelong learning, it follows the developments in its field and can do resource research for this purpose, use databases and other information sources. | 0 |
| PLO12 | - | Knows a foreign language which is sufficient for the applications in the field. | 0 |
| PLO13 | - | To be able to communicate effectively in written and oral Turkish. | 0 |
| PLO14 | - | He/she can clearly explain the designs and applications related to computer technologies to his colleagues, superiors, others who are related to the field or not. | 0 |
| PLO15 | - | Has knowledge about Atatürk's Principles and History of Revolution. | 0 |
| PLO16 | - | It is aware of occupational health and safety, environmental and ethical values within the framework of global and social values. | 0 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Access to the database. | preparation is not required | |
| 2 | The database and a relational database, the basic concepts. | preparation is not required | |
| 3 | Table structure and fields. | preparation is not required | |
| 4 | Area characteristics and to determine the types of data, comparison of different databases. | preparation is not required | |
| 5 | Access database program part 1 | preparation is not required | |
| 6 | Access database program part 2 | preparation is not required | |
| 7 | Application works with the Access database program. | preparation is not required | |
| 8 | Mid-Term Exam | ||
| 9 | Introduction to SQL. | preparation is not required | |
| 10 | SQL queries. part 1 | preparation is not required | |
| 11 | SQL queries. part 2 | preparation is not required | |
| 12 | SQL queries. part 3 | preparation is not required | |
| 13 | Implementation activities | preparation is not required | |
| 14 | Implementation activities. part 1 | preparation is not required | |
| 15 | Implementation activities. part 2 | preparation is not required | |
| 16 | Term Exams | ||
| 17 | Term Exams |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 4 | 56 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 3 | 42 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 1 | 1 | 1 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 8 | 8 |
| Final Exam | 1 | 16 | 16 |
| Total Workload (Hour) | 123 | ||
| Total Workload / 25 (h) | 4,92 | ||
| ECTS | 5 ECTS | ||