30
Department
Domain IDDepartment : fixed length character string,
length 5, Format : DP[0-9] [0-9] [0-9]
Domain NamaDepartment : variable length character
string, length 50
Department(
IDDepartment
IDDepartment
NOT
NULL,
NamaDepartment
NamaDepartment
NOT
NULL,
PRIMARY KEY (IDDepartment));
Staff
Domain StaffID : fixed length character string, length
5, Format : ST[0-9] [0-9] [0-9]
Domain NamaStaff : variable length character string,
length 100
Domain AlamatStaff : variable length character
string, length 100
Domain JenisKelamin : single character, must be one
of ‘M’ or ‘F’
Staff(
StaffID
StaffID
NOT
NULL,
Nama_Staff
Nama_Staff
NOT
NULL,
Alamat_Staff
Alamat_Staff
NOT
NULL,
JenisKelamin
JenisKelamin
NOT
NULL,
PRIMARY KEY (StaffID);
FOREIGN KEY (IDDepartment) REFERENCES
Department(IDDepartment) ON UPDATE
CASCADE ON DELETE NO ACTION );
ii.
Merancang representasi dari data turunan
 |