Industrial Engineering (English) | |||||
Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 |
Course Code: | COE307 | ||||
Course Name: | Database Management Systems | ||||
Semester: | Fall | ||||
Course Credits: |
|
||||
Language of instruction: | English | ||||
Course Condition: | |||||
Does the Course Require Work Experience?: | No | ||||
Type of course: | Compulsory Courses | ||||
Course Level: |
|
||||
Mode of Delivery: | Face to face | ||||
Course Coordinator: | Doç. Dr. AMIR SEYYEDABBASI | ||||
Course Lecturer(s): | Doç. Dr. Bahman Arasteh | ||||
Course Assistants: |
Course Objectives: | Design and implement a basic database system using a database management system (DBMS). Create entity-relationship (ER) diagrams to represent data entities and their relationships. Apply normalization techniques to ensure data integrity and reduce redundancy in a database. Write SQL queries to retrieve and manipulate data from a database. Manage transactions and ensure data consistency using SQL. Optimize queries and improve the performance of a database using indexing and query optimization techniques. |
Course Content: | This course covers the fundamental concepts and skills needed to manage data effectively using a database management system (DBMS). Students will learn about the entity-relationship (ER) model, relational model and data definition language, functional dependencies, SQL, transactions, concurrency control, file and disk management, recovery systems, indexing, and query processing and optimization. They will also learn about database normalization, indexing, and query optimization techniques to improve the performance of the databases. |
The students who have succeeded in this course;
1) Can apply database concepts, entities, tables and fields 2) Can model the data and design structural database 3) Can design and implement efficient queries using SQL 4) Can evaluate and improve the database security and can make the connection with the software application 5) Can normalize the database and improve database performance |
Week | Subject | Related Preparation |
1) | Introduction to databases | |
2) | Relational Data Model - Relational Model | |
3) | Relational Data Model - Relational algebra | |
4) | Database design-ER Data Model | |
5) | Database design-ER Data Model | |
6) | SQL-Data definition language, Data Manipulation language | |
7) | SQL- Query language - Set operations | |
8) | Midterm Exam | |
9) | SQL-Subqueries- Set element test, Set comparison, Empty set test | |
10) | SQL-Grouping | |
11) | SQL-Constraints:Data-type,primary-key,second-key,not-null,column-constraints | |
12) | SQL-Stored procedures/functions | |
13) | Normalization | |
14) | Query optimization |
Course Notes / Textbooks: | Database System Concepts" by Abraham Silberschatz, Henry F. Korth, and S. Sudarshan |
References: | ders notları |
Course Learning Outcomes | 1 |
2 |
3 |
4 |
5 |
||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Program Outcomes | |||||||||||
1) Adequate knowledge in mathematics, science and industrial engineering; the ability to use theoretical and practical knowledge in these areas in complex engineering problems. | |||||||||||
2) Ability to identify, formulate, and solve complex industrial engineering problems; ability to select and apply appropriate analysis and modeling methods for this purpose. | 2 | 2 | |||||||||
3) Ability to design a complex industrial system, process, device or product to meet specific requirements under realistic constraints and conditions; ability to apply modern design methods for this purpose. | 2 | 2 | |||||||||
4) Ability to develop, select and use modern techniques and tools necessary for the analysis and solution of complex problems encountered in industrial engineering applications; ability to use information technologies effectively. | 2 | 3 | 3 | ||||||||
5) Ability to design, conduct experiments, collect data, analyze and interpret results for the study of complex engineering problems or industrial engineering research topics. | |||||||||||
6) Ability to work effectively within and multidisciplinary teams; individual study skills. | |||||||||||
7) Ability to communicate effectively orally and in writing; knowledge of at least one foreign language; ability to write effectice reports and understand written reports, to prepare design and production reports, to make effective presentations, to give and receive clear and understandable instructions. | |||||||||||
8) Awareness of the necessity of lifelong learning; ability to access information, to follow developments in science and technology and to renew continuously. | |||||||||||
9) To act in accordance with ethical principles, professional and ethical responsibility; information on the standards used in engineering applications. | |||||||||||
10) Information on business practices such as project management, risk management and change management; awareness of entrepreneurship and innovation; information about sustainable development. | |||||||||||
11) Knowledge of the effects of industrial engineering practices on health, environment and safety in the universal and social scale and the problems of the era reflected in industrial engineering; awareness of the legal consequences of industrial engineering solutions. |
No Effect | 1 Lowest | 2 Average | 3 Highest |
Program Outcomes | Level of Contribution | |
1) | Adequate knowledge in mathematics, science and industrial engineering; the ability to use theoretical and practical knowledge in these areas in complex engineering problems. | |
2) | Ability to identify, formulate, and solve complex industrial engineering problems; ability to select and apply appropriate analysis and modeling methods for this purpose. | 2 |
3) | Ability to design a complex industrial system, process, device or product to meet specific requirements under realistic constraints and conditions; ability to apply modern design methods for this purpose. | 2 |
4) | Ability to develop, select and use modern techniques and tools necessary for the analysis and solution of complex problems encountered in industrial engineering applications; ability to use information technologies effectively. | 3 |
5) | Ability to design, conduct experiments, collect data, analyze and interpret results for the study of complex engineering problems or industrial engineering research topics. | |
6) | Ability to work effectively within and multidisciplinary teams; individual study skills. | |
7) | Ability to communicate effectively orally and in writing; knowledge of at least one foreign language; ability to write effectice reports and understand written reports, to prepare design and production reports, to make effective presentations, to give and receive clear and understandable instructions. | |
8) | Awareness of the necessity of lifelong learning; ability to access information, to follow developments in science and technology and to renew continuously. | |
9) | To act in accordance with ethical principles, professional and ethical responsibility; information on the standards used in engineering applications. | |
10) | Information on business practices such as project management, risk management and change management; awareness of entrepreneurship and innovation; information about sustainable development. | |
11) | Knowledge of the effects of industrial engineering practices on health, environment and safety in the universal and social scale and the problems of the era reflected in industrial engineering; awareness of the legal consequences of industrial engineering solutions. |
Semester Requirements | Number of Activities | Level of Contribution |
Homework Assignments | 1 | % 15 |
Midterms | 1 | % 30 |
Final | 1 | % 55 |
total | % 100 | |
PERCENTAGE OF SEMESTER WORK | % 45 | |
PERCENTAGE OF FINAL WORK | % 55 | |
total | % 100 |
Activities | Number of Activities | Workload |
Course Hours | 14 | 42 |
Application | 14 | 28 |
Study Hours Out of Class | 14 | 42 |
Midterms | 1 | 20 |
Final | 1 | 20 |
Total Workload | 152 |