TÜRKÇE
ENGLISH
Information
| Unit | CEYHAN VOCATIONAL SCHOOL |
| Code | BLP152 |
| Name | Database -I |
| Term | 2020-2021 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 2-1 (T-A) (17 Week) |
| ECTS | 5 ECTS |
| National Credit | 2.5 National Credit |
| Teaching Language | Türkçe |
| Level | Ön Lisans Dersi |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Uzaktan Öğretim |
| Catalog Information Coordinator | Öğr. Gör. BERİN YENİ |
| Course Instructor |
Öğr. Gör. BERİN YENİ
(Bahar)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
To give students ability to design and create database, make queries and use databse management functions.
Course Content
Basic properties of classic file system, advantages and disadvantages, general structure and properties of database systems
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Explain the concepts of data and database |
| LO02 | Illustrate and use relational model concepts |
| LO03 | Uses Microsoft Access |
| LO04 | Prepares query with related tables |
| LO05 | Creates Form and Report |
| LO07 | , |
| LO12 | To list the rules and constraints of normal forms. |
| LO13 | Changing the properties of objects and forms. |
| LO14 | Creating and using the type of query. |
| LO15 | Creating and using the type of query. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | - | Takes part in planning related to computer software and hardware | 2 |
| PLO02 | - | Students will be able to define, collect and use the data necessary for the solution of well-defined problems in Computer Technologies and Programming. demonstrate that he / she can use the theoretical knowledge, knowledge and skills required in practical applications | 2 |
| PLO03 | - | Word processor, spreadsheet, presentation, database and installs and uses various software | 2 |
| PLO04 | - | Makes coding, internet and network makes the installation of devices | 3 |
| PLO05 | - | Have sufficient knowledge of Turkish and foreign languages. | 1 |
| PLO06 | - | Evaluates and supervises the performances of the employees under their responsibility | 1 |
| PLO07 | - | Detects software and simple hardware failures in the computer and solves problems that do not require expertise | 1 |
| PLO08 | - | Use appropriate techniques with verbal, numerical and graphical expression | 2 |
| PLO09 | - | Creates computer technology related design and applications with team work and presents to related people and institutions | 2 |
| PLO10 | - | Gain analytical and numerical thinking skills and contribute to national economy by using knowledge and skills related to the field in accordance with regulations | 2 |
| PLO11 | - | Provides professional connections in the public and private sector business areas and uses appropriate tools in the social and professional field in the decision-making process | 1 |
| PLO12 | - | Conduct research using the Internet and various communication technologies | 1 |
| PLO13 | - | Demonstrate the ability to learn and learn independently in the field of Computer Technologies and Programming | 1 |
| PLO14 | - | Conducts teamwork in accordance with the basic concepts of human relations and entrepreneurship | 1 |
| PLO15 | - | Have knowledge about Atatürk's Principles and Revolution History | 0 |
| PLO16 | - | Demonstrate the ability to identify problems and find solutions to unforeseen situations in work in the field of Computer Technologies | 2 |
| PLO17 | - | Takes part in software, hardware and network discoveries | 1 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Basic properties of classic file system, advantages and disadvantages, general structure and properties of database systems | Developing sample application the computer lab | |
| 2 | Entry into the database, database and data modeling, DBMS types and concepts | Developing sample application the computer lab | |
| 3 | E-R model, the presence of a set of assets, attributes, relations concepts, relationship types | Developing sample application the computer lab | |
| 4 | Relational database | Developing sample application the computer lab | |
| 5 | Key areas, foreign key, descriptive qualities, to be converted to the correlation table | Developing sample application the computer lab | |
| 6 | Creating tables in MS Access application, field types, relationship identification, reporting, | Developing sample application the computer lab | |
| 7 | Creating query in MS Access application, | Developing sample application the computer lab | |
| 8 | Mid-Term Exam | Developing sample application the computer lab | |
| 9 | Repetition and Midterm Exam | Repetition and Midterm Exam | |
| 10 | Database objects | Developing sample application the computer labDeveloping sample application the computer lab | |
| 11 | Data analysis and multiple tables | Developing sample application the computer labDeveloping sample application the computer lab | |
| 12 | Prepare a query with related tables | Developing sample application the computer labDeveloping sample application the computer lab | |
| 13 | Form appliation | Developing sample application the computer labDeveloping sample application the computer lab | |
| 14 | Operations on Forms | Developing sample application the computer labDeveloping sample application the computer lab | |
| 15 | User access and control | Developing sample application the computer labDeveloping sample application the computer lab | |
| 16 | Term Exams | Repetition and Final Exam | |
| 17 | Term Exams | Repetition and Final Exam |
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 | 3 | 42 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 3 | 42 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 1 | 2 | 2 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 12 | 12 |
| Final Exam | 1 | 18 | 18 |
| Total Workload (Hour) | 116 | ||
| Total Workload / 25 (h) | 4,64 | ||
| ECTS | 5 ECTS | ||