System will be developed for the teacher and the group of students. The goal is to retrieve and manage information of teaching material storage locations. Report of teaching material locations ordered by location must be retrievable.
General description
System will be stored to teachers network drive. First version does not include external connections so students cannot add teaching material locations. MariaDB will be used as a database product. Teacher IDs and names can be retrieved from student register system. Permissions for database usage are defined with functions of DBMS (separate tables for storing user account information is not required).
Functions
Required
Teacher information (ID, name, department, homepage etc.) management
Location information (name) management
Teaching material information (name and accurate location address) management
Report of teachers (name, department) teaching materials (name, location address) ordered by location name
Optional
View for students to see the locations of teaching material
External connections
No connections to other systems
Other properties
Performance: response times for basic PC (Windows 10, 8 GB RAM and a modern processor) when retrieving 10000 lines of data should be under one second. Security: Only teachers should have permissions to modify the data in database. Students can have read permissions for the system on the future versions of the system. Usability: Database data will be accessed and manipulated through web-based user interface developed with the database.