Quiz sistem database untuk mahasiswa STMIK MH. Thamrin Kampus Darunnajah
Sistem
Informasi
Data
Manajemen
Hasil dari pengolahan data
Sebagai acuan dalam pengambilan keputusan
Transformasi data
Rumit dalam implementas
Basis Data Model Jaringan
Basis Data Model File
Asis Data Model DBMS
Asis Data Model Relasi
Kerusakan pada sistem basis data dapat mempengaruhi departemen yang terkait
Penanganan proses recorvery & backup sulit
Penerapan standarisasi yang rumit
Implementasi relatif mahal
MySQL
Sybase
ORACLE
Symphony
E-R Diagrams
Normalisasi
Database Design
DBMS
Tuple
Attribut
Entitas
Cardinality
Attribut
Entitas
Primary Key
Candidate Key
User
Hardware
Antivirus
A dan B Benar
Menghilangkan kerangkapan data
Mengurangi kompleksitas
Mempermudah analisis data
Mempermudah pemodifikasian data
Create UNIVERSITAS
Create Database UNIVERSITAS
Create Databases UNIVERSITAS
Create Table UNIVERSITAS
CREATE
SELECT
UPDATE
INSERT
SELECT …. ORDER BY … DESC
SELECT …. SORT ON … DESC
SELECT … ORDER BY … ASC
SELECT … SORT BY … DESC
Unnormalized form
Second normal form
First normal form
BCNF
A. E.F. CODD
Boyce CODD
Niklaus Wirth
John Warnier
MAX
AVERAGE
COUNT
SUM
Kotak
Ellips
Belahketupat
Garis
SELECT … DISTINCT … FROM ...
SELECT DISTINCT … FROM …
SELECT … FROM … WHERE …
SELECT … FROM … INNER JOIN .. ON …
SELECT nim, kelas, nilai FROM grade WHERE nilai < 70
SELECT nim, kelas, nilai FROM grade WHERE nilai > 70
SELECT nim, kelas, nilai FROM grade WHERE nilai >= 70
SELECT * FROM grade WHERE nilai = 70
Informasi
Data
Database
DMBS
Programmer
End User
DBA
Sistem Analis
File
Record
Field
Database
File
Record
Field
Table
File
Record
Field
Database
Model Hirarki
Model Semantik
Model Jaringan
A dan C benar
Object Dasar
Relasi
Adanya Suatu Relasi
Atribute
ADD RECORD
INSERT INTO
ADD NEW
INSERT NEW
DELETE saldo WHERE saldo < 10000
DELETE saldo FROM tabungan WHERE saldo < 10000
DELETE FROM tabungan WHERE saldo < 10000
DELETE tabungan WHERE saldo < 10000
COUNT RECORD FROM …
SELECT * FROM … WHERE … COUNT …
SELECT SUM (*) FROM …
SELECT COUNT(*) FROM …
SELECT nama FROM mahasiswa WHERE alamat='jabodetabek'
SELECT nama FROM mahasiswa WHERE alamat='Jakarta, Bogor, Tangerang, Depok, Bekasi')
SELECT nama FROM mahasiswa WHERE alamat IN ('jabodetabek')
SELECT nama FROM mahasiswa WHERE alamat IN ('jakarta', 'bogor', 'tangerang', 'depok', 'bekasi')
SELECT * FROM karyawan WHERE dept 'hrd'
SELECT nama FROM karyawan WHERE dept NOT IN ('hrd', 'pemasaran')
SELECT nama FROM karyawan WHERE dept 'hrd' AND dept 'pemasaran'
B dan C benar
DELETE table
ERASE table
DROP table
REMOVE table
EDIT
ALTER
UPDATE
COMMIT
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.