DEGREE PROGRAMS  Associate's Degree (Short Cycle)  Bachelor’s Degree (First Cycle)  Master’s Degree (Second Cycle)

Course Description Course Name : DATABASE MANAGEMENT SYSTEMS Course Code : BTE314 Course Type : Compulsory Level of Course : First Cycle Year of Study : 3 Course Semester : Spring (16 Weeks) ECTS : 5 Name of Lecturer(s) : Assoc.Prof.Dr. OZAN ŞENKAL Learning Outcomes of the Course : Describes the concepts about database Explains the database functions Designs a database to use in a program Classifies database to get optimization methods Uses SQL Server, MYSQL, Access programs Teaches the usage of the programs about managing database Mode of Delivery : Face-to-Face Prerequisites and Co-Prerequisites : None Recommended Optional Programme Components : None Aim(s) of Course : To bring in knowledge and skill about teaching general structure of database and database management systems over Sql Server Program Course Contents : Basic database concepts, data and data models, relational database design, SQL structured query language, basic SQL commands, SQL functions, grouping in SQL, assembling in SQL, administrative functions of SQL, using multiple tables with SQL, SQL programming and function, transaction and error states in SQL programming, DBMS setup and administrative operations, SQL query over DBMS. Language of Instruction : Turkish Work Place : Laboratory   Course Outline /Schedule (Weekly) Planned Learning Activities Week Subject Student's Preliminary Work Learning Activities and Teaching Methods 1 Database concepts, data and data types Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 2 Relational database design – Access application Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 3 Sql query language Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 4 Functions used in Sql query language Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 5 General structure of Sql Server program Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 6 Sql Server Menus Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 7 Tables Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 8 Mid-term Exams Preparing for the exam and rewieving of the topics Testing, Assignment, Project / Design 9 Stored procedures Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 10 Stored procedures Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 11 Views Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 12 Triggers Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 13 Creating a sample database Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 14 Database optimization Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 15 Database optimization methods Related subjects in the course text book Lecture, Question - Answer, Discussion, Drill and Practice, Demonstration, Problem Solving 16/17 Final Assessments Preparing for the exam and rewieving of the topics Testing, Assignment, Project / Design   Required Course Resources Resource Type Resource Name Recommended Course Material(s)   Required Course Material(s)   Assessment Methods and Assessment Criteria Semester/Year Assessments Number Contribution Percentage     Mid-term Exams (Written, Oral, etc.) 1 80     Homeworks/Projects/Others 2 20 Total 100 Rate of Semester/Year Assessments to Success 40   Final Assessments 100 Rate of Final Assessments to Success 60 Total 100   Contribution of the Course to Key Learning Outcomes # Key Learning Outcome Contribution* 1 Utilize concepts and applications of scientific research and basic statistics, which are the basis of scientific thinking, for the conditions in the scope of the field and related fields. 3 2 Explain sub-fields of instructional technologies and integral structure of its process and also its relation to the other fields. 4 3 Put forward the complex structure of the problems related to learning and teaching for the given situations based on the knowledge of instructional technologies and related fields. 3 4 Develop a plan, apply the plan and assess the results based on scientific view for the solution of the problems presented in the scope of the field or related fields. 4 5 Put forward new products or processes on the basis of components of instructional technologies, computer science, for the related situations. 3 6 Develop a personal proposal, a product or a group of processes for the solution of a problem related to the field as an indicator of the skills of working independently and taking responsibility. 3 7 Take responsibility of an individual or group projects and accomplishing his/her undertaken missions. 5 8 Follow current problems and applications and determining information and skills to undertake learning missions for the following stage. 4 9 Explain the integral structure of instructional technologies and information technologies or computer science applications. 4 10 Explain concepts that constitutes the basis for scientific thinking in the scope of the field and the related fields. 4 11 Apply the processes of analysis, design, development, and evaluation on the basis of knowledge of instructional technologies. 4 12 Utilize information technologies and computer science applications in order to create an effective and productive learning environment. 4 13 Apply the solution for the problem on the basis of scientific and ethical values when she/he confronts a learning problem. 3 14 Build a healthy communication with students, teachers, school administration, and the individuals in the study group. 4 15 Comprehend a foreign language in order to follow the international resources that can be utilized for the solution of problems related to the field. 3 16 Take responsibilities for the distribution and dissemination of the developments in the field on local or national range. 4 17 Act on the basis of scientific and ethical values in her/his works and also support preservation and learning of these values. 5 18 Develop and evaluate strategic views on topic related to the future of the field. 3 19 Transfer related progresses in other related fields to the field of instructional technologies. 3 20 Create and maintain a cooperative and productive working environment by developing an insight related to the behaviors of the shareholders. 4 * Contribution levels are between 0 (not) and 5 (maximum).   Student Workload - ECTS Works Number Time (Hour) Total Workload (Hour) Course Related Works     Class Time (Exam weeks are excluded) 14 4 56     Out of Class Study (Preliminary Work, Practice) 14 4 56 Assesment Related Works     Homeworks, Projects, Others 2 4 8     Mid-term Exams (Written, Oral, etc.) 1 1 1     Final Exam 1 1 1 Total Workload: 122 Total Workload / 25 (h): 4.88 ECTS Credit: 5