SE 306 | Course Introduction and Application Information

Course Name
Database Management Systems
Code
Semester
Theory
(hour/week)
Application/Lab
(hour/week)
Local Credits
ECTS
SE 306
Fall/Spring
2
2
3
5

Prerequisites
  CE 223 To succeed (To get a grade of at least DD)
Course Language
English
Course Type
Elective
Course Level
First Cycle
Course Coordinator
Course Lecturer(s)
Assistant(s) -
Course Objectives To provide a broad base for learning data definition, data modelling database design and implementation by using ORACLE DBMS toolkit software.
Course Description The students who succeeded in this course;
  • To develop an analytical approach to a realworld situation
  • To develop prroblemsolving skills
  • Be able to construct a data model, logical database design, database implementation and processing
  • Be able to design database interfaces
Course Content Learning data modelling techniques with traditional Entity Relationship Model as well as UML’s Use Case and Class diagrams. Data definition and creating database objects by using SQL language. Developing database solutions in response to a set of user requirements by using Oracle DBMS tool. To use ‘stored procedures’ and ‘ triggers’ in SQL programs in a problem solving approach.

 



Course Category

Core Courses
Major Area Courses
X
Supportive Courses
Media and Management Skills Courses
Transferable Skill Courses

 

WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES

Week Subjects Related Preparation
1 Introduction to DBMS systems
2 Data modelling with Entity Relationship Model. Data modelling with UML Use Case and Class Diagrams Preparation of various scenarios to form a basis for the analysis work
3 Relational Model and Relational algebra Examples of relations from realworld situations
4 Normalisation Various examples to be normalised
5 Normalisation, Revised data model
6 Structured Query Language(data definition) SQL examples (with Oracle SQL)
7 Structured Query Language(constructing the database) SQL examples from realworld situations
8 Structured Query Language(stored procedures and triggers) Application based examples
9 Query optimisation With Oracle facilities
10 Database processing, data integrity and security “ “ “
11 Database processing, concurrency and recovery “ “ “
12 Trends, web databases Examples of web databases
13 Trends, data warehousing
14 Review of the semester’s topics
15 Presentation of the students’ projects
16 Review of the Semester  

 

Course Notes/Textbooks “Database Systems”, T Connoly, C. Begg, Addiison Wesley publishers
Suggested Readings/Materials “An Introduction to Database Systems”, C J Date, Addison Wesley“Database Management Systems”, R Ramakrishnan, J Gehrke, McGrawHill“Relational Database Principles”, C Ritchie, Letts Educational“Fundamentals of SQL programming”, R MataToledo, P K Cushman, Schaum’s Outlines“Oracle Programming: A Primer”, R Sunderraman, Addison Wesley

 

EVALUATION SYSTEM

Semester Activities Number Weigthing
Participation
15
5
Laboratory / Application
Field Work
Quizzes / Studio Critiques
1
25
Homework / Assignments
Presentation / Jury
Project
Seminar / Workshop
Portfolios
Midterms / Oral Exams
1
30
Final / Oral Exam
1
40
Total

Weighting of Semester Activities on the Final Grade
60
Weighting of End-of-Semester Activities on the Final Grade
40
Total

ECTS / WORKLOAD TABLE

Semester Activities Number Duration (Hours) Workload
Course Hours
Including exam week: 16 x total hours
16
2
32
Laboratory / Application Hours
Including exam week: 16 x total hours
16
Study Hours Out of Class
15
2
Field Work
Quizzes / Studio Critiques
1
Homework / Assignments
Presentation / Jury
Project
43
Seminar / Workshop
Portfolios
Midterms / Oral Exams
1
5
Final / Oral Exam
1
10
    Total
77

 

COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP

#
Program Competencies/Outcomes
* Contribution Level
1
2
3
4
5
1 Adequate knowledge in Mathematics, Science and Software Engineering; ability to use theoretical and applied information in these areas to model and solve Software Engineering problems X
2 Ability to identify, define, formulate, and solve complex Software Engineering problems; ability to select and apply proper analysis and modeling methods for this purpose X
3 Ability to design, implement, verify, validate, measure and maintain a complex software system, process or product under realistic constraints and conditions, in such a way as to meet the desired result; ability to apply modern methods for this purpose X
4 Ability to devise, select, and use modern techniques and tools needed for Software Engineering practice X
5 Ability to design and conduct experiments, gather data, analyze and interpret results for investigating Software Engineering problems
6 Ability to work efficiently in Software Engineering disciplinary and multi-disciplinary teams; ability to work individually X
7 Ability to communicate effectively in Turkish, both orally and in writing; knowledge of a minimum of two foreign languages
8 Recognition of the need for lifelong learning; ability to access information, to follow developments in science and technology, and to continue to educate him/herself
9 Awareness of professional and ethical responsibility
10 Information about business life practices such as project management, risk management, and change management; awareness of entrepreneurship, innovation, and sustainable development
11 Knowledge about contemporary issues and the global and societal effects of engineering practices on health, environment, and safety; awareness of the legal consequences of Software Engineering solutions

*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest