Transcript theory, practice, assignment etc

CSE202 Database Management Systems
Lecture 0
Organizational Issues
Prepared & Presented by Asst. Prof. Dr. Samsun M. BAŞARICI
About this Course
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
Associate Degree (Short Cycle)
Undergraduate (First Cycle)
Graduate (Second Cycle)
Doctoral Course (Third Cycle)
Level of Course
Special Pre-Conditions of the Course
(compulsory)
None
Special Pre-Conditions of the Course
(recommended)
Mail: [email protected]
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



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

Upon successful completion of this course,
students will



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.)



Understand the 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







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.)





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”, 6th Ed.,
Pearson, 2014.
Required Course Material (s)
2) Mark L. Gillenson; “Fundamentals of
/Reading(s)/Text Book (s)
Database Management Systems”, 2nd Ed., John
Wiley, 2012.
3) Lecture Notes
Recommended Course
Material
(s)/Reading(s)/Other
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 model, Elmasri Ch. 3 & 6, Gillenson Ch. 2-3 &
relational database model, relational 5-6
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
6
Database
UML
design
methodology
& Elmasri Ch. 10, Gillenson Ch. 7-8
Theory, practice,
assignment
MIDTERM EXAM
7
Organizational Issues
10
Course Schedule (Weekly) (Cont.)
Preliminary Preparation
Week Topics
8
9
10
11
12
13
14
15
16
Object & object-relational
databases
XML, introduction to SQL
programming
Dependencies, normalization for
relational databases & relational
database design
Disk storage, file structures,
hashing and indexing
Query processing & optimization
Database administration, recovery,
security, backup & concurrency
Elmasri Ch. 11, Gillenson Ch. 9
Database administration, recovery,
security, backup & concurrency
(cont.)
Distributed databases
FINAL EXAM
Elmasri Ch. 22-24, Gillenson Ch.
10-11
Methodology and
Implementation
(theory, practice,
assignment etc)
Theory, practice, case
studies, quiz
Elmasri Ch. 12-13
Theory, practice
Elmasri Ch. 15-16
Theory, practice,
assignment, quiz
Theory, practice
Elmasri Ch. 17-18, Gillenson Ch. 8
& 10
Theory, practice
Elmasri Ch. 19
Theory, practice, case
Elmasri Ch. 22-24, Gillenson Ch.
studies, assignment
10-11
Elmasri Ch. 25, Gillenson Ch. 12-14
Organizational Issues
Theory, practice, case
studies, quiz
Theory, case studies
11
Assessment (tentative)
Semester Activities/ Studies
NUMBER
WEIGHT in %
Mid- Term
Attendance
Quiz
Assignment (s)
Project
Laboratory
Field Studies (Technical Visits)
Presentation/ Seminar
1
5
4
-
20
20
20
-
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
TOTAL
1
40
100
Organizational Issues
12
Assessment (Cont.)

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





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




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




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