| Academic Unit: |
Management Information Systems |
| Mode of Delivery: |
Face to face |
| Prerequisites: |
None |
| Language of Instruction: |
English |
| Level of Course Unit: |
Graduate |
| Course Coordinator: |
Ebru DİLAN |
| Course Lecturer(s): |
Ebru DİLAN |
| Course Objectives: |
To provide a solid understanding of RDBMS (Relational Database Management Systems). The students will be able to carry out analysis, design, and implementation in the development of a RDBMS. Specifically, the students will be able to analyze a business and model the processes involved (formal systems analysis), design a conceptual database using Entity-Relationship diagrams, determine constraints, implement and maintain database objects (tables, constraints, indexes, etc.) and perform database operations using SQL and stored procedures/functions, and triggers. Effectively use environments/tools for communicating with the database server. Perform setup and essential maintenance of a professional database server. Work in a team to design and to develop a database for a given business, Prepare necessary documentation and presentation for the database project, and performing the presentation. |
| Course Contents: |
Database management systems and IT data modeling E-R diagrams conceptual, logical and physical database design constraint modeling database architectures and the relational database model SQL: selection, DML, DCL, DDL operations stored procedures/functions, and triggers. |
| Learning Outcomes of the Course Unit (LO): |
|
| Planned Learning Activities and Teaching Methods: |
In class lectures, homework, project, midterm and final exams |
At Kadir Has University, a Semester is 14 weeks; The weeks 15 and 16 are reserved for final exams.
1. Designing Effective Database Systems [elektronik kaynak/electronic resource], R. Riordan, Safari Books Online, 2005. KHÜ: QA76.9 .D26 R54 2005
2. Database System Concepts, A. Silberschatz, H. F. Korth, S. Sudarshan, McGraw Hill, 6th ed., 2011. KHÜ: QA76.9.D3 S55 2011
3. Fundamentals of Database Management Systems [elektronik kaynak/electronic resource] 2nd ed., M. L. Gillenson, Safari Books Online, 2012. KHÜ: XX(276592.1)
4. Database Systems [elektronik kaynak/electronic resource] : Concepts, Design and Applications 2nd ed., S. K. Singh, 2011. KHÜ: XX(278301.1)
5. Database Management Systems, G. V. Post, 2002. KHÜ: QA76.9.D3 P67 2002 * KHU Information Center record number |
THE RELATIONSHIP BETWEEN COURSE LEARNING OUTCOMES (LO) AND PROGRAM QUALIFICATIONS (PQ)
| # |
PQ1 |
PQ2 |
PQ3 |
PQ4 |
PQ5 |
PQ6 |
PQ7 |
PQ8 |
PQ9 |
PQ10 |
PQ11 |
PQ12 |
Contribution: 1 Low, 2 Average, 3 High
