|
Description of Individual Course Units| Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | | İBİLP10820109115 | DATABASE I | Compulsory | 1 | 2 | 3 |
| | Level of Course Unit | | Short Cycle | | Objectives of the Course | | • to teach data basedesigning, creating, querying a databaseusingtheadministrativefunctions of thegainqualifications. | | Name of Lecturer(s) | | | Learning Outcomes | | 1 | Make the analysis of databases | | 2 | Install database tools | | 3 | Create and use a variety of queries | | 4 | Write appearance queries |
| | Mode of Delivery | | Formal Education | | Prerequisites and co-requisities | | | Recommended Optional Programme Components | | Week 1 DATABASE NEEDS ANALYSIS Description of thedatabase. RestrictionsKeyfeatures of relationaldatabasetables in thedatabasetablesdataconstraintsconstraints
Week2 Absolutenormalization of dataredundancyunnecessary data redundancyagainthefirst normal form (1nF) 1nF 1nFproperties of problems (add, delete, update, during) thesecond normal form (2NF) 2NF properties. 2NF problems (adding, deleting, during) thethird normal form (3NF) 3NF 3NFproperties of problems (duringinsertion) Boyce-Codd normal form
Week 3 Absolutenormalization of dataredundancyunnecessary data redundancyagainthefirst normal form (1nF) 1nF 1nFproperties of problems (add, delete, update, during) thesecond normal form (2NF) 2NF properties. 2NF problems (adding, deleting, during) thethird normal form (3NF) 3NF 3NFproperties of problems (duringinsertion) Boyce-Codd normal form
Week 4 Absolutenormalization of dataredundancyunnecessary data redundancyagainthefirst normal form (1nF) 1nF 1nFproperties of problems (add, delete, update, during) thesecond normal form (2NF) 2NF properties. 2NF problems (adding, deleting, during) thethird normal form (3NF) 3NF 3NFproperties of problems (duringinsertion) Boyce-Codd normal form
Week 5 SETUP MEANS TO DATABASE databaseserverinstallation of Windows-basedoperatingsystem, opensource-basedoperatingsystemkurulumuYönetimtools. Kurulumu2 Windows-basedoperatingsystem. Open-sourcecode-based Operating System Installation
Week 6 Creatinganddetermininigthecharacteristics of tables
Week 7 USING TYPES AND SQL languagetobuildquerieswiththedatabasestructuretocreate a query. Create a tablewith a querytodeletethetable. ColumntoaddcolumnslimitingTableupdatethe SELECT statementsyntax. Sortbylimitingtheoperations of rows in SQL functions
Week 8 MidtermExam
Week 9 RELATED TABLES PreparingStatementsmergingmultiplequerieswiththeuse of tables is equaltotheCartesianproductcombiningunequalsubqueryregulationrulesdefiningquerytomergesub-queries, sub-sub-queries, multi-columnsingle-columnsubqueries
Week 10 RELATED TABLES PreparingStatementsmergingmultiplequerieswiththeuse of tables is equaltotheCartesianproductcombiningunequalsubqueryregulationrulesdefiningquerytomergesub-queries, sub-sub-queries, multi-columnsingle-columnsubqueries
Week 11 USING DML queries, addingrows in a table of functionstousetheprocess of addingvalue is NULL, thestructure of the INSERT statementtocopy a row in a tablewithothertabledatastructureupdate UPDATE statementtoupdatethetableswiththe data readfromonetabletoanotherstructure of the DELETE statementtodelete data usingthe data readfromanothertable, delete
Week 12 USING DML queries, addingrows in a table of functionstousetheprocess of addingvalue is NULL, thestructure of the INSERT statementtocopy a row in a tablewithothertabledatastructureupdate UPDATE statementtoupdatethetableswiththe data readfromonetabletoanotherstructure of the DELETE statementtodelete data usingthe data readfromanothertable, delete
Week 13 USER createuserwritequeries (Create User) withthe ANSI SQL statementwith T-SQL statementusing PL-SQL statementSubroutine
Week 14 VIEW writequeriesusingtheViewtables, combiningqueries, simplifyingsecuritypurposes. With a singlequeryto do jobsthat can not be
Week 15 TRIGGER thepurposesandtypes of writequeriesusingInsertTrigger Update TriggerTriggerTriggerDelete
Week 16 Final Exam
| | Course Contents | | • Database Needs Analysis Normalization
• Normalization
• Normalization
• Database Tools Setupto do is createthetablesandIdentifyFeatures
• CreatingTablesandIdentifyFeatures
• Creatingtablesanddeterminethecharacteristics of
• Createanduse Query Varieties
• Createanduse Query VarietiesAssociatedwiththe Query CreatingTables
• Prepare a querywithrelatedtables
• Using DML queries
• Using DML queries, queriestheusertowrite
• ViewQueriesWritingQueriesWritingTrigger
• TriggerQueriesWritingQueriesWritingSub-Programme
• TransactionProcessingMaking, WritingQueries Index
| | Weekly Detailed Course Contents | |
| 1 | DATABASE NEEDS ANALYSIS Description of the database. Restrictions Key features of relational database tables in the database tables data constraints constraints | | | | 2 | Absolute normalization of data redundancy unnecessary data redundancy again the first normal form (1nF) 1nF 1nF properties of 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 | | | | 3 | Absolute normalization of data redundancy unnecessary data redundancy again the first normal form (1nF) 1nF 1nF properties of 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 | | | | 4 | Absolute normalization of data redundancy unnecessary data redundancy again the first normal form (1nF) 1nF 1nF properties of 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 | | | | 5 | SETUP MEANS TO DATABASE database server installation of Windows-based operating system, open source-based operating system kurulumuYönetim tools. Kurulumu2 Windows-based operating system. Open-source code-based Operating System Installation | | | | 6 | Creating and determininig the characteristics of tables | | | | 7 | USING TYPES AND SQL language to build queries with the database structure to create a query. 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 | | | | 8 | Midterm Exam | | | | 9 | RELATED TABLES Preparing Statements merging multiple queries with the use of tables is equal to the Cartesian product combining unequal subquery regulation rules defining query to merge sub-queries, sub-sub-queries, multi-column single-column subqueries | | | | 10 | RELATED TABLES Preparing Statements merging multiple queries with the use of tables is equal to the Cartesian product combining unequal subquery regulation rules defining query to merge sub-queries, sub-sub-queries, multi-column single-column subqueries | | | | 11 | USING DML queries, adding rows in a table of functions to use the process of adding value is NULL, the structure of the INSERT statement to copy a row in a table with other table data structure update UPDATE statement to update the tables with the data read from one table to another structure of the DELETE statement to delete data using the data read from another table, delete | | | | 12 | USING DML queries, adding rows in a table of functions to use the process of adding value is NULL, the structure of the INSERT statement to copy a row in a table with other table data structure update UPDATE statement to update the tables with the data read from one table to another structure of the DELETE statement to delete data using the data read from another table, delete | | | | 13 | USER create user write queries (Create User) with the ANSI SQL statement with T-SQL statement using PL-SQL statement Subroutine | | | | 14 | VIEW write queries using the View tables, combining queries, simplifying security purposes. With a single query to do jobs that can not be | | | | 15 | TRIGGER the purposes and types of write queries using Insert Trigger Update Trigger Trigger Trigger Delete | | | | 16 | Final Exam | | |
| | Recommended or Required Reading | | Yaşar Gözüdeli. SQL Server 2005 ve Veri Tabanı Programlama | | Planned Learning Activities and Teaching Methods | | | Assessment Methods and Criteria | |
| SUM | 0 | |
| SUM | 0 | | Yarıyıl (Yıl) İçi Etkinlikleri | 40 | | Yarıyıl (Yıl) Sonu Etkinlikleri | 60 | | SUM | 100 |
| | Language of Instruction | | Turkish | | Work Placement(s) | |
| | Workload Calculation | |
| Midterm Examination | 1 | 3 | 3 | | Final Examination | 1 | 3 | 3 | | Attending Lectures | 14 | 4 | 56 | | Self Study | 14 | 1 | 14 | | Individual Study for Mid term Examination | 10 | 1 | 10 | | Individual Study for Final Examination | 10 | 1 | 10 | |
| Contribution of Learning Outcomes to Programme Outcomes | | LO1 | 4 | 4 | 5 | 5 | 5 | 4 | 3 | 3 | 4 | 5 | 3 | 3 | 3 | 3 | | LO2 | 4 | 5 | 5 | 5 | 5 | 4 | 3 | 5 | 4 | 5 | 5 | 4 | 4 | 4 | | LO3 | 4 | 5 | 3 | 3 | 4 | 4 | 4 | 5 | 4 | 5 | 3 | 3 | 3 | 4 | | LO4 | 4 | 4 | 5 | 4 | 5 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 5 | 4 |
| | * Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
|
|
|
|
Ordu University Rectorate Building ,Cumhuriyet Campus , Center / ORDU / TURKEY • Tel: +90 452 226 52 00
|
|
|