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 Systems
|
Code
|
Semester
|
Theory
(hour/week) |
Application/Lab
(hour/week) |
Local Credits
|
ECTS
|
CE 223
|
Spring
|
3
|
2
|
4
|
7
|
Prerequisites |
None
|
|||||
Course Language |
English
|
|||||
Course Type |
Required
|
|||||
Course Level |
First Cycle
|
|||||
Mode of Delivery | - | |||||
Teaching Methods and Techniques of the Course | Problem SolvingApplication: Experiment / Laboratory / WorkshopLecture / Presentation | |||||
National Occupation Classification | - | |||||
Course Coordinator | ||||||
Course Lecturer(s) | ||||||
Assistant(s) |
Course Objectives | The goal of this course is to give basic knowledge of database systems to a student who intends to be a computer or software engineer. It provides a comprehensive introduction to relational data model and entityrelationship data model as a design tool. Functional and multivalued dependencies in the context of normalization process are described in detail for designing relational database schema. SQL database language and system aspects of SQL such as transaction management, indexing, constraints, triggers and authorization are studied in detail together with laboratory practices illustrating different ways of database programming. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Learning Outcomes |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Course Description | Topics related to both database design and database programming are covered. |
|
Core Courses |
X
|
Major Area Courses | ||
Supportive Courses | ||
Media and Management Skills Courses | ||
Transferable Skill Courses |
Week | Subjects | Related Preparation | Learning Outcome |
1 | Introduction to Database Systems, Relational Data Model, Semi Structured Data Model | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 1, Ch. 2.1, 2.2, 2.3, Ch. 11.1, 11.2, 11.3) | |
2 | Entity-Relationship Data Model | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 4.1, 4.2, 4.3, 4.4, 4.5, 4.6) | |
3 | Introduction to Relational Databases, Functional Dependencies | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 2.4, 3.1, 3.2, 3.3, 3.4, 3.5) | |
4 | Design of Relational Databases, Multivalued Dependencies | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 3.6, 3.7) | |
5 | Functional Dependencies and Multivalued Dependencies Revisited | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 2.4, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7) | |
6 | Introduction to SQL (Part I) | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 6.1, 6.2, 6.3, 6.4.1, 6.4.2) | |
7 | Introduction to SQL (Part II) | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 5.2, 6.4, 6.5) | |
8 | Midterm | ||
9 | Constraints and Triggers | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 7) | |
10 | SQL Programming: Embedded SQL, PSM (PL/SQL) | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 9.3, 9.4) | |
11 | SQL Programming: CLI, JDBC, PHP/PEAR | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 9.1, 9.2, 9.5, 9.6, 9.7) | |
12 | Transactions, Views, Indexes | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 6.6, 8.1, 8.2, 8.3, 8.4, 8.5) | |
13 | SQL Authorization | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 10.1) | |
14 | Logical Query Languages (Datalog) and SQL Recursion | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 5.3, 5.4, 10.2) | |
15 | Review of the Semester | ||
16 | Final Exam |
Course Notes/Textbooks | Textbook "J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008" and course slides (Book’s URL: http://wwwdb.stanford.edu/~ullman/fcdb.html) |
Suggested Readings/Materials | Reference Book: Silberschatz et. al., Database System Concepts, 4th ed., McGrawHill, 2002. |
Semester Activities | Number | Weigthing | LO 1 | LO 2 | LO 3 | LO 4 | LO 5 | LO 6 |
Participation | ||||||||
Laboratory / Application |
1
|
15
|
||||||
Field Work | ||||||||
Quizzes / Studio Critiques |
1
|
15
|
||||||
Portfolio | ||||||||
Homework / Assignments |
1
|
|||||||
Presentation / Jury | ||||||||
Project | ||||||||
Seminar / Workshop | ||||||||
Oral Exams | ||||||||
Midterm |
1
|
30
|
||||||
Final Exam |
1
|
40
|
||||||
Total |
Weighting of Semester Activities on the Final Grade |
4
|
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
|
3
|
48
|
Laboratory / Application Hours (Including exam week: '.16.' x total hours) |
16
|
2
|
32
|
Study Hours Out of Class |
14
|
3
|
42
|
Field Work |
0
|
||
Quizzes / Studio Critiques |
1
|
15
|
15
|
Portfolio |
0
|
||
Homework / Assignments |
12
|
2
|
24
|
Presentation / Jury |
0
|
||
Project |
0
|
||
Seminar / Workshop |
0
|
||
Oral Exam |
0
|
||
Midterms |
1
|
21
|
21
|
Final Exam |
1
|
28
|
28
|
Total |
210
|
#
|
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. |
-
|
-
|
-
|
X
|
-
|
|
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..