DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING-I

Course Description

At the end of this course, students are expected to have experience and knowledge on databases, database design and SQL. Introduction to DBMS (Definition, characteristics, levels of abstraction, advantages, query types), Relational database (relational model, database design), Relational Algebra, SQL, Data Manipulation Language (DML), nested queries, sub-queries, joins, grouping, row functions, aggregate functions, Data Definition Languages (DDL) with constraints like primary key, foreign key and case constraints will be covered. Also, database user management and user rights will be explained.

DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING-I

Evaluation Tools (Active Term)

No evaluation items have been defined.

Course outcomes

1. 01 Analyze a problem to design a relational database.
2. 02 recognize the fundamental concepts in relational theory
3. 03 implement relational theory to working knowledge of Oracle DBMS Server
4. 04 apply SQL for DML and DDL

Course Syllabus

Reference Books & Course Materials

1. 01 Elmasri & Navthe: Fundamentals of Database Systems, Addison Wesley, fifth ed., 2007.

Learning Outcomes

1. L01 To develop skills for designing and implementing a relational database
2. L02 To give students an understanding of the fundamental concepts in relational theory
3. L03 To give students a working knowledge of Oracle DBMS Server
4. L04 To enable students in the use of SQL for DML and DDL

Program Outcomes

1. P01 Adequate knowledge in mathematics, science and engineering subjects pertaining to the relevant discipline; ability to use theoretical and applied knowledge in these areas in complex engineering problems.
2. P02 Ability to identify, formulate, and solve complex engineering problems; ability to select and apply proper analysis and modelling methods for this purpose.
3. P03 Ability to design a complex system, process, device or product under realistic constraints and conditions, in such a way as to meet the desired result; ability to apply modern design methods for this purpose.
4. P04 Ability to devise, select, and use modern techniques and tools needed for analysing and solving complex problems encountered in engineering practice; ability to employ information technologies effectively
5. P05 Ability to design and conduct experiments, gather data, analyse and interpret results for investigating complex engineering problems or discipline specific research questions.
6. P06 Ability to work efficiently in intra-disciplinary and multi-disciplinary teams; ability to work individually.
7. P07 Ability to communicate effectively in Turkish, both orally and in writing; knowledge of a minimum of one foreign language; ability to write effective reports and comprehend written reports, prepare design and production reports, make effective presentations, and give and receive clear and intelligible instructions.
8. P08 Recognition of the need for lifelong learning ; ability to access information, to follow developments in science and technology, and to continue to educate him/herself.
9. P09 Consciousness to behave according to ethical principles and professional and ethical responsibility; knowledge on standards used in engineering practice.
10. P10 Knowledge about business life practices such as project management, risk management, and change management; awareness in entrepreneurship, innovation; knowledge about sustainable development.
11. P11 Knowledge about the global and social effects of engineering practices on health, environment, and safety, and contemporary issues of the century reflected into the field of engineering; awareness of the legal consequences of engineering solutions.

Po-Lo Matrix