Facebook
From hzthhae, 5 Months ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 129
  1. create database PC_1;
  2. use PC_1;
  3. create table pc(code int primary key, model varchar(4), speed decimal(4, 0) not null, hd decimal(3,0) not null, cd varchar(3) not null,
  4. price float);
  5. create table laptop(code int primary key, model varchar(4), speed decimal(4,0) not null, d decimal(3,0) not null, cd varchar(3) not null,
  6. price float);
  7. create table printer(code int primary key, model varchar(4), color char(1), type varchar(6) not null, price float not null);
  8. create table product(maker char(1) not null, model varchar(4) primary key, type varchar(7) not null);