| Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | | BLY2032017851 | DATABASE MANAGEMENT SYSTEMS | Compulsory | 2 | 3 | 5 |
|
| Level of Course Unit |
| Short Cycle |
| Objectives of the Course |
| • to teach data basedesigning, creating, querying a databaseusingtheadministrativefunctions of thegainqualifications. |
| Name of Lecturer(s) |
| Öğr.Gör. Tevfik Fikret KOLOĞLU |
| 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 | Identifying Database Management Systems
| | | | 2 | Creating a Database Diagram
| | | | 3 | Introduction to Microsoft Access
| | | | 4 | Installing Database Tools
Creating and Specifying Tables | | | | 5 | Creating and Specifying Tables | | | | 6 | Creating and Specifying Tables | | | | 7 | Creating and Using Query Types
| | | | 8 | Midterm Exam | | | | 9 | Creating and Using Query Types
| | | | 10 | Preparing a Query with Related Tables
| | | | 11 | Microsoft Access Ready Form Applications
| | | | 12 | Microsoft Access Reporting Applications
| | | | 13 | Produce Package Program Using Microsoft Access Program
| | | | 14 | Produce Package Program Using Microsoft Access Program
| | | | 15 | General lesson repeat | | | | 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 |
| Quiz | 10 | 1 | 10 |
| Attending Lectures | 14 | 4 | 56 |
| Laboratory | 10 | 2 | 20 |
| Project Design/Management | 2 | 10 | 20 |
| Self Study | 14 | 1 | 14 |
| Individual Study for Homework Problems | 10 | 1 | 10 |
|
| Contribution of Learning Outcomes to Programme Outcomes |
| LO1 | 2 | | | | | | 2 | 2 | 1 | 2 | | | 5 | | | | | | | | 1 | 1 | | | | | 2 | | | | LO2 | 2 | | | | | | 2 | 2 | 1 | 2 | | | 5 | | | | | | | | 1 | 1 | | | | | 2 | | | | LO3 | 2 | | | | | | 2 | 2 | 1 | 2 | | | 5 | | | | | | | | 1 | 1 | | | | | 2 | | | | LO4 | 2 | | | | | | 2 | 2 | 1 | 2 | | | 5 | | | | | | | | 1 | 1 | | | | | 2 | | |
|
| * 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
|