database table for school management timetable

Question

1.00/5 (2 votes)

See more:

I am working on .net and using C#. Only tell me what will be the database table means attributes or column names for time table.

Posted 3-Sep-12 22:46pm

shoniya

Updated 3-Sep-12 23:27pm

v5

Add a Solution

Comments

Mehdi Gholam 4-Sep-12 4:49am

It is very hard to understand what you are asking, edit your question and supply more information.

Sandeep Mewara 4-Sep-12 4:57am

This is not a well framed question! We cannot work out what you are trying to do/ask from the post. Please elaborate and be specific.
Use the "Improve question" link to edit your question and provide better information.

lukeer 4-Sep-12 5:05am

Use proper english spelling.

Richard MacCutchan 4-Sep-12 5:07am

I have no idea what language the bold characters are supposed to be, but if you expect a sensible answer then try using proper words and not this childish txtspk.

AmitGajjar 4-Sep-12 5:17am

That's called database designing. you need to do it yourself. or you should learn from your teacher.

shoniya 4-Sep-12 5:23am

That I also know thank you very much for your help.

AmitGajjar 4-Sep-12 5:26am

Look this is really basic step for software development. you need to improve this skill by practicing. if someone will give you DBDesign then next time again you need someone help to do that. Anyway best of luck.

shoniya 4-Sep-12 5:31am

I am getting confused I have already created the table but I am not getting it.

AmitGajjar 4-Sep-12 5:33am

great! if you have created the database then show it to your senior/teacher or in CodeProject for more suggestions. that will definitely work.

shoniya 4-Sep-12 5:39am

I have already created a time table project separately but our sir is telling that it should have one database table and when you will click on the generate button it should show you the time table and that is the thing i am not getting. Can u please help me out.

VIPR@T 4-Sep-12 5:29am

Why change the question???

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

VIPR@T · Answer 1 · 2012-09-03T23:13:00

Hi,

Firstly there should be one table which contains the details of everyday periods.
I mean it should be like this.
PID(PK),Date, Time, PeriodNo, AssignTo(FK)(TeacherID)

Second Table Which contains Teacher Master. Which contains all the teachers.
TID(pk), TeacherName

Third Table. Schedule Teacher.
STID(pk), Date, time, PID(FK), IsAvailable(bool)

Now Firstly you have to make procedure to assign every day`s periods to available teachers.
After that you have to check that which are the free periods? and which are the free teachers, who are not assigned. and then you can assign that free periods to that free teachers.

I hope you will get some idea what you have to do. i have just taken here only 3 transaction table. But as per requirement you have to do changes. Using this example i am trying to give you some idea how can you design your tables.

I hope it might be help you.

Thanks,
Viprat