COURSE UNIT TITLE

: DATABASE ADMINISTRATION

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
BIS 5011 DATABASE ADMINISTRATION ELECTIVE 3 0 0 5

Offered By

Business Information Systems (English)

Level of Course Unit

Second Cycle Programmes (Master's Degree)

Course Coordinator

PROFESSOR SABRI ERDEM

Offered to

Business Information Systems (English)

Course Objective

The course aims to develop an understanding the role of data, file management and databases in information systems.

Learning Outcomes of the Course Unit

1   Define the basic concepts of data, files and databases in information systems.
2   Understand the database development activities during the System Development Cycle (SDLC).
3   Be familiar with the data modelling concepts (E-R and Class diagrams) used in database design.
4   Create databases and pose complex SQL queries of relational databases.
5   Develop applications using several DBMS's.
6   Be familiar with a broad range of data management issues including data integrity and security.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Introduction, The Database Environment
2 File processing the development process
3 E-R modelling
4 Relational Database model
5 Normalization
6 Physical Database Design, intro to SQL
7 SQL
8 Midterm Exam
9 Data and Database Administration
10 Object Oriented Modelling
11 Client/Server Architecture and Databases
12 Distributed databases, Data Warehousing
13 Implementation Project Presentations
14 Implementation Project Presentations

Recomended or Required Reading

Text Books:
Will be announced in the first day of class.

Planned Learning Activities and Teaching Methods

The course consists of lectures, class discussion, computer applications, assignments, case analysis and implementation projects.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 STT TERM WORK (SEMESTER)
3 FIN FINAL EXAM
4 FCG FINAL COURSE GRADE MTE * 0.30 + STT * 0.20 + FIN* 0.50
5 RST RESIT
6 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.30 + STT * 0.20 + RST* 0.50


*** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

Further Notes About Assessment Methods

None

Assessment Criteria

1. Lectures will focus on the transfer of basic and advanced database topics where comprehension is substantially enhanced by additional elaboration and illustration.

2. Exams will measure the ability to identify and apply the databases in real business environment. Each exam will cover course materials and include problems like those assigned for homework, questions on lecture materials, and additional items covered in class meetings.

3. Homework problems will be assigned frequently. It is imperative that a student works and understands these problems to successfully complete the course. It is strongly recommended the students to work all homework problems as a study tool for the exams. By completing homework assignments, each student will enhance analytical skills, as well as, improve competency utilizing a DBMS. By actively participating in class discussions and in-class assignments, each student will improve communication and analytical skills through learning database concepts and business applications.

4. Case Analysis will offer an excellent opportunity for students to perform database analysis and develop solutions to real business database problems.

5. Students are required to complete an Implementation Project which allows them to apply the database administration skills they have developed to a topic of personal or professional interest.

6. For the case analysis and project works, a team including two students should be formed. Any deviation from this target number requires approval of the instructor. The cases will be assigned to each team by the instructor, the project topics will be determined by the students, which is subject to approval of the instructor.

7. By working with a group, students will improve teamwork, analytical, and communication skills through identifying and applying database analysis to the real world business problems. Case reports and project reports will enable students improve their competency using the language of data to communicate the results.

8. The case analysis and project works requires a cooperative effort. It is the responsibility of the team to assure that each team member has contributed approximately equally to the group work. Cases will be graded by the instructor and by the team members. Each member of the group will be asked at the end of the semester to evaluate his or her own contribution, and those of other team members. A peer evaluation form will be supplied during the last week of class.

9. The reports will be evaluated for such factors as apparent understanding of the topic, originality of treatment and discussion, accuracy of results, comprehensiveness of the report s content and depth of the analysis, clarity and mechanics of presentation such as organization, format, punctuation, grammar, and quality of exhibits and charts.

10. Grade for Student Participation will depend on (i) class attendance, (ii) the quality of answers the student provides to questions posed by the instructor during class, and (iii) the general contribution the student makes to the creation of a positive learning environment.

11. A good attendance record may bring the grade up one level, for grades on the boundary between two grade levels.

Language of Instruction

English

Course Policies and Rules

1. It is obligatory to attend at least 70% of the classes.
2. Violations of Plagiarism of any kind will result in disciplinary steps being taken.
3. Absence will not be considered an excuse for submitting homework assignments late.
4. Delayed case and project reports will suffer grade decay equivalent to one letter grade per day late.

Contact Details for the Lecturer(s)

sabri.erdem@deu.edu.tr

Office Hours

To be announced at the first lecture.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 3 39
Preparations before/after weekly lectures 12 1 12
Preparation for midterm exam 1 10 10
Preparation for final exam 1 25 25
Preparing assignments 8 5 40
Preparing presentations 1 5 5
Final 1 3 3
Midterm 1 3 3
TOTAL WORKLOAD (hours) 137

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7
LO.15252223
LO.25252233
LO.35353344
LO.45255245
LO.55355354
LO.65354344