I would like to commission the creation of a database, diagram and queries for an information technology device management system.
The database is to include entities such as:
- admin and employee accounts
- Devices should be divided into categories - barcode (numerically) - product name - quantity - status (whether it is assigned to someone or not) - location
- Admin can add locations to store devices and view the equipment assigned to all employees
- Returns history - admin can see who took what and when, and if and when they returned it
This is to be a fully functional database to be placed in Phpmyadmin right away. ERD diagram can be made in anything.
I would also ask you to list SELECTs to make the database work (displaying assignment history, assignment time, etc.) and Functions to add new storage locations for devices