Search-form

Kamis, 07 April 2011

TUGAS BASIS DATA 3


INI GAMBAR CDM SEBELUM JADI PDM,,, YANG DI TULIS PADA TABEL DI ATRIBUT IALAH:
=> CREATE TABLE customer ( (> customer_id INTEGER, (> name CHAR(30), (> telephone CHAR(20), (> street CHAR(40), (> city CHAR(25), (> state CHAR(2), (> zipcode CHAR(10), (> country CHAR(20) (> );
CREATE => CREATE TABLE employee ( (> employee_id INTEGER, (> name CHAR(30), (> hire_date DATE (> );
CREATE => CREATE TABLE part ( (> part_id INTEGER, (> name CHAR(30), (> cost NUMERIC(8,2), (> weight FLOAT (> );
=> CREATE TABLE salesorder ( (> order_id INTEGER, (> customer_id INTEGER, -- joins to ustomer.customer_id (> employee_id INTEGER, -- joins to employee.employee_id (> part_id INTEGER, -- joins to part.part_id (> order_date DATE, (> ship_date DATE, (> payment NUMERIC(8,2) (> );



INI GAMBAR PDM............!!!!

0 komentar:

Posting Komentar

Twitter Delicious Facebook Digg Stumbleupon Favorites More