In the first half of 2021, database system engineers afternoon Zhenti and answer analysis

In the first half of 2021 , database system engineers afternoon Zhenti and answer analysis

Question 1 (15 points in total)

A community vegetable group buying website needs to develop an information system in order to standardize the process of receiving and dispatching goods and to facilitate inquiries about customer orders. Please describe the database design of the system according to the following requirements.

[Description of Requirement]

(1) Record the information of the vegetable supplier, including the supplier number, address and a telephone number.

(2) Record the information of the community group buying point, including the group buying point number, address and a phone number.

(3) Record customer information, including customer name and a phone number. Customers can place orders at different community group buying points and do not directly contact the vegetable supplier.

(4) Record customer order information, including order number, group purchase point number, customer phone number, order content and date.

Conceptual model design

Based on the information collected in the requirements phase, the designed entity connection diagram (incomplete) is shown in Figure 1-1.

The afternoon answer and analysis of database system engineers in the first half of 2021

Test Question 1 (15 points in total) Click this link to view the real test analysis video

Question 1 (6 points)