Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rahul8346
Starting Member
21 Posts |
 Posted - 2006-05-12 : 08:18:16
|
| Hi, I am preparing the Help Ticket for each an every Asset in my Application. 1) I wish to relate the HelpTicket with the S/W Asset but there are multiple S/w license present with a S/W Asset..i.e, they have 1-Many relationship 2) Each pair of S/W License and S/W Product is considered an Asset so i need to store some composite id for that to Uniquely Identify it.Consider my table,Table--------------Software ---Similarly all Type of Assets Like H/W...--------------Productid [PK] ------------------------HelpTicket_RelatedAsset------------------------ticketid [FK]assetCategoryID [FK] ----Type Of Asset Like S/WTypeid [FK] ----SubType of Asset Like for S/W it can be System program, Application programProductid [FK] ----Particular AssetId as SoftwareProdIDOptions1------------1) I can create an extra field in HelpTicket_RelatedAsset as Licenseid , which will be empty for other Assets 2) I create an unique assetid which is not there and will be require modify the existing code for H/W and Peripherals (In the Sense create an assetID whenever an Asset is added to the Application)Is There Any other Way out.........Any Sugggestion would be HelpFull Txs for reading.... |
|
|
|
|
|
1-Many Relationship Problem