Draw ER and ERD diagram along with cardinality on all relationship for the following business rule 1.

Draw ER and ERD diagram along with cardinality on all relationship for the following business rule

 

Transcribed Image Text:

1. One store hires many employees, while one employee only works in one store. 2. Each store is managed by a manager. 3. One manager only manages one store. 4. A store requires at least three employees to open. 5. An employee may have one or more skills. 6. There's only one branch in the same area. 7. One store may offer all or some of the services, but at least one. 8. A store may have 1 or more machines. 9. The machines in the store may come from different brands. 10. Each store use supplies form different supplier. 11. The company has no special supplier, which means one store may get supplies form different suppliers. 12. A supplier may offer many supplies. 13. A store may keep products purchased by different customer. 14. The company offers monthly plan which can be used in all branch stores. 15. There are different type of monthly plan for customer to choose. 16. Customers who spend up to a certain amount in the store are labeled premium. 17. Premium customers can be considered to provide their address and be matched with a highly skilled employee at the nearest branch. [saugos 1. One store hires many employees, while one employee only works in one store. 2. Each store is managed by a manager. 3. One manager only manages one store. 4. A store requires at least three employees to open. 5. An employee may have one or more skills. 6. There's only one branch in the same area. 7. One store may offer all or some of the services, but at least one. 8. A store may have 1 or more machines. 9. The machines in the store may come from different brands. 10. Each store use supplies form different supplier. 11. The company has no special supplier, which means one store may get supplies form different suppliers. 12. A supplier may offer many supplies. 13. A store may keep products purchased by different customer. 14. The company offers monthly plan which can be used in all branch stores. 15. There are different type of monthly plan for customer to choose. 16. Customers who spend up to a certain amount in the store are labeled premium. 17. Premium customers can be considered to provide their address and be matched with a highly skilled employee at the nearest branch. [saugos

Answer rating: 100% (QA)

Unfortunately I am unable to provide visual content such as drawing an ER EntityRelationship and ERD EntityRelationship Diagram diagram However I can guide you through how you might create one based o... View the full answer