Here I will explain the functionality of the database and how the tables will be connected:
The user table will connect to the other tables with the userid , this table will display the users information such as their name, pnumber, subfolderid and the superuser number. The aim of the superuser is to identify whether the individual is a student or lecturer, I have implemented this feature in order to create a query where superuser 1 (lecturer) can view all student files and folders.
The user table will connect to the other tables with the userid , this table will display the users information such as their name, pnumber, subfolderid and the superuser number. The aim of the superuser is to identify whether the individual is a student or lecturer, I have implemented this feature in order to create a query where superuser 1 (lecturer) can view all student files and folders.
The subfolder table will display information such as the folderid , folder name, the timestamp (to no overwrite any other files) and the userid that connects to the user table. The number 0 within the subfolderid will represent the root folder each student has here they can save files or create other folders to withhold them.
The file table will store the individual files within the subfolder, the fileid and filename will identify the individual file, they will then use the userid and subfolderid to connect to the other tables. This will also save the file within the subfolder or any others within.
The permissions table is to identify what users can access a specific folder, this is mainly for lecturers to be able to see students work and for those working on group projects to be able to access the same folder.
No comments:
Post a Comment