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.
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.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images