FACULTY OF ENGINEERING
Department of Software Engineering
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 |
|
|||||||
Course Language |
English
|
|||||||
Course Type |
Elective
|
|||||||
Course Level |
First Cycle
|
|||||||
Mode of Delivery | - | |||||||
Teaching Methods and Techniques of the Course | - | |||||||
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. |
Learning Outcomes |
The students who succeeded in this course;
|
Course Description | 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. |
|
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 | Slides and lecture notes |
2 | Data modelling with Entity Relationship Model. Data modelling with UML Use Case and Class Diagrams | Slides and lecture notes |
3 | Relational Model and Relational algebra | Slides and lecture notes |
4 | Normalisation | Slides and lecture notes |
5 | Normalisation, Revised data model | Slides and lecture notes |
6 | Structured Query Language(data definition) | Slides and lecture notes |
7 | Structured Query Language(constructing the database) | Slides and lecture notes |
8 | Structured Query Language(stored procedures and triggers) | Slides and lecture notes |
9 | Query optimisation | Slides and lecture notes |
10 | Database processing, data integrity and security | Slides and lecture notes |
11 | Database processing, concurrency and recovery | Slides and lecture notes |
12 | Data farms | Slides and lecture notes |
13 | Cloud computing | Slides and lecture notes |
14 | Big Data I | Slides and lecture notes |
15 | Big Data II | Slides and lecture notes |
16 | Course Review |
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 | ||
Laboratory / Application | ||
Field Work | ||
Quizzes / Studio Critiques |
2
|
30
|
Portfolio | ||
Homework / Assignments | ||
Presentation / Jury | ||
Project | ||
Seminar / Workshop | ||
Oral Exams | ||
Midterm |
1
|
30
|
Final Exam |
1
|
40
|
Total |
Weighting of Semester Activities on the Final Grade |
3
|
60
|
Weighting of End-of-Semester Activities on the Final Grade |
1
|
40
|
Total |
ECTS / WORKLOAD TABLE
Semester Activities | Number | Duration (Hours) | Workload |
---|---|---|---|
Theoretical Course Hours (Including exam week: 16 x total hours) |
16
|
2
|
32
|
Laboratory / Application Hours (Including exam week: '.16.' x total hours) |
16
|
2
|
32
|
Study Hours Out of Class |
16
|
2
|
32
|
Field Work |
0
|
||
Quizzes / Studio Critiques |
2
|
7
|
14
|
Portfolio |
0
|
||
Homework / Assignments |
0
|
||
Presentation / Jury |
0
|
||
Project |
0
|
||
Seminar / Workshop |
0
|
||
Oral Exam |
0
|
||
Midterms |
1
|
15
|
15
|
Final Exam |
1
|
25
|
25
|
Total |
150
|
COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP
#
|
Program Competencies/Outcomes |
* Contribution Level
|
||||
1
|
2
|
3
|
4
|
5
|
||
1 | To have adequate knowledge in Mathematics, Science, Computer Science and Software Engineering; to be able to use theoretical and applied information in these areas on complex engineering problems. |
X | ||||
2 | To be able to identify, define, formulate, and solve complex Software Engineering problems; to be able to select and apply proper analysis and modeling methods for this purpose. |
X | ||||
3 | To be able to design, implement, verify, validate, document, measure and maintain a complex software system, process, or product under realistic constraints and conditions, in such a way as to meet the requirements; ability to apply modern methods for this purpose. |
X | ||||
4 | To be able to devise, select, and use modern techniques and tools needed for analysis and solution of complex problems in software engineering applications; to be able to use information technologies effectively. |
X | ||||
5 | To be able to design and conduct experiments, gather data, analyze and interpret results for investigating complex Software Engineering problems. |
|||||
6 | To be able to work effectively in Software Engineering disciplinary and multi-disciplinary teams; to be able to work individually. |
|||||
7 | To be able to communicate effectively in Turkish, both orally and in writing; to be able to author and comprehend written reports, to be able to prepare design and implementation reports, to be able to present effectively, to be able to give and receive clear and comprehensible instructions. |
|||||
8 | To have knowledge about global and social impact of engineering practices and software applications on health, environment, and safety; to have knowledge about contemporary issues as they pertain to engineering; to be aware of the legal ramifications of Engineering and Software Engineering solutions. |
|||||
9 | To be aware of ethical behavior, professional and ethical responsibility; to have knowledge about standards utilized in engineering applications. |
|||||
10 | To have knowledge about industrial practices such as project management, risk management, and change management; to have awareness of entrepreneurship and innovation; to have knowledge about sustainable development. |
|||||
11 | To be able to collect data in the area of Software Engineering, and to be able to communicate with colleagues in a foreign language. ("European Language Portfolio Global Scale", Level B1) |
|||||
12 | To be able to speak a second foreign language at a medium level of fluency efficiently. |
|||||
13 | To recognize the need for lifelong learning; to be able to access information, to be able to stay current with developments in science and technology; to be able to relate the knowledge accumulated throughout the human history to Software Engineering. |
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest