20、数据库设计案例分析

数据库设计案例分析

1. 汽车制造公司数据库设计

在汽车制造公司的数据库设计中，需要创建多个表来存储不同类型的数据。以下是部分表的创建 SQL 语句：

CREATE TABLE model
(
model_numb INTEGER,
model_description VARCHAR (40),  
suggested_retail_price NUMBER (6,2),  
shipping_weight NUMBER(6,2),
time_to_manufacture TIME,
PRIMARY KEY (model_numb)
);

CREATE TABLE test_type
(
test_code INTEGER,
test_description VARCHAR (40),
PRIMARY KEY (test_code)
);

CREATE TABLE test
(
test_date DATE,
test_location VARCHAR (40),
test_code INTEGER,
test_results VARCHAR (256),
PRIMARY KEY (model_numb, test_date),
FOREIGN KEY (model_numb) REFERENCES model,  
FOREIGN KEY (test_code) REFERENCES test_type
);

CREATE TABLE customer
(
customer_numb INTEGER,
customer_name VARCHAR (40),
customer_street VARCHAR (50),
customer_c