Ebook, Free Download, Materi Kuliah, MySQL, PHP

Materi Kuliah – Pemrograman Web 2

Berikut beberapa bagian penting Materi Kuliah Pemrograman Web 2 Setelah MID Semester.

CREATE TABLE tb_siswa (
s_id int(5) NOT NULL auto_increment,
s_nis varchar(25) NOT NULL,
s_nama varchar(100) NOT NULL,
s_tmplahir varchar(100) DEFAULT NULL,
s_tgllahir date DEFAULT NULL,
s_alamat text,
s_kelas varchar(25) DEFAULT NULL,
PRIMARY KEY(s_id, s_nis),
UNIQUE KEY(s_nis)
)ENGINE=INNODB;

CREATE TABLE tb_guru (
g_id int(5) auto_increment,
g_nip varchar(25) NOT NULL,
g_nama varchar(100) NOT NULL,
g_pendidikan varchar(100) DEFAULT NULL,
g_status varchar(25) DEFAULT NULL,
PRIMARY KEY(g_id, g_nip),
UNIQUE KEY(g_nip)
) ENGINE=INNODB;

CREATE TABLE tb_mp (
m_id int(5) NOT NULL auto_increment,
m_kode varchar(25) NOT NULL,
m_nama varchar(100) NOT NULL,
m_jam int(1) DEFAULT '0',
m_gid int(3) DEFAULT NULL,
PRIMARY KEY(m_id, m_kode, m_gid),
UNIQUE KEY(m_kode),
FOREIGN KEY (m_gid) REFERENCES tb_guru (g_id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB;

CREATE TABLE tb_nilai (
n_id int(5) NOT NULL auto_increment,
n_nis varchar(25) NOT NULL,
n_mkode varchar(25) NOT NULL,
n_ulangan int(3) DEFAULT '0',
n_uts int(3) DEFAULT '0',
n_uas int(3) DEFAULT '0',
PRIMARY KEY(n_id),
FOREIGN KEY (n_nis) REFERENCES tb_siswa (s_nis) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (n_mkode) REFERENCES tb_mp (m_kode) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB;

Download File Materi PDF.

btn-download

About Suendri

Owner dan Founder Go Software Media sebelumnya bernama PHPBeGO Foundation

Discussion

No comments yet.

Tinggalkan Komentar

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow Go Software Media Blog on WordPress.com

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 63 other followers

Archives

%d bloggers like this: