DBMS | Latihan Pertemuan 5

Question 1

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Pada pemetaan diagram ER dimana untuk setiap entity type E pada diagram ER, dibuat satu relasi R yang mengandung semua ... dari E

Select one:

Simple atribut

Composite atribut

Primary key

Derived atribut

Foreign key

Feedback

Your answer is correct.

The correct answer is: Simple atribut

Question 2

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Pada pemetaan diagram ER dimana masukkan primary key dari relasi-relasi yang berpartisipasi pada relationship digunakan sebagai ... dari S

Select one:

Primary key

Foreign key

Composite atribut

Derived atribut

Simple atribut

Feedback

Your answer is correct.

The correct answer is: Foreign key

Question 3

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Dari gambar disamping, yang merupakan entity adalah

Select one:

Quantity

PART

PartNo & Quantity

PartNo

SUPPLY

Feedback

Your answer is correct.

The correct answer is: PART

Question 4

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Pada gambar di soal No 3, yang merupakan Relasi adalah

Select one:

PartNo

SUPPLY

PART

PartNo & Quantity

Quantity

Feedback

Your answer is correct.

The correct answer is: SUPPLY

Question 5

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Hasil Pemetaan Relasi dari gambar pada soal No 3, adalah

Select one:

PART ( Quantity, ...)

PART ( PartNo, ... )

SUPPLY ( Quantity, ...)

SUPPLY (PartNo, ... )

SUPPLY ( PartNo, Quantity, ...)

Feedback

Your answer is correct.

The correct answer is: SUPPLY ( PartNo, Quantity, ...)

Question 6

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Program aplikasi yang telah terisolasi dari perubahan dalam struktur data yang disimpan, disebut...

Select one:

Case Tools

Repositori

Independensi Data

Model Data

User Interface

Feedback

Your answer is correct.

The correct answer is: Independensi Data

Question 7

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Personilyang bertanggung-jawab merancang program aplikasi  beserta struktur datanya dalam database

Select one:

Administrator Data

Developer Sistem

End User

System Analyst

Programmer

Feedback

Your answer is correct.

The correct answer is: End User

Question 8

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Atribute yang memiliki lebih dari satu harga, biasanya punya batas bawah dan batas atas, disebut

Select one:

Composite

Single Valued

Derived

Simple

Multi valued

Feedback

Your answer is correct.

The correct answer is: Multi valued

Question 9

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Atribut yang dapat dibagi menjadi beberapa atribut dasar, disebut

Select one:

Composite

Derived

Single Valued

Multi valued

Simple

Feedback

Your answer is correct.

The correct answer is: Composite

Question 10

Correct

Mark 1.00 out of 1.00

Flag question

Question text

Kardinalitas untuk gambar diatas yang sesuai adalah

Select one:

1 : M

1 : N

M : N

M : 1

1 : 1