Dua tabel sederhana: students dan scores.
CREATE TABLE students (
student_id INT AUTO_INCREMENT PRIMARY KEY,
nisn VARCHAR(12) NOT NULL UNIQUE,
name VARCHAR(50) NOT NULL,
kelas VARCHAR(5)
);
CREATE TABLE scores (
score_id INT AUTO_INCREMENT PRIMARY KEY,
student_id INT,
subject VARCHAR(20),
score INT,
FOREIGN KEY (student_id) REFERENCES students(student_id) ON DELETE SET NULL
);
Berdasarkan skema students di atas, pernyataan mana yang benar tentang kolom student_id dan nisn ?

Question

Dua tabel sederhana: students dan scores. 
 CREATE TABLE students ( 
   student_id INT AUTO_INCREMENT PRIMARY KEY, 
   nisn VARCHAR(12) NOT NULL UNIQUE, 
   name VARCHAR(50) NOT NULL, 
   kelas VARCHAR(5) 
 ); 
 CREATE TABLE scores ( 
   score_id INT AUTO_INCREMENT PRIMARY KEY, 
   student_id INT, 
   subject VARCHAR(20), 
   score INT, 
   FOREIGN KEY (student_id) REFERENCES students(student_id) ON DELETE SET NULL 
 ); 
 Berdasarkan skema students di atas, pernyataan mana yang benar tentang kolom  student_id  dan  nisn ?

Answer

student_id  otomatis berurutan karena AUTO_INCREMENT.

Answer

nisn  bisa bernilai NULL.

Answer

nisn  dijamin unik karena diberi UNIQUE.

Answer

nisn  otomatis diindeks oleh MySQL karena ada UNIQUE.

Answer

student_id  tidak bisa menjadi PRIMARY KEY jika ada AUTO_INCREMENT.

Crowdly

Dua tabel sederhana: students dan scores. CREATE TABLE students ( student_...

Want instant access to all verified answers on lms.smktarunabhakti.sch.id?