Back

Database Management Systems-II

 

PÎRÎ REİS UNIVERSITY

MARITIME VOCATIONAL HIGHER SCHOOL

Course Name : Database Management Systems II

Degree: Associate

 

Code

 

 

Year/Semester

Local Credits

ECTS

Credits

Course Implementation, Hours/Week

Course

Tutorial

Laboratory

BIP1003

1/1 (Güz)

3

5

2

 

2

Department

 

Instructors

 

Assist. Prof. Dr. Erkan KIYAK

Contact Information

 

0216. 5810050-1796

Office Hours

 

Web page

www.pirireis.edu.tr

Course Type

 Compulsory

Course Language

Turkish

Course Prerequisites

  

Course Category by Content, %

Basic Sciences

Engineering Science

Engineering Design

Humanities

20

40

40

0

Course Description

Database Concept
Creating a Database
Querying Single Table
Arithmetic expressions and functions in SQL
Querying Multiple Tables
Creating View

Data Manupulations in Tables
Creating and Using Index
Participation of SQL in Other Computer Languages and Software

 

Course Objectives

 

1. To provide the ability to design and perform database
2. To learn SQL query language
3. Developing applications that include database system using PostGreSQL software

 

Course Learning Outcomes

 

Upon successful completion of this course, students will be able to:
I. Creating a New Database,
II. To be able to perform Create-Read-Update-Delete (CRUD) operations on database,
III. To learn the performance-enhancing elements of the database
IV. Develop an application using SQL

Instructional Methods and Techniques

Power Point, Computer Applications 

Tutorial Place

Classroom, Computer Laboratory

Co-term Condition

Database Management Systems I

Textbook

SQL Veritabanı Sorgulama Dili, Prof.Dr.Mithat UYSAL, Nirvana Yayınları

 

Other References

www.w3schools.com

Homework & Projects

Homework will be given related to SQL

Laboratory Work

2 hours of laboratory work each week

Computer Use

Computer using will be needed.

Other Activities

None

                   

 

Assessment Criteria

Activities

Quantity

Effects on Grading, %

Attendance

14

14

Midterm

1

30

Quiz

 

 

Homework

1

11

Term Paper/Project

 

 

Laboratory Work

 

 

Practices

 

 

Tutorial

 

 

Seminar

 

 

Presentation

 

 

Field Study

 

 

Final Exam

1

45

TOTAL

 

%100

Effects of Midterm on Grading, %

 

%55

Effects of Final on Grading, %

 

%45

TOTAL

 

%100

 

 

ECTS/

WORKLOAD TABLE

Activities

Count

Hours

Total

Workload

Lecture

14

2

28

Midterm

1

20

20

Quiz

 

 

 

Homework

1

20

20

Term Paper/Project

 

 

 

Laboratory Work

14

2

28

Practices

 

      

 

Tutorial

 

 

 

Seminar

 

 

 

Presentation

 

 

 

Field Study

 

 

 

Final Exam

1

25

25

Total Workload

 

 

121

Total Workload/25

 

 

4,84

Course ECTS Credits

 

 

5

 

 

 

 

 

 

 

 

 

 

 

 

 

Week

Topics

Course Outcomes

1

Veritabanı Kavramı

I

2

Creating a Database

I

3

Queries in a Single Table

II

4

Queries in a Single Table

II

5

Arithmetic Expressions and Functions in SQL

II

6

Queries in a Multiple Table

II

7

Queries in a Multiple Table

II

8

Midterm

1-7

9

SQL UPDATE code

II

10

SQL DELETE Code

II

11

Group By / Order By Concepts

II

12

Creating a VIEW

III

13

Creating and Using an INDEX

III

14

Participation of SQL in Other Computer Languages and Software

IV

15

Final Exam

1-14

 

 

 

Relationship between the Programme Outcomes and Level of Contribution

 

 

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

X

 

 

i

An ability to apply their knowledge to maritime discipline

 

X

 

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

 

X

 

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

 

X

 

p

An understanding of professional and ethical responsibilities

X

 

 

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

 

X

 

 

         1: Small, 2: Partial, 3: Full

 

Programme Outcomes & Course Outcomes Connectivity Matrix

Course Outcomes

I

II

III

IV

Programme Outcomes

 

a

 

 

 

 

b

 

 

 

 

c

 

 

 

 

d

 

 

 

 

e

 

 

 

 

f

 

 

 

 

g

 

 

 

 

h

 

 

 

 

i

 

 

 

 

j

 

 

 

 

k

 

 

 

 

l

 

 

 

 

m

 

 

 

 

n

 

 

 

 

o

 

 

 

 

p

 

 

 

 

r

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Prepared by

 

Assist. Prof. Dr. Erkan KIYAK

Date

 

20.09.2018

Signature