Antonionguyen
14-04-2004, 23:20
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...
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...