Türkçe | English
TRABZON VOCATIONAL SCHOOL / DEPARTMENT of COMPUTER TECHNOLOGIES
Computer Programming
Course Catalog
http://www.trabzonmyo.ktu.edu.tr/
Phone: +90 0462 2281052
TMYO
TRABZON VOCATIONAL SCHOOL / DEPARTMENT of COMPUTER TECHNOLOGIES / Computer Programming
Katalog Ana Sayfa
  Katalog Ana Sayfa  KTÜ Ana Sayfa   Katalog Ana Sayfa
 
 

TBIL1002Database I3+1+0ECTS:5
Year / SemesterSpring Semester
Level of CourseShort Cycle
Status Compulsory
DepartmentDEPARTMENT of COMPUTER TECHNOLOGIES
Prerequisites and co-requisitesNone
Mode of Delivery
Contact Hours14 weeks - 3 hours of lectures and 1 hour of practicals per week
LecturerÖğretim Görevlisi Nurşah DİNCER
Co-Lecturer
Language of instructionTurkish
Professional practise ( internship ) None
 
The aim of the course:
With this course the student, data base designing, creating, querying a database using the administrative functions of the gain qualifications.
 
Learning OutcomesCTPOTOA
Upon successful completion of the course, the students will be able to :
LO - 1 : Able to analyze the needs of the database. 2. Normalization will be able to.1,2,3,4,5,6,7,81
LO - 2 : 1. Database tools to make the installation of 2. Create a table and determine the characteristics of1,2,3,4,5,6,7,81
LO - 3 : 1. Query to create and use a variety of 2. Prepare related statements and query 3. Using DML queries1,2,3,4,5,6,7,81
LO - 4 : 1. Users write queries 2. Appearance write queries 3. Write queries that trigger 4. Subroutine to write queries 5. Transaction Transaction Processing 6. Index write queries1,2,3,4,5,6,7,81
CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome

 
Contents of the Course
1 Database Needs Analysis Normalization 2 Normalization 3 Normalization 4 Database Tools Setup to make Creating Tables and Identify Features 5 Tables Create and Identify Features Creating Tables 6 and determine the characteristics of Varieties of 7 Create and use Query Create and use Query Varieties of 8 Prepare a query with related tables Creating Tables Associated with 9 queries 10 DML queries to use 11 queries to use DML User Queries Writing Writing Queries 12 Views Writing Queries Trigger Write to the trigger 13 queries Write to the Sub-Programme Queries 14 Transaction Processing to do Writing Queries Index
 
Course Syllabus
 WeekSubjectRelated Notes / Files
 Week 1DATABASE NEEDS ANALYSIS Database definition. Restrictions Key features of relational database tables in the database tables data constraints constraints
 Week 2Normalization The absolute excess of unnecessary data redundancy data back to first normal form (1nF) features 1nF 1nF problems (add, delete, update, during) the second normal form (2NF) 2NF properties. 2NF problems (adding, deleting, during) the third normal form (3NF) 3NF 3NF properties of problems (during insertion) Boyce-Codd normal form
 Week 3Normalization The absolute excess of unnecessary data redundancy data back to first normal form (1nF) features 1nF 1nF problems (add, delete, update, during) the second normal form (2NF) 2NF properties. 2NF problems (adding, deleting, during) the third normal form (3NF) 3NF 3NF properties of problems (during insertion) Boyce-Codd normal form
 Week 4Normalization The absolute excess of unnecessary data redundancy data back to first normal form (1nF) features 1nF 1nF problems (add, delete, update, during) the second normal form (2NF) 2NF properties. 2NF problems (adding, deleting, during) the third normal form (3NF) 3NF 3NF properties of problems (during insertion) Boyce-Codd normal form
 Week 5STATEMENTS OF CREATING AND DEFINING FEATURES Statements Statements in data types can Switches (Keys) Constraints (Constraints). Rules (Rules) Statements about the operations to create a new table to add columns to the properties of extraction columns
 Week 6STATEMENTS OF CREATING AND DEFINING FEATURES Statements Statements in data types can Switches (Keys) Constraints (Constraints). Rules (Rules) Statements about the operations to create a new table to add columns to the properties of extraction columns
 Week 7STATEMENTS OF CREATING AND DEFINING FEATURES Statements Statements in data types can Switches (Keys) Constraints (Constraints). Rules (Rules) Statements about the operations to create a new table to add columns to the properties of extraction columns
 Week 8Create the queries TYPES AND USE Query the database with the SQL language to create structure. Create a table with a query to delete the table. Column to add columns limiting Table update the SELECT statement syntax. Sort by limiting the operations of rows in SQL functions
 Week 9Mid Term
 Week 10RELATED TABLES Preparing queries with Combining multiple statements, use of tables is equal to the Cartesian product queries Sub query definition sub-assembly combining unequal subquery Single-column sub-queries, multi-column subqueries regulation rules
 Week 11USING DML queries The process of adding value is NULL, the INSERT statement to add rows in a table structure of the use of functions to copy a row in a table with other table data structure update UPDATE statement to update the tables with data read from another table, delete data using the DELETE statement to delete data structure read from another table
 Week 12USING DML queries The process of adding value is NULL, the INSERT statement to add rows in a table structure of the use of functions to copy a row in a table with other table data structure update UPDATE statement to update the tables with data read from another table, delete data using the DELETE statement to delete data structure read from another table
 Week 13WRITING user queries User create (Create User) with the ANSI SQL statement with T-SQL statement using PL-SQL statement Subroutine
 Week 14VIEW write queries Using the View tables, combining the purposes of simplifying the security queries. With a single query to do jobs that can not be
 Week 15TRIGGER the purposes and types of write queries using Insert Trigger Update Trigger Trigger Trigger Delete
 Week 16Final
 
Textbook / Material
1ÖZSEVEN TURGUT, VERİTABANI YÖNETİM SİSTEMLERİ 1 MURATHAN YAYINLARI
 
Recommended Reading
 
Method of Assessment
Type of assessmentWeek NoDate

Duration (hours)Weight (%)
Mid-term exam 9 1 50
End-of-term exam 16 1 50
 
Student Work Load and its Distribution
Type of workDuration (hours pw)

No of weeks / Number of activity

Hours in total per term
Yüz yüze eğitim 4 16 64
Sınıf dışı çalışma 2 14 28
Laboratuar çalışması 0 0 0
Arasınav için hazırlık 2 8 16
Arasınav 1 1 1
Uygulama 1 14 14
Klinik Uygulama 0 0 0
Ödev 0 0 0
Proje 0 0 0
Kısa sınav 0 0 0
Dönem sonu sınavı için hazırlık 2 8 16
Dönem sonu sınavı 1 1 1
Diğer 1 0 0 0
Diğer 2 0 0 0
Total work load140