Scribd
Upload
16 views6 pages

Data Dictionary Format

The document is a data dictionary detailing the structure of a database related to car companies, manufacturing plants, vehicles, sales, brands, models, suppliers, options, customers, dealers, and inventory. Each entity is defined with its fields, types, descriptions, and key constraints. The document provides a comprehensive overview of the relationships and attributes within the database schema.

Uploaded by

knwati24
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
16 views6 pages

Data Dictionary Format

The document is a data dictionary detailing the structure of a database related to car companies, manufacturing plants, vehicles, sales, brands, models, suppliers, options, customers, dealers, and inventory. Each entity is defined with its fields, types, descriptions, and key constraints. The document provides a comprehensive overview of the relationships and attributes within the database schema.

Uploaded by

knwati24
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Data Dictionary

Your Database
No Entity Field Name Field Type Field Description Nullable Key
1 car_company com_id varchar(20) unique identity number for car copany No PK
com_name varchar(20) car company name Yes

2 manufacturing_plant plant_id varchar(20) unique identity number for manufacturing plant No PK/FK
plant_name varchar(20) unique course code for each course Yes PK
location varchar(40) unique section number for each section Yes
annual_output decimal(8,2) semester number Yes
com_id varchar(20) academic year Yes FK
established_date date Yes

3 vehicle vin varchar(20) No PK


price decimal(8,2) Yes
c_id varchar(20) Yes FK
d_id varchar(20) Yes FK
op_id varchar(20) Yes FK
plant_id varchar(20) Yes FK
sales_id varchar(20) Yes FK

4 sales sales_id varchar(20) No PK


sold_price decimal(8,2) Yes
vin varchar(20) Yes FK
unit_sold varchar(20) Yes
mo_id varchar(20) Yes FK
c_id varchar(20) Yes FK
sold_date date Yes
5 brand bd_id varchar(20) No PK
bd_name varchar(20) Yes
sales_id varchar(20) Yes FK

6 model mo_id varchar(20) No PK


mo_name varchar(20) No PK
body_style varchar(20) Yes
bd_id varchar(20) Yes FK
mo_year decimal(4,0) Yes

7 supplier s_id varchar(20) No PK


s_name varchar(20) Yes
s_location varchar(45) Yes

8 option1 op_id varchar(20) No PK


engine_name varchar(20) Yes
engine_power varchar(20) Yes
color varchar(20) Yes
steering_side varchar(45) Yes
transmission varchar(20) Yes
mo_id varchar(20) Yes FK
mo_year decimal(4,0) Yes

9 supplies s_id varchar(20) No PK


op_id varchar(20) No PK
defective varchar(20) Yes
transmission varchar(20) Yes
supply_date date Yes
10 customer c_id varchar(20) No PK
c_name varchar(20) Yes
c_address varchar(45) Yes
gender varchar(20) Yes
annual income decimal(8,2) Yes
c_phno varchar(20) Yes
vin varchar(20) Yes FK

11 dealer d_id varchar(20) No PK


d_name varchar(20) Yes
d_address varchar(45) Yes
vin varchar(20) Yes FK

12 inventory i_id varchar(20) No PK


vin varchar(20) Yes FK
d_id varchar(20) Yes FK
arrival_date date Yes
exit_date date Yes
References

instructor

You might also like