• HOME
• ABOUT US
  • Name Address
  • General Description
  • Governance
  • Academic Calendar
  • Degree Programmes
  • List of Programmes in English
  • General Admission and Registration Procedures
  • Credit Mobility and Recognition of Prior Learning
  • ECTS Credit Allocation
  • Academic Guidance
  • Contacts
• Degree Programmes
  • Third Cycle Programmes (Doctorate Degree)
  • Second Cycle Programmes (Master's Degree)
  • First Cycle Programmes (Bachelor's Degree)
  • Short Cycle Programmes (Associate's Degree)
• GENERAL INFORMATION FOR STUDENTS
  • Cost of Living
  • Accommodation
  • Meals
  • Medical Facilities
  • Facilities for Disabled Students
  • Insurance
  • Financial Supports
  • Student Affairs Office
  • Practical Information for International Students
  • Language Courses
  • Work Placement Possibilities
  • Sports, Social and Cultural Facilities
  • Student Associations and Clubs
  • About İzmir - Turkey
• INTERNATIONAL RELATIONS
  • International Relations Office
  • Registration Procedures
  • Agreements
  • Coordinators
  • Documents
  • List of Programmes in English
  • ECTS / DS Labels

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS BIL 2004 DATABASE AND MANAGEMENT SYSTEMS COMPULSORY 3 1 0 4

Offered By

COMPUTER TECHNOLOGY

Level of Course Unit

Short Cycle Programmes (Associate's Degree)

Course Coordinator

DOCTOR ALP EREN YÜCE

Offered to

COMPUTER TECHNOLOGY

Course Objective

With this course, students, data base designing, creating, querying a database using the administrative functions of the gain qualifications.

Learning Outcomes of the Course Unit

1   Will be able to define the main concepts of data base 2   Can design database 3   Can creating the database 4   To be able to use database management systems. 5   Can query the database 6   Can use the database administrative functions

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description 1 Database Needs Analysis Normalization 2 Normalization 3 Normalization 4 Installing the Database Tools Creating Tables and Determine the Properties 5 Creating Tables and Determine the Properties 6 Create and Use The Kinds of Queries 7 Variety of functions in queiries 8 Create and Use The Kinds of Queries 9 Prepare Tables Associated With The Query 10 Using DML Queries 11 User Queries Writing 12 Write to the View Queries 13 Write to The View Queries Writing Trigger Queries 14 Sub-Programme Writing Queries Transaction Processing Make Writing Queries Index

Recomended or Required Reading

Lecture notes

Planned Learning Activities and Teaching Methods

1-Lecture 2-DVD, video vb. 3-Practice

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA 1 MT MIDTERM 2 FINS FINAL EXAM 3 FCGR FINAL COURSE GRADE (RESIT) MT*0.40+FINS*0.60 4 RST RESIT 5 FCGR FINAL COURSE GRADE (RESIT) MT*0.40+RST*0.60 *** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

Further Notes About Assessment Methods

None

Assessment Criteria

The understanding degree of students to 6 learning outputs is evaluated by project,presentation and final exam.

Language of Instruction

Turkish

Course Policies and Rules

1.70% of participation in the courses is mandatory 2.All kinds of plagiarism (cheating) initiative, and the actual results in disciplinary action

Contact Details for the Lecturer(s)

Lec. Alp Eren Yüce alp.yuce@deu.edu.tr Tel: +90 0232 632 12 48 / 121

Office Hours

Tuesday 11.00-12.00

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours) Lectures 14 3 42 Tutorials 14 1 14 Preparations before/after weekly lectures 14 2 28 Preparation for midterm exam 1 5 5 Preparation for final exam 1 7 7 Midterm 1 1 1 Quiz etc. 1 1 1 Final 1 2 2 TOTAL WORKLOAD (hours) 100

Contribution of Learning Outcomes to Programme Outcomes

PO/LO PO.1 PO.2 PO.3 PO.4 PO.5 PO.6 PO.7 PO.8 PO.9 PO.10 PO.11 PO.12 PO.13 PO.14 PO.15 LO.1 5 5 5 5 3 3 3 3 3 LO.2 5 5 5 5 3 3 3 3 3 LO.3 5 5 5 5 3 3 3 3 3 LO.4 5 5 5 5 3 3 3 3 3 LO.5 5 5 5 5 3 3 3 3 3 LO.6 5 5 5 5 3 3 3 3 3