ECTS - Database Design and Management

Database Design and Management (CMPE341) Course Detail

Course Name Course Code Season Lecture Hours Application Hours Lab Hours Credit ECTS
Database Design and Management CMPE341 5. Semester 3 2 0 4 7
Pre-requisite Course(s)
N/A
Course Language English
Course Type Compulsory Departmental Courses
Course Level Bachelor’s Degree (First Cycle)
Mode of Delivery Face To Face
Learning and Teaching Strategies Lecture.
Course Coordinator
Course Lecturer(s)
Course Assistants
Course Objectives This course involves students in real-life problems and theory on database systems and encourages teamwork in the design and implementation of database systems.
Course Learning Outcomes The students who succeeded in this course;
  • Describe fundamental concepts of database systems
  • Practice on ER and EER data modeling
  • Design and implement a relational database system
  • Use SQL for database querying
Course Content Database system concepts, data modeling with ER and EER, the relational data model, file organizations and index structures, relational algebra, structured query language (SQL); database design: functional dependence and table normalization; introduction to database administration; a relational DBMS in a laboratory environment.

Weekly Subjects and Releated Preparation Studies

Week Subjects Preparation
1 DB system concepts 1.1 – 1.5, 2.1 – 2.3.1, 2.5.2 (main text)
2 ER model 3.1-3.7
3 EER model 4.1-4.3, 4.5
4 Relational model & Relational DB concepts 5.1-5.3
5 Relational algebra 6.1 – 6.5
6 ER- and EER-to-Relational Mapping 7.1 – 7.2.2
7 DB Design 10.1-10.2.2
8 DB Design 10.3
9 DB Design 10.5, 11.1
10 File organization 13.1-13.8.2, 13.9-13.10.2
11 Index structures 14.1-14.2
12 Index structures 14.3
13 Database Authorization, Security and Privacy 23.1 – 23.2
14 Database Authorization, Security and Privacy 23.4

Sources

Course Book 1. “Fundamentals of Database Systems”, 5th Edition, Ramez Elmasri & Shamkant B. Navathe, Addison-Wesley, 2006.
2. “Oracle 9i: SQL with an introduction to PL/SQL”, L. L. Morris-Murphy, Thomson Course Technology, 2003
Other Sources 3. “Principles of Database Systems with Internet and Java Applications”, Greg Ricardi, Addison-Wesley, 2001.
4. “Database Application Development & Design”, 3rd Ed., McGraw-Hill, M.V. Mannino, McGraw-Hill, 2005.
5. http://sqlCourse.com/ (Interactive Online SQL Training)
6. “Database Systems: A practical Approach to Design, Implementation, and Management”, T. Collony & Carolyn Begg, 4th Edition, Addison-Wesley, 2005.

Evaluation System

Requirements Number Percentage of Grade
Attendance/Participation - -
Laboratory 1 20
Application - -
Field Work - -
Special Course Internship - -
Quizzes/Studio Critics - -
Homework Assignments - -
Presentation - -
Project 1 15
Report - -
Seminar - -
Midterms Exams/Midterms Jury 1 30
Final Exam/Final Jury 1 35
Toplam 4 100
Percentage of Semester Work 65
Percentage of Final Work 35
Total 100

Course Category

Core Courses X
Major Area Courses
Supportive Courses
Media and Managment Skills Courses
Transferable Skill Courses

The Relation Between Course Learning Competencies and Program Qualifications

# Program Qualifications / Competencies Level of Contribution
1 2 3 4 5
1 Has adequate knowledge in mathematics, science, and computer engineering-specific subjects; uses theoretical and practical knowledge in these areas to solve complex engineering problems. X
2 Identifies, defines, formulates, and solves complex engineering problems; selects and applies appropriate analysis and modeling methods for this purpose. X
3 Designs a complex system, process, device, or product to meet specific requirements under realistic constraints and conditions; applies modern design methods for this purpose. X
4 Develops, selects, and uses modern techniques and tools necessary for the analysis and solution of complex problems encountered in computer engineering applications; uses information technologies effectively. X
5 Designs experiments, conducts experiments, collects data, analyzes and interprets results for the investigation of complex engineering problems or research topics specific to the discipline of computer engineering. X
6 Works effectively in disciplinary and multidisciplinary teams; gains the ability to work individually. X
7 Communicates effectively in Turkish, both orally and in writing; writes effective reports and understands written reports, prepares design and production reports, makes effective presentations, gives and receives clear and understandable instructions. X
8 Knows at least one foreign language; writes effective reports and understands written reports, prepares design and production reports, makes effective presentations, gives and receives clear and understandable instructions.
9 Has awareness of the necessity of lifelong learning; accesses information, follows developments in science and technology, and continuously improves oneself.
10 Acts in accordance with ethical principles and has awareness of professional and ethical responsibility.
11 Has knowledge about the standards used in computer engineering applications.
12 Has knowledge about workplace practices such as project management, risk management, and change management.
13 Gains awareness about entrepreneurship and innovation.
14 Has knowledge about sustainable development.
15 Has knowledge about the health, environmental, and safety impacts of computer engineering applications in universal and societal dimensions and the contemporary issues reflected in the field of engineering.
16 Gains awareness of the legal consequences of engineering solutions.
17 Analyzes, designs, and expresses numerical computation and digital representation systems. X
18 Uses programming languages and appropriate computer engineering concepts to solve computational problems. X

ECTS/Workload Table

Activities Number Duration (Hours) Total Workload
Course Hours (Including Exam Week: 16 x Total Hours) 16 5 80
Laboratory 1 10 10
Application
Special Course Internship
Field Work
Study Hours Out of Class 16 2 32
Presentation/Seminar Prepration
Project 1 20 20
Report
Homework Assignments
Quizzes/Studio Critics
Prepration of Midterm Exams/Midterm Jury 1 15 15
Prepration of Final Exams/Final Jury 1 20 20
Total Workload 177