You are an IT Officer and you have been asked to keep records of any intervention performed at different locations. You should first keep records of your ICT equipment which are found at different remote location like Schools, Offices and libraries. After that all intervention done upon request should be updated in the database through your web application.
Create an ERD with the following Entities and Attributes.
Entity: USERS - Attributes: Name of User, Username, Password, e-mail address, mobile number, school ID, user type (Admin or Standard), Security Question, logged
Entity: Equipment - Attributes: School ID, Serial Number, Equipment Description, Equipment Make, Procurement (Sponsored or Purchased)
Entity: School - Attributes: School ID, Location (Class or Office), Name, Address, mobile Number
Entity; Write OFF - Attributes: Equipment ID, School ID, Reason(Damaged, Obsolete or Beyond Economical Repair), Status (Pending Discard, Discarded)
Entity: Transfer of equipment - Attributes: School ID, Equipment ID, Location, Reason for Transfer.