Course Name : Database Management Systems -I

Degree: Associate's Degree

Code

Year/Semester

Local Credits

ECTS Credits

Course Implementation, Hours/Week

Course

Tutorial

Laboratory

BİP 1008

1/2 (Spring)

3

4

2

0

2

Department / Programme

Computer Programming

Instructors

Dr. Füsun Er

Contact Information

fer@pirireis.edu.tr

Office Hours

Web page

www.pirireis.edu.tr

Course Type

 Compulsory

Language

Turkish

Course Prerequisites

Course Category by Content, %

Basic Sciences

Engineering Science

Engineering Design

Humanities

0

100

0

0

Course Description

Introduction to database, Fundamentals of database systems, Data models, Entity-Relationship Model, Hierarchical model, Network database model, Relational model, Object Oriented model, SQL (Structured Query Language), Spatial Databases, Web based Databases

Course Objectives

1. To teach concepts and methods of databases in engineering.

2. To be able to database design and implementation.

3. To teach how databases can be used for problem solving and analyzing.

4. Develop applications involving database systems in particular using SQL and Access.

Course Learning Outcomes

Students who successfully pass this course will be able to;

I. Explain the fundamentals of databases.

II. Select, design and employ appropriate data model  for a given subject.

III. Use database system approach to solve engineering problems.

IV. Interpret topological relations and spatial queries as part of spatial databases.

V. Describe web-based database concepts and their application areas.

VI.Formulize and conclude different queries by using the related database management system.

Instructional Methods and Techniques

Power point presentation, Computational Application

Tutorial Place

Class, Computer Laboratory

Co-term Condition

Textbook

Ünal Yarımağan, Veri Tabanı Sistemleri, Sistem Ofset, 2000.

Other References

Martin, E., Modell, Data analysis, data modeling, and classification  New York : McGraw-Hill, c1992.

Yalçın, Özkan, Gülser, Dondurmacı Acar. Microsoft Access 2000, Türkçe Sürüm, Temel Öğrenim Kılavuzu, Alfa Yayınları, 2000.

Tahsin Yomralıoğlu, Coğrafi Bilgi Sistemleri Temel Kavramlar ve Uygulamalar, Seçil Ofset, 2000.

Oya Kalıpsız, Bilgisayar Veri Tabanı Sistemleri, İstanbul Üniversitesi Basımevi

Homework & Projects

Database System Project will be given to the students

Laboratory Work

2 hours of laboratory work each week

Computer Use

Using relational database program, homework presentation

Other Activities

None

Assessment Criteria

Activities

Quantity

Effects on Grading, %

Attendance

Midterm

1

30

Quiz

Homework

Term Paper/Project

1

10

Laboratory Work

2

20

Practices

Tutorial

Seminar

Presentation

Field Study                                             

Final Exam

1

40

TOTAL

100

Effects of Midterm on Grading, %

60

Effects of Final on Grading, %

40

TOTAL

100

ECTS/

WORKLOAD TABLE

Activities

Count

Hours

Total

Workload

Lecture

12

2

28

Midterm

1

12

12

Quiz

Homework

Term Paper/Project

1

12

12

Laboratory Work

2

4

Practices

12

2

28

Tutorial

Seminar

Presentation

Field Study

Final Exam

1

12

12

Total Workload

92

Total Workload/25

92/25

Course ECTS Credits

4

Week

Topics

Course Outcomes

1

Lecture: Introduction to Database Systems, Basic Concepts in Databases

I

2

Lecture: Entity-Relationship Model

I, II

3

Lecture: Data Models, Hierarchical model, Network database model, object-oriented model

I, II

4

Lecture: Relational Databases

I, II, III, IV, V

5

Lecture: Relational Algebra

I, II

6

Lecture: Relational Functions

I, II, III, IV, V

7

LabWork: Lab Study

I, II

8

Exam: Midterm Examination

1-to-VII

9

Lecture: SQL (Structured Query Language)

I, II, III, IV

10

Lecture: Object Oriented Databases

I, II, III, IV, V

11

Lecture: Spatial Databases

I, II, III, IV, V

12

Lecture: Web Based Databases

I, II, III, IV, V

13

LabWork: Lab Study

I, II, III, IV, V

14

Project: Term Project Presentations

I, II, III, IV, V

Exam: Final Examination

1-14

Program Outcomes

Level of Contribution

1

2

3

a

An ability to apply basic knowledge of mathematics, science, and engineering

X

b

To learn basic computer knowledge, to make use of software and hardware components needed in the professional work life

X

c

To think algorithmically and use this ability in conducting software planning

X

d

To define professional work life problems and to be able to solve them

X

e

To code by using uptodate software programming languages

X

f

To design and code software using Internet technologies, to code client/server based programs

X

g

To learn designing a database and to code programs that have connection with a database

X

h

To gain basic electrics and electronics knowledge related with the computer hardware

i

An ability to apply their knowledge to maritime discipline

j

To get responsibility in analyzing, designing, planning and coding phases of a software as well as writing reports in each of these phases. To have non-administrative responsibilities in project production

k

To have a general knowledge about computer networks

X

l

To have basic knowledge about operating systems

X

m

To attain an ability to communicate written and orally effectively

X

n

To take responsibility and initiative, to make decisions and be creative

X

o

A recognition of the need for, and an ability to engage in life-long learning

p

An understanding of professional and ethical responsibilities

r

To be able to read and understand technical documents written in both Turkish and English, to be able to communicate written and orally effectively

Dersin Öğrenme Çıktıları

I

II

III

IV

V

VI

Program Öğrenme Çıktıları

a

b

c

d

e

f

g

h

i

j

k

l

m

p

r

Düzenleyen

Yrd. Doç. Dr. Kadri ÖZDEMİR

Ögr. Grv. Dr. Füsun Er

Tarih

26.09.2017

22.01.2018

İmza