Question: Created the Temporary table by importing an excel.cvs file. The import had the following tables: Temporary (returned, order, reason). However, the order attribute could not

Created the Temporary table by importing an excel.cvs file. The import had the following tables: Temporary (returned, order, reason). However, the order attribute could not be named order. Why was it necessary to use an attribute name ORDER_ID instead of ORDER?

Address (address_id, postal_code, state, region, country)

Category (category_id, category, sub_category)

Orderline (order_id), product_id)

Orders (row_id, order_id, order_date, ship_date, ship_mode, customer_id, address_id, product_id, product_name, quantity)

Product (product_id, product_name, category_id, sales, discount, customer_id)

Superstore (row_id, order_id, order_date, ship_date, ship_mode, customer_id, customer_name, segment, country, city, state, postal_code, region, product_id, category, sub_category, product_name, sales, quantity, discount, profit)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!