Ders Planı

ISTANBUL AYDIN UNIVERSITY

CLASS 1

CLASS 4

Lesson plan / INTRODUCTION TO DATABASE SYSTEMS

Lesson Information

Course Credit	3.0
Course ECTS Credit	5.0
Teaching Language of Instruction	İngilizce
Level of Course	Bachelor's Degree, TYYÇ: Level 6, EQF-LLL: Level 6, QF-EHEA: First Cycle
Type of Course	Faculty Elective
Mode of Delivery	Face-to-face
Does the course require compulsory or optional work experience?	F
Course Coordinator
Instructor (s)
Course Assistant

Purpose and Content

The aim of the course	To give to students the principles of investication, design and application of DataBase Managment Systems, File Organization problems, Relational Algebra Theory, SQL-language, Searching strategies in DB-systems.
Course Content	Basıc conceps of DB Systems, Data modeling using ER-model, Record storage principles, file organization methods, Integrity constraints in DBS, Relational DB language SQL, Functional Dependences in DBS,Normal forms, DBS Security problems.

Learning Outcomes

Mathematics , Science and sufficient knowledge in electrical engineering issues; theoretical and practical knowledge in the field of Electrical and Electronics Engineering the ability to apply for modeling and problem solving.
Ability to identify, define, formulate and solve complex engineering problems; ability to select and implement the appropriate analysis and modeling methods in this respect.
Ability to work effectively in interdisciplinary and multidisciplinary teams; ability to work individually .
Act according to ethical , professional and ethical responsibility about the standards used in electrical and electronic engineering applications
The ability to design to meet specific needs;complex system , process, device or product under realistic constraints and conditions , the ability to apply modern design methods for this purpose .
Awareness of the necessity of lifelong learning ; Access to knowledge, science and developments in technology and continuous self -improvement.
Awareness of universal and social dimensions of health electrical engineering applications , contemporary issues and their impact on the environment and safety ; awareness of the legal consequences of engineering solutions .
Ability to communicate effectively in Turkish, both oral and written, with at least one foreign language knowledge, ability to write effective reports and understand written reports, prepare design and production reports, make effective presentations, giving clear and concise instructions and receiving skills.
Information on project management and practices in business life such as risk management and change management; awareness about entrepreneurship, innovation and sustainable development.
Analyzing and solving using modern techniques and tools for complex problems encountered in the electrical and electronics application development , selection and use of skills , skills to use ICT effectively
Designing experiments for the study of electrical engineering problems , conduct experiments, collect data , analyze and interpret the results .
Awareness about occupational health and safety
Development and scientific publications of conciousness can be followed in the electrical and electronics engineering. Developed will be able to access the resources that it can meet the education requirements for the new system awareness.

Weekly Course Subjects

1	Introduction.Basic principles.
2	DBS concepts and Architecture.
3	Data modeling using ER-Model.
4	Record storage principles.
5	File organization methods.
6	The Relational data Model.
7	Midterm exam.
8	DBS Integrity Constraints.
9	Basics of the Ralational Algebra.
10	Relational DB language SQL.
11	Queries in SQL.
12	Functional Dependencies in DBS.
13	Normal Forms in DBS: 1st,2nd,3rd,and 4th.
14	Final exam.

Resources

1-Elmasri R., Navathe Sh., "Fundamentals of DataBase Systems", Addison Wesley, 2000.

EUA Kurumsal Öz değerlendirme Programı İzleme Raporu