Information Package

Program of Statistics and Computer Sciences

İST366

DATABASE MANAGEMENT SYSTEMS

Course Code
İST366
Semester
Sixth Term (Spring)
Theory+Practice
2 + 2
ECTS
5
Course TypeCompulsory Course
Course LevelBachelor's Degree
Year of Study3
SemesterSixth Term (Spring)
ECTS5
Name of Lecturer(s) -
Learning Outcomes

At the end of this course, the students;

  1. The students will be able to write SQL scripts for the solutions of real problems in the domain of database management
Mode of DeliveryFace to face
PrerequisitesNo
Recommended Optional Programme ComponentsNone
Course DescriptionDatabase concepts and types of databases, Relational databases, Storing and Retreving data, SQL, Data Manipulation, SQL operators and functions, Oracle SQL*Plus, PL/SQL, Installation and Configuration of a database, Developing Data Models, Designing a Database?s Structure, Normalization, Database Tools
Course Contents
WEEK TOPICS
1st Week Database concepts and types of databases
2nd Week Relational databases
3rd Week Storing and Retreiving data
4th Week SQL
5th Week Data Manipulation
6th Week SQL operators and functions
7th Week Database Tools
8th Week MIDTERM I
9th Week Oracle SQL*Plus
10th Week PL/SQL
11th Week Oracle Installation, Configuration and Building
12th Week Developing Data Models
13th Week Designing a Database's Structure
14th Week Normalization
Recommended or Required Reading1. Timur Karaçay, http://www.baskent.edu.tr/~tkaracay web sitesindeki ders notları. 2. George Koch - Kevin Loney : Oracle The Complete Reference, Osborne McGraw-Hill, NewYork, 1997. 3. Dwight Cheu - Brian Linden: SQL Language Reference, Oracle, Ireland, 1990. 4. Ken Rudin - Tom Portfolio : PL/SQL User's Guide and Reference, Oracle, Ireland, 1990
Planned Learning Activities and Teaching Methods
  • Lecture
  • Questions/Answers
  • Case Study
  • Problem Solving
Assessment Methods and Criteria
Quantity Percentage (%)
Mid-term 1 10
Assignment 5 10
Quiz 5 10
Practice 1 10
Project 1 10
Total(%) 50
Contribution of In-term Studies to Overall Grade(%) 50
Contribution of Final Examination to Overall Grade(%) 50
Total(%) 100
Language of InstructionTurkish
Work Placement(s)No
LO1
K1 X
K2 X
K3
K4
K5
K6 X
K7 X
K8
K9
K10 X
K11
K12