CSE 202 Database Management Systems Lecture 0 Organizational

CSE 202 Database Management Systems Lecture 0 Organizational Issues Prepared & Presented by Asst. Prof. Dr. Samsun M. BAŞARICI

About this Course Title Course Semester Code Introduction to Computer CSE 202 Applications Spring Course Hour/Week Theory 2 Practice 2 ADU Credit ECTS 3 4 Course Type 1. Compulsory Courses 1. 1. Programme Compulsory Courses X 1. 2. University Compulsory Courses (UFND) 1. 3. YÖK (Higher Education Council) Compulsory Courses 2. Elective Courses 2. 1. Program Elective Courses 2. 2. University Elective Courses 3. Prerequisites Courses 3. 1. Compulsory Prerequisites Courses 3. 2. Elective Prerequisites Courses Organizational Issues 2

About this Course (Cont. ) Language of Instruction English Level of Course Associate Degree (Short Cycle) Undergraduate (First Cycle) Graduate (Second Cycle) Doctoral Course (Third Cycle) Special Pre-Conditions of the Course (compulsory) None Special Pre-Conditions of the Course (recommended) Mail: sbasarici@adu. edu. tr Web: Course Instructor(s) Dr. Samsun M. Başarıcı http: //akademik. adu. edu. tr/fakulte/muhendislik /personel/sbasarici/anasayfa Organizational Issues 3

Main Objective(s) of this Course n n n To provide the basis for data handling and management To make students able to apply data management and storage optimization techniques to a given problem Write queries to manipulate data Organizational Issues 4

Learning Outcomes of this Course n Upon successful completion of this course, students will q q q Know the main concepts of data and databases Understand the difference between data and information Understand the fundamentals of relational, objectoriented, and distributed database systems including: data models, database architectures, and database manipulations Organizational Issues 5

Learning Outcomes of this Course (Cont. ) q q q Understand theories and techniques in developing database applications and be able to demonstrate the ability to build databases using enterprise DBMS products such as Oracle or SQL Server Be familiar with managing database systems Understand new developments and trends in databases Organizational Issues 6

Course Content n n n n General information about databases and database users Database system concepts and architecture SQL and SQL programming techniques Relational algebra, relational calculus and entityrelationship (ER) model Object and object-relational databases UML and XML Functional dependencies and normalization for relational databases Organizational Issues 7

Course Content (Cont. ) n n n Relational database design algorithms Disk storage, file structures, hashing and indexing structures for files Query processing and optimization Database security & database recovery techniques Distributed databases Organizational Issues 8

Resources 1) Ramez Elmasri, Shamkant Navathe; “Fundamentals of Database Systems”, 6 th Ed. , Pearson, 2014. Required Course Material (s) 2) Mark L. Gillenson; “Fundamentals of /Reading(s)/Text Book (s) Database Management Systems”, 2 nd Ed. , John Wiley, 2012. 3) Lecture Notes Recommended Course Material (s)/Reading(s)/Other sources will be announced Organizational Issues 9

Course Schedule (Weekly) Week Topics Preliminary Preparation Methodology and Implementation (theory, practice, assignment etc) Theory, case studies 1 Introduction; Data, database systems Elmasri Ch. 1 -2, Gillenson Ch. 1 and concepts 2 Data modeling, relational data Elmasri Ch. 3 & 6, Gillenson Ch. 2 -3 & model, relational database model, 5 -6 relational calculus & algebra Theory, practice, quiz SQL Elmasri Ch. 4 -5, Gillenson Ch. 4 Theory, practice, case studies ER Model Elmasri Ch. 7 ER Model (cont. ) Elmasri Ch. 7 Theory, assignment Theory, practice, quiz 3 4 5 Database design methodology & UML Elmasri Ch. 10, Gillenson Ch. 7 -8 6 Theory, practice, assignment MIDTERM EXAM 7 Organizational Issues 10

Course Schedule (Weekly) (Cont. ) Week Topics 8 9 10 11 12 13 14 15 16 Preliminary Preparation Methodology and Implementation (theory, practice, assignment etc) Theory, practice, case studies, quiz Object & object-relational Elmasri Ch. 11, Gillenson Ch. 9 databases Theory, practice XML, introduction to SQL Elmasri Ch. 12 -13 programming Theory, practice, Dependencies, normalization for Elmasri Ch. 15 -16 assignment, quiz relational databases & relational database design Theory, practice Disk storage, file structures, Elmasri Ch. 17 -18, Gillenson Ch. 8 & hashing and indexing 10 Theory, practice Query processing & optimization Elmasri Ch. 19 Database administration, Elmasri Ch. 22 -24, Gillenson Ch. 10 Theory, practice, case studies, assignment recovery, security, backup & -11 concurrency Database administration, recovery, Elmasri Ch. 22 -24, Gillenson Ch. 10 Theory, practice, case studies, quiz security, backup & concurrency -11 (cont. ) Distributed databases Elmasri Ch. 25, Gillenson Ch. 12 -14 Theory, case studies FINAL EXAM Organizational Issues 11

Assessment (tentative) Semester Activities/ Studies NUMBER WEIGHT in % Mid- Term 1 20 Attendance - - Quiz 5 20 Assignment (s) 4 20 Project - - Laboratory - - Field Studies (Technical Visits) - - Presentation/ Seminar - - Practice (Laboratory, Virtual Court, Studio Studies etc. ) - - Other (Placement/Internship etc. ) - - TOTAL 60 Contribution of Semester Activities/Studies to the Final Grade 60 Contribution of Final Examination/Final Project/ Dissertation to the Final Grade 1 40 TOTAL 100 Organizational Issues 12

Assessment (Cont. ) n Final Grades will be determined according to the Adnan Menderes University Associate Degree, Bachelor Degree and Graduate Degree Education and Examination Regulation Organizational Issues 13

Responsibilities of the Students n n n Obtaining the text book(s) Coming to the course with a good preparation Completing the exercises with individual efforts unless told otherwise Following the rules set by the responsibles for the course and the implementation/lab. studies HONESTY !!! Organizational Issues 14

Plagiarism n n Plagiarism will not be tolerated Projects without references: a penalty of 20% Submitting your own work that has been earlier submitted to satisfy the requirements of another course is (self)-plagiarism (also called double dipping) Copying a journal article or a section of a book or code from an article or book and submitting it as your own is plagiarism Organizational Issues 15

Plagiarism n n Using significant ideas from someone else, but putting them in to your own words and not acknowledging the source of the ideas is plagiarism Copying an essay, code, work etc. from another student and submitting it as your own is plagiarism And PLAGIARISM is THEFT So don’t steal (Nobody likes thieves) Organizational Issues 16