|
|
| TBIL1002 | Database I | 3+1+0 | ECTS:5 | | Year / Semester | Spring Semester | | Level of Course | Short Cycle | | Status | Compulsory | | Department | DEPARTMENT of COMPUTER TECHNOLOGIES | | Prerequisites and co-requisites | None | | Mode of Delivery | | | Contact Hours | 14 weeks - 3 hours of lectures and 1 hour of practicals per week | | Lecturer | Öğretim Görevlisi Nurşah DİNCER | | Co-Lecturer | | | Language of instruction | Turkish | | 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 Outcomes | CTPO | TOA | | 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,8 | 1 | | LO - 2 : | 1. Database tools to make the installation of
2. Create a table and determine the characteristics of | 1,2,3,4,5,6,7,8 | 1 | | LO - 3 : | 1. Query to create and use a variety of
2. Prepare related statements and query
3. Using DML queries | 1,2,3,4,5,6,7,8 | 1 | | 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 queries | 1,2,3,4,5,6,7,8 | 1 | | 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 | | |
| 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 | | Week | Subject | Related Notes / Files | | Week 1 | DATABASE NEEDS ANALYSIS
Database definition. Restrictions Key features of relational database tables in the database tables data constraints constraints | | | Week 2 | Normalization
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 3 | Normalization
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 4 | Normalization
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 5 | STATEMENTS 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 6 | STATEMENTS 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 7 | STATEMENTS 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 8 | Create 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 9 | Mid Term | | | Week 10 | RELATED 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 11 | USING 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 12 | USING 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 13 | WRITING user queries
User create (Create User) with the ANSI SQL statement with T-SQL statement using PL-SQL statement Subroutine | | | Week 14 | VIEW 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 15 | TRIGGER the purposes and types of write queries using Insert Trigger Update Trigger Trigger Trigger Delete | | | Week 16 | Final | | | |
| 1 | ÖZSEVEN TURGUT, VERİTABANI YÖNETİM SİSTEMLERİ 1 MURATHAN YAYINLARI | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 9 | | 1 | 50 | | End-of-term exam | 16 | | 1 | 50 | | |
| Student Work Load and its Distribution | | Type of work | Duration (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 load | | | 140 |
|