The universal electronic corporation for manufacturing and selling electronic equipments has decided via their steering committee to build a database for their equipments and stores. The company has many stores that have many employees work in. They want to keep track of all equipments such as equipment Id, description, and quantity-on-hand. Their production line produces two types of equipment, electronics, and raw material. The raw material has an expected lifetime. The electronics have number of years of warranty. In addition, they desire to store some information about their customers such as Customer name, address, and phone number for future reference. They also have many employees working in the company, some of these workers sell equipment and others are working in the factory for manufacturing. Hence, they did classify their employee into two categories, salesperson, and engineers. The equipment consists of many parts that can be supplied by several suppliers. The customer can order many equipments and an equipment can be ordered by many customers, therefore, the order date and the status should be maintained.

1.Design the ERD and EER?
2.Define all types of attributes?

السلام عليكم ،
هذة مشاركة تحليلة سريعه لسؤالك وتم اعداد ال ER Diagram .
ارجوا المراجعه والمشاركه من الزملاء بالمنتدى .
شكرا لكم .

equipments.rtf

جميله اوى مرسى

شكرا جزيلا