Visit of broadAngle in Izmir University of Economics
The founder and CEO of broadAngle, a software company operating in the United States and Izmir, Garrison Atkisson, along with ...
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 | - | |||||||
National Occupation Classification | - | |||||||
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 |
|
|||||||||||||||||||||||||||||||||||||||||||||
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 |
Week | Subjects | Related Preparation | Learning Outcome |
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 |
Semester Activities | Number | Weighting | LO 1 | LO 2 | LO 3 | LO 4 |
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 |
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
|
#
|
PC Sub | Program Competencies/Outcomes |
* Contribution Level
|
||||
1
|
2
|
3
|
4
|
5
|
|||
1 |
Engineering Knowledge: Knowledge of mathematics, science, basic engineering, computer computation, and topics specific to related engineering disciplines; the ability to use this knowledge in solving complex engineering problems |
-
|
-
|
X
|
-
|
-
|
|
1 |
Mathematics |
-
|
-
|
-
|
-
|
-
|
|
2 |
Science |
-
|
-
|
-
|
-
|
-
|
|
3 |
Basic engineering |
-
|
-
|
-
|
-
|
-
|
|
4 |
Computer computation |
-
|
-
|
-
|
-
|
-
|
|
5 |
Topics specific to related engineering disciplines |
-
|
-
|
-
|
-
|
-
|
|
6 |
The ability to use this knowledge in solving complex engineering problems |
-
|
-
|
-
|
-
|
-
|
|
2 |
Problem Analysis: The ability to define, formulate, and analyze complex engineering problems by using fundamental science, mathematics, and engineering knowledge, while considering the relevant UN Sustainable Development Goals (SDGs) related to the problem. |
-
|
-
|
X
|
-
|
-
|
|
3 |
Engineering Design: The ability to design creative solutions to complex engineering problems; the ability to design complex systems, processes, devices, or products that meet present and future requirements, considering realistic constraints and conditions. |
-
|
-
|
X
|
-
|
-
|
|
1 |
The ability to design creative solutions to complex engineering problems |
-
|
-
|
-
|
-
|
-
|
|
2 |
Considering realistic constraints and conditions in designing complex systems, processes, devices, or products |
-
|
-
|
-
|
-
|
-
|
|
3 |
The ability to design in a way that meets current and future requirements |
-
|
-
|
-
|
-
|
-
|
|
4 |
Use of Techniques and Tools: The ability to select and use appropriate techniques, resources, and modern engineering and information technology tools, including prediction and modeling, for the analysis and solution of complex engineering problems, while being aware of their limitations |
-
|
-
|
X
|
-
|
-
|
|
5 |
Research and Investigation: The ability to use research methods, including literature review, designing experiments, conducting experiments, collecting data, analyzing and interpreting results, for the investigation of complex engineering problems. |
-
|
-
|
-
|
-
|
-
|
|
1 |
The ability to use research methods, including literature review |
-
|
-
|
-
|
-
|
-
|
|
2 |
Designing experiments |
-
|
-
|
-
|
-
|
-
|
|
3 |
Conducting experiments, collecting data, analyzing and interpreting results, for the investigation of complex engineering problems |
-
|
-
|
-
|
-
|
-
|
|
6 |
Global Impact of Engineering Practices: Knowledge of the impacts of engineering practices on society, health and safety, the economy, sustainability, and the environment within the scope of the UN Sustainable Development Goals (SDGs); awareness of the legal consequences of engineering solutions |
-
|
-
|
-
|
-
|
-
|
|
1 |
Global Impact of Engineering Practices: Knowledge of the impacts of engineering practices on society, health and safety, the economy, sustainability, and the environment within the scope of the UN Sustainable Development Goals (SDGs) |
-
|
-
|
-
|
-
|
-
|
|
2 |
Awareness of the legal consequences of engineering solutions |
-
|
-
|
-
|
-
|
-
|
|
7 |
Ethical Behavior: Acting in accordance with the principles of the engineering profession; knowledge of ethical responsibility; awareness of acting impartially and inclusively, without discrimination in any matter. (FENG101) |
-
|
-
|
-
|
-
|
-
|
|
1 |
Acting in accordance with the principles of the engineering profession; knowledge of ethical responsibility |
-
|
-
|
-
|
-
|
-
|
|
2 |
Awareness of acting impartially and inclusively, without discrimination in any matter. |
-
|
-
|
-
|
-
|
-
|
|
8 |
Individual and Team Work: The ability to work effectively as an individual and as a member or leader of both intra-disciplinary and interdisciplinary teams (whether face-to-face, remote, or hybrid). |
-
|
-
|
-
|
-
|
-
|
|
9 |
Verbal and Written Communication: Taking into account the various differences of the target audience (such as education, language, profession), particularly in technical matters. |
-
|
-
|
-
|
-
|
-
|
|
1 |
Verbal (ENGxxx) |
-
|
-
|
-
|
-
|
-
|
|
2 |
Written effective communication skills. (ENGxxx) |
-
|
-
|
-
|
-
|
-
|
|
10 |
Project Management: Knowledge of business practices such as project management and economic feasibility analysis; awareness of entrepreneurship and innovation. |
-
|
-
|
-
|
-
|
-
|
|
1 |
Knowledge of business practices such as project management and economic feasibility analysis; (FENG497-FENG498) |
-
|
-
|
-
|
-
|
-
|
|
2 |
Awareness of entrepreneurship and innovation. (FENG101) |
-
|
-
|
-
|
-
|
-
|
|
11 |
Lifelong Learning: The ability to learn independently and continuously, adapt to new and emerging technologies, and think critically about technological changes. |
-
|
-
|
-
|
-
|
-
|
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest
The founder and CEO of broadAngle, a software company operating in the United States and Izmir, Garrison Atkisson, along with ...
As Izmir University of Economics transforms into a world-class university, it also raises successful young people with global competence.
More..Izmir University of Economics produces qualified knowledge and competent technologies.
More..Izmir University of Economics sees producing social benefit as its reason for existence.
More..