Questions of management information system based on the following design data in table structure field name
Customer name zhang phone 12345678910 addresses guangxi
Product price specifications quantity
The TV 3000 40 inch 1
Washing machine 1000 8 kg 2
The order number 123456 order payable to name the shop order time order total price 5000 yuan in 2000

CodePudding user response:

The customer (number, the name and address)
The product (product_name, price, specifications)
The order (order_ID, name, product_name, time, quantity, total)