COURSE UNIT TITLE

: DATABASE AND MANAGEMENT SYSTEMS

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/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13PO.14PO.15
LO.1555533333
LO.2555533333
LO.3555533333
LO.4555533333
LO.5555533333
LO.6555533333