Make a small equipment management system using a database

Topic 1. The types of entities included in the Equipment Management Information System (EMIS) are: n Fixed Assets (Asset Number, Asset Name, Model Specification, Unit of Measurement, Value, Manufacturing Plant, Date of Exit) n Department (Department Number, Department Name, Person in Charge) n Depreciation Slip (Depreciation Slip Number, Annual Depreciation Rate, Annual Depreciation Amount, Date of Commencement of Use, Full Useful Life, Number of Years in Use, Years Remaining Useful Life) n Major repair order (repair order number, date of repair, time limit for repair, cost of repair, person in charge) n Internal transfer order (transfer order number, date of transfer, transfer out department, transfer in department), i.e., the equipment is transferred from one department to another n Scrap order (scrap order number, date of scrapping, person in charge), meaning that the equipment has reached the end of its useful life and is thrown to the scrap warehouse n Cleanup order (cleanup order no. original value of the asset, the amount of accumulated depreciation, the amount of cleanup), cleaned out of the scrap warehouse. n Specific operations included in the Equipment Management Information System: n Self-supplementation of the links between the entities n Input of data, no less than 10 rows of data for each table, and the data must be meaningful n Realization of the process of scrapping the equipment n Realization of the internal transfer of the equipment n Statistics on the cost of overhauls that have been carried out for the fixed assets n Listing of the two basic tables of the Insert, update and delete operations (1 example each) n Add 8 to 10 SQL operations of your own, e.g., value of fixed assets for the Information Branch, list of all "computer" equipment, etc.