Describe 3 tables that might be used to store information for an online retailer system such as Amazon. For each table, include its schema, its PK, and a one-sentence description of the data stored.

   

Transcribed Image Text:

Car_option Serial no Option_name Option_price Notes: varchar2(10) varchar2(25) number(6,2) Car Serial_no Manufacturer Model Base_price Sale Serial_no Salesperson_id Sale_date Sale_city Sale_price varchar2(10) varchar2(25) varchar2(25) number(8,2) varchar2(10) varchar2(10) date varchar2(15) number(8,2) Salesperson Salesperson_id Name Email varchar2(10) varchar2(20) varchar2(20) dbdiagram.io This set of tables make up a database that keeps track of automobile sales in a car dealership. In the Car option table, Serial No is a foreign key which references the primary key of the Car table. Option name refers to some optional equipment installed on an automobile. Option price refers to the price of an option installed on a particular car; the same option could be priced differently for different cars. In the Sale table, the Sale price records the price at which a car was sold, which could be same or different from the Base price of that car + the total Option price of all options installed on that car. The Sale date and Sale city represent the time and place of the sale. Car_option Serial no Option_name Option_price Notes: varchar2(10) varchar2(25) number(6,2) Car Serial_no Manufacturer Model Base_price Sale Serial_no Salesperson_id Sale_date Sale_city Sale_price varchar2(10) varchar2(25) varchar2(25) number(8,2) varchar2(10) varchar2(10) date varchar2(15) number(8,2) Salesperson Salesperson_id Name Email varchar2(10) varchar2(20) varchar2(20) dbdiagram.io This set of tables make up a database that keeps track of automobile sales in a car dealership. In the Car option table, Serial No is a foreign key which references the primary key of the Car table. Option name refers to some optional equipment installed on an automobile. Option price refers to the price of an option installed on a particular car; the same option could be priced differently for different cars. In the Sale table, the Sale price records the price at which a car was sold, which could be same or different from the Base price of that car + the total Option price of all options installed on that car. The Sale date and Sale city represent the time and place of the sale.