System Design And Development

Entity Relationship diagram.

 

Event Table

Events	Trigger	Source	Activity	Response	Destination
1.User Registration	Create new  record	Admin	1.Look up for User 2.Check  for availability 3.Create user 4.Update user list 5.Generate New user	Registration	User
2.A User request asset	New User	Admin	1.Create a new User record 2.View the asset request	2.View the request	User
3.Supplier Registration	Create new  record	Admin	1.Look up for Faculty 2.Check  for batch availability 3.Create Faculty 4.Update Supplier list 5.Generate New Supplier	Registration	Supplier
4.Receiver Registration	Create new  record	Admin	1.Look up for Receiver 2.Check  for Receiver availability 3.Create Receiver 4.Update Receiver list 5.Generate New Receiver	Registration	Receiver
5.Enter Item details	Item details	User	Look for Available Item	User enters item details	Database
6. Enter Asset details	New Asset	User	Create the record new Asset	New Asset is Added to database	Database
7. Enter Delivery details	Enter Delivery details	User	1.Check for Delivery details	Store Delivery details	Database