Suguo group in ma on shan have multiple community store: store attributes of each community have store number, name,
Address, etc.; Each community store selling a variety of goods, each commodity attribute has the number of goods,
Name, unit price, etc.; Each community shop hire several assistants, every clerk properties have number, last name
Name, gender, telephone and so on, each store sales of a product have a certain profit; Each store
Member can only work in a shop, store each community has a manager to manage,
1. According to the actual circumstance of the semantic and draw a e-r diagram, draw the properties and requirements in the picture indicate the
The type of contact;
2. Converting e-r diagram into relation model, and points out that the relationship between each model of the main code and external code, (
Note: the main code with an underscore, and the code expressed with wavy lines),