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............!!!!