How to deal with too many database tables of software engineering papers

Personally, I think you need to create a new table, which is the sales table tb_sell.

Tb_sell (sales logo, car number, customer number)

In this way, it can be said that the car table and the customer table are linked together. You should know how to insert, delete and view tables.

To find data, you can find the corresponding information through table association.

For example:

Tb _ Vehicle data: (1, "BMW", "Red", "100.00")

(2) "Mercedes", "Yellow" and "200.00")

Tb _ Client data: (1, "Zhang San", "123456790 1", "XX")

(2) "Li Si", "1234567890 1", "xx")

Tb_sell data: (1, 1, 1)

(2, 1,2)

(3,2, 1)

SQL text:

Select tb_car. *，tb_client。 *

From tb_sell

Add tb_car to the left of TB _ sell.car _ no = TB _ car.car _ no.

Connect TB _ client to the left on TB _ sell.client _ no = TB _ client.client _ no.

Where 1 = 1