Module Handbook

 

Module Name:

Database

Module Level:

Bachelor

Abbreviation, if applicable:

MAT206

Sub-heading, if applicable:

-

Courses included in the

module, if applicable:

-

Semester/term:

3rd/ Second Year

Module coordinator(s):

Drs. Edi Winarko,M.Cs.,

Lecturer(s):

Drs. Edi Winarko,M.Cs.

Language:

BahasaIndonesia

Classification within the

curriculum

Compulsory Course/ Elective Studies

Teaching format / class

hours per week during semester:

2hours lectures (50 min / hour)

Workload:

2hours lectures, 2hour structural activities, 2hours individual study,

13 week per semester, and total 78 hours per semester 2.6 ECTS

Credit Points:

2

Requirements:

-

Learning goals/competencies:

General Competence (Knowledge)

able to build a database and implement on a problem.

Specific Competence:

1.       Explaining the purpose and objective of the database

2.       Building a Model Entity Relationship Diagram

3.       Applying the normalization process in building a Database

4.       Building the Relational Model

5.       Build Query with Structured Query Language (SQL)

6.       Implement Database on a case

.

Content:

Studying the concept Basic Database Database To design through Steps: design of ER-Diagram, Normalization Process through Functional Dependencies, Normal Forms form-1, Normal Form 2nd, 3rd and Normal Form BCNF Until IN Discussion and Implementation Language SQL Database

Soft skill Attribute

Active and good communication

Study/exam achievements:

The lecture material is given by lectures, and discussions. In this course, there are also direct practice with a computer that is on the subject that requires an understanding of the material through which completion case directly practice with a computer. To improve understanding of the material, students were given the task in the form of individual tasks and task groups. Exam on the course database includes quizzes, UTS and UAS. For the quiz includes a written test and practice with the computer. At the end of the semester exams makes a big project in the form of a case study of a problem for the settlement sought in the manufacture of its database system. In addition there is a soft skill assessment.

 

Final score (NA) is calculated as follow: 20% assignment + 10%

Softskill + 20% Quiz + 25% UTS + 25% UAS

 

 

Final index is defined as follow:

A : 75 100

AB : 70 - 74.99

B : 65 - 69.99

BC : 60 - 64.99

C : 55 - 59.99

D : 40 - 54.99

E : 0 - 39.99

Forms of Media:

LCD Projectors, whiteboards

Learning Methods

Lecture, assessments and group discussion

Literature:

1.       Korth and Silberschatz, 1997, Data Base Systems Concept, McGraw-Hill

2.       C.J.Date, 1982, An Introduction to Data Base System

3.       Elmasri and Navathe, 2000, Fundamental of Database Systems, Addison-Wesley, Inc.

4.       Winarko, Edi, 2006, Perancangan Database dengan Power Designer 6.32.

 

Notes: