Có ai giúp mình vẽ cái ER Diagram for this one...

[Antonionguyen]

The organisation has many departments
Department has many pieces of equipent
Equiment is assigned to only one department
Computer Service Management(CSD) needs to know what department the equiment has been in and when
Equipment is assigned one location
An Upgrade/Change Equipment Request can refer to more than and one piece of equipment
CSD staff can work on many Upgrade/Change Equipmentbut are restrict no more than 20 outstanding request at any one time
An Upgrade?change Equipment is assigned to only one staff member.
A priority is assigned to an Upgrade/change Equipment based on CSD Priority Guidelines Document
A piece of equipment can have more than one Upgrade/change Equipment
E is iđentifie by asset number and uses the following format when, where...is the number of that piece of equipment
There are 5 department: Sales, Finance, Marketing, Computer Service and Technician

Vui lòng show cho mình cai relationship, cardinality, primary key field attribite and what changes would you have to make to this diagram so that it can be implemented in an relation database eg SQL Server
Thank...

[phatnq2003]

The organisation has many departments
Department has many pieces of equipent
Equiment is assigned to only one department
Computer Service Management(CSD) needs to know what department the equiment has been in and when
Equipment is assigned one location
An Upgrade/Change Equipment Request can refer to more than and one piece of equipment
CSD staff can work on many Upgrade/Change Equipmentbut are restrict no more than 20 outstanding request at any one time
An Upgrade?change Equipment is assigned to only one staff member.
A priority is assigned to an Upgrade/change Equipment based on CSD Priority Guidelines Document
A piece of equipment can have more than one Upgrade/change Equipment
E is iđentifie by asset number and uses the following format when, where...is the number of that piece of equipment
There are 5 department: Sales, Finance, Marketing, Computer Service and Technician

Vui lòng show cho mình cai relationship, cardinality, primary key field attribite and what changes would you have to make to this diagram so that it can be implemented in an relation database eg SQL Server
Thank...

Theo ý bạn là bạn muốn có luôn cả bộ database structure và diagram luôn hở? Dzậy có dzì trao đổi không? Nói dzậy thôi tùy lòng hảo tâm. Nếu bạn có thể chờ được trong ít lâu thì tôi sẽ attach cho bạn một file Word để bạn tham khảo. OK :yes:

[Antonionguyen]

Trời...tui đợi cả tuần rùi mà chẳng ai trả lời hết...đành phải liều làm thử nhưng mà không chắc chút nào hết...Bởi vì cái phần entities là voi ER diagram là hai câu hỏi quan trọng nhất để làm những câu khác...Dù sao thi cũng cảm ơn đồng chí đã xã thân cứu chiến hữu...Thứ hai này nộp bài rùi...nhưng mà nếu có giúp được thì cũng rất mừng...(để tham khảo còn hơn là ngày nào vô mà không thấy cao thủ nào trả lời...Đúng là nhân tài như lá rụng mua thu...Còn chuyện nữa nếu you có chết thì nhớ cho tui biết chỗ you yên nghĩ nhe...để tui còn đi đào mộ lấy cái com piu tơ nữa chứ..I am jokoing...haha...bye...