You are required to create an ER Diagram as an ICT Technician to keep records of your ICT equipment from various locations (Schools, Colleges, Finance Dept, HR Dept, Registry). You need to keep records of the computers, printers and other peripherals. Serialnumbers of devices should be the Primary key and Users (CLA) manipulating devices as Foreign Key. - Computer Lab Auxilaries (CLA) are responsible only for filling entries for the devices but cannot modify entries. They should log in the system with a credential. - The ICT Technician has administrator access and can alter entries. 1. Create the ER Diagram based of information above. 2. Give the MySQL codes for creating the necessary tables for th DB. Please give a clear explanation of the ER Diagram for its Entities and Attributes and also THE MYSQL Codes.
You are required to create an ER Diagram as an ICT Technician to keep records of your ICT equipment from various locations (Schools, Colleges, Finance Dept, HR Dept, Registry).
You need to keep records of the computers, printers and other peripherals. Serialnumbers of devices should be the Primary key and Users (CLA) manipulating devices as Foreign Key.
- Computer Lab Auxilaries (CLA) are responsible only for filling entries for the devices but cannot modify entries. They should log in the system with a credential.
- The ICT Technician has administrator access and can alter entries.
1. Create the ER Diagram based of information above.
2. Give the MySQL codes for creating the necessary tables for th DB.
Please give a clear explanation of the ER Diagram for its Entities and Attributes
and also
THE MYSQL Codes.
Step by step
Solved in 2 steps with 1 images