ألسلام عليكم
كيف حالكم

ممكن تساعدوني اصمم ERD
في database

هذه السؤال

Smart Mobiles Shop sells different types of mobiles to customers. A customer may place one or more orders at different time. An order contains one or more mobiles, and a mobile may be placed by one or more orders. The customer must mention the quantity of each mobile ordered.

The shop keeps the customer ID number, name, telephone number for all customers. Each order has an order number, date, and the salesman’s name.

Each mobile has a code, description, price, quantity in stock, and re-order level.

Each mobile is supplied by one supplier, and a supplier may supply one or more mobiles depend on the mobile brand. The company keeps the supplier code, name, address, contact person for all suppliers.



ولكم جزيل الشكر