- University
- Academic
- Schools/Vocational Schools
- Vocational School of Justice
- Vocational School
- Vocational School
- Department of Banking and Insurance (Turkish)
- Department of Computer Programming (Turkish)
- Department of Foreign Trade (Turkish)
- Department of Graphic Design (Turkish)
- Department of Interior Design (Turkish)
- Department of Construction Technology (Turkish)
- Department of Occupational Health and Safety (Turkish)
- Department of Media and Communication (Turkish)
- Department of Architectural Restoration (Turkish)
- Department of Radio and Tv Programming (Turkish)
- Department of Civil Aviation Cabin Services (Turkish)
- Department of Civil Aviation Transportation Management (Turkish)
- Department of Tourism and Hotel Management (Turkish)
- Department of Applied English Translation
- Vocational School Of Health Services
- Vocational School Of Health Services
- Department of Child Development (Turkish)
- Department of Physiotherapy (Turkish)
- Department of Paramedic (Turkish)
- Department of Opticianry (Turkish)
- Department of Medical Documentation and Secreteriat (Turkish)
- Department of Medical Imaging Techniques (Turkish)
- Department of Medical Laboratory Techniques (Turkish)
- Department of Elderly Care (Turkish)
- School of Applied Management Sciences
- School of Foreign Languages
- Faculties
- Faculty of Arts and Sciences
- Faculty of Fine Arts and Design
- Faculty of Law
- Faculty of Communication
- Faculty of Business
- Faculty of Engineering
- Faculty of Engineering
- Department of Computer Engineering
- Department of Biomedical Engineering
- Department of Electrical and Electronics Engineering
- Department of Industrial Engineering
- Department of Food Engineering
- Department of Genetics and Bioengineering
- Department of Aerospace Engineering
- Department of Civil Engineering
- Department of Mechanical Engineering
- Department of Mechatronics Engineering
- Department of Software Engineering
- Faculty of Health Sciences
- Medicine
- Graduate School
- Common Courses
- Schools/Vocational Schools
- Research
- Research Centers
- Library
- Smart Campus
- Technology Transfer Office
- İzmir Sciencepark
- Continuous Education Center (EKOSEM)
- Children's University
- Ethics Committee
- Teaching and Learning Center (EKOEĞİTİM)
- Psychology Application and Research Center
- Researcher Training Coordinatorship
- Research Collaborations And Innovation Coordinatorship
- Campus
- INTERNATIONAL
- Contact
Department of Computer 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
|
2
|
2
|
3
|
5
|
| Prerequisites | CE 223 To succeed (To get a grade of at least DD) | |||||
| Course Language | English | |||||
| Course Type | ELECTIVE_COURSE | |||||
| Course Level | First Cycle | |||||
| Mode of Delivery | ||||||
| Teaching Methods and Techniques of the Course | - | |||||
| National Occupational Classification Code | - | |||||
| Course Coordinator |
|
|||||
| Course Lecturer(s) |
|
|||||
| Assistant(s) | - | |||||
| Course Objectives | These classification guidelines provide a broad base for data learning, database design and application module data definitions using ORACLE DBMS tool software. | |||||||||||||||||||||||||||||||||||||||||||||
| Learning Outcomes |
The students who succeeded in this course;
|
|||||||||||||||||||||||||||||||||||||||||||||
| Course Description | Database objects will be created using SQL language. SQL 'stored procedures' and 'triggers' writing will be learned using ORACLE. | |||||||||||||||||||||||||||||||||||||||||||||
| Related Sustainable Development Goals |
-
|
|||||||||||||||||||||||||||||||||||||||||||||
|
|
Core Courses |
|
| Major Area Courses |
X
|
|
| Supportive Courses |
|
|
| Media and Managment Skills Courses |
|
|
| Transferable Skill Courses |
|
WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES
| Week | Subjects | Required Materials | Learning Outcome |
| 1 | Introduction to database management systems | Presentations and lecture notes | LO3 |
| 2 | Database modeling, use of UML and Use Case Diagram | Presentations and lecture notes | LO1 |
| 3 | Relational Model and Algebra in Databases | Presentations and lecture notes | LO2 |
| 4 | Normalization | Presentations and lecture notes | LO2 |
| 5 | Normalization, transformed data | Presentations and lecture notes | LO2 |
| 6 | Definition of SQL database | Presentations and lecture notes | LO4 |
| 7 | Creating the SQL database | Presentations and lecture notes | LO4 |
| 8 | Stored procedures and triggers in SQL | Presentations and lecture notes | LO4 |
| 9 | Query optimization | Presentations and lecture notes | LO4 |
| 10 | Database processing, data integrity and security | Presentations and lecture notes | LO1 |
| 11 | Database throughput, concurrency, and recovery | Presentations and lecture notes | LO1 |
| 12 | Data Farms | Presentations and lecture notes | LO3 |
| 13 | Cloud Computing | Presentations and lecture notes | LO3 |
| 14 | Big Data I | Presentations and lecture notes | LO1 |
| 15 | Big Data II | Presentations and lecture notes | LO1 |
| 16 | Review | Presentations and lecture notes | - |
| Course Notes/Textbooks | “Database Systems” T Connoly C. Begg Addison 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 | Weighting | LO1 | LO2 | LO3 | LO4 |
| Quizzes / Studio Critiques | 2 | 30 | X | X | X | X |
| Midterm | 1 | 30 | X | X | ||
| Final Exam | 1 | 40 | X | X | ||
| Total | 4 | 100 |
ECTS / WORKLOAD TABLE
| Semester Activities | Number | Duration (Hours) | Workload |
|---|---|---|---|
| Participation | - | - | - |
| Theoretical Course Hours | 16 | 2 | 32 |
| Laboratory / Application Hours | 16 | 2 | 32 |
| Study Hours Out of Class | 16 | 2 | 32 |
| Field Work | - | - | - |
| Quizzes / Studio Critiques | 2 | 7 | 14 |
| Portfolio | - | - | - |
| Homework / Assignments | - | - | - |
| Presentation / Jury | - | - | - |
| Project | - | - | - |
| Seminar / Workshop | - | - | - |
| Oral Exams | - | - | - |
| Midterms | 1 | 15 | 15 |
| Final Exam | 1 | 25 | 25 |
| Total | 150 |
COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP
| # | PC Sub | Program Competencies/Outcomes | * Contribution Level | ||||
| 1 | 2 | 3 | 4 | 5 | |||
| No program competency data found. | |||||||
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest
NEWSALL NEWS
IZMIR UNIVERSITY OF ECONOMICS GÜZELBAHÇE CAMPUS
DetailsGLOBAL CAREER
As Izmir University of Economics transforms into a world-class university, it also raises successful young people with global competence.
More..CONTRIBUTION TO SCIENCE
Izmir University of Economics produces qualified knowledge and competent technologies.
More..VALUING PEOPLE
Izmir University of Economics sees producing social benefit as its reason for existence.
More..
You are one step ahead with your graduate education at Izmir University of Economics.