Create a simple SQL database structure and create a MATLAB interface that allows the user to insert new students and edit them if necessary.
Create also a sub module that calculates the number of "students creations" by room, daily averages. (Of course the data should be inserted using SQL commands)
Database, interface code, etc should be delivered with working instructions
Database using MySQL.
System of access to the labs
Information about users,labs,departments, buildings.
A user can have more than 1 card of access.
The permissions can be admin by special users with different levels : Administration, Department responsible and lab responsible.
The users can be referenced to departments, categories groups, teacher or not, and department.
Complete as you wish.
a) Diagram ER and data base schema
b) Database in MySQL (deliver a script to run in mysql)
c) Insert some data (deliver a script to run in mysql)
d) Implementation of 5 queries (deliver a script to run in mysql)
the b)c) can be a dump script of the database
e) Implement Matlab interface to insert students and edit them (if authorized)
f) create a matlab function to call a SQL query to get the number of entries by lab, daily averages
If there is any configuration to be done in MySQL or Matlab it should be clearly explained.
any doubts let me know before bid. The budget is around 50$ and I need it in 4 hours.