should i use a database table for that??

Question

I'm creating a website for a school. it has three type of user 1. admin, 2. guardian, 3 teacher. im trying to implement a block system for the teacher. which will block teachers give attention results after a certain time. and the time will be changeable by the admin..my question should i create a table to store that time??or is their any other way to store that time??

Answer 1

Ayan Poddar First of all, I supposed you want a table with multiple teachers that had a different time value, but anyway, I still think you should store that separate time value in a table.

I guess you probably want to store the time value in a text file, but since you are using a database for the rest of your project, then I think it's a bad idea to mix it with a text file. It would also be much easier for the admin to update the time value instead of messing with a text file.

Answer 2

i decided to store that time inside a table

Answer 3

This depends on whether it's easy to extend and adapt to change in the future.
You know, the database is a file too.

Answer 4

I'm SQL so it's not that difficult. But is their any other option??

Answer 5

I would say, you should create a table to store that time, and then you should create a relation to the table of teachers.

Answer 6

but Quantum is it a really good approach to store a time in a database . because to store a value you need table. and store a single value in a table sounds silly im sorry if im wrong.. but is their any other way and what would be the professional way imean industrial way do it??

Answer 7

Ayan Poddar

I think you have to setup a database for this project. Some of the reasons for the database are that you can generate reports from the data. They might need additional functionality or features in future, having a db will allow you to easily add the additional features.

If you need an option for which type of db to use, try Mysql (free) or Postgres SQL (Facebook use it).

Try not to focus on the time issue, let's say you create a table called my table with a seed column (unique incremental Id), a time column, a user and a datestamp.

You can then focus on the seed column to know which was first.

Answer 8

but that concept of creating a table for a date is that really make sense??

Answer 9

Ayan Poddar

That is my recommendation.