Tables & Forms

[John]

Hello all,

I recenty designed a school database with three tables.

tstudent table
StudentID PK
Lname
Fname
etc...

tclass table
ClassID PK
StartDate
EndDate
etc...

tstudentclass table
StudentID PK
ClassID PK
FundingSource Combo box
Enrolled YES/NO datatype

Now, I need to decide if I should put the grade's fields into the
studentclass table or a seperate table called grades. Here is the example:

I have Gr1, Gr2, Gr3.................Gr18 and a FinalGrade. Gr1 to Gr18
are tests and homeworks. However, FinalGrade is the final grade for the
course. Also keep in mind that the Gr's will vary on each class. For
example Math 101 might only require the fields Gr1, Gr2, Gr3. But Math 102
might require Gr1 to Gr6. Can you please tell me in detail how I should
design the structor of the table too. Step by step would be great! Thank
you.

 

[Destin Richter]

John, what kinds of grades are you recording? Numbers or letters? If
numbers, you don't need a separate table. The grade field would go in your
studentclass table. Email me directly with more questions if you have them.
Feel free to send your database as an attachment if you'd like me to look at
it directly.

Destin Richter
(e-mail address removed)

 

[John]

The grades are Letters. Now, can you please explain in step by step, How to
proceed. Thank you.

 

[Destin Richter]

John, if you can email me the database, it will take me less time to explain
the approach.

Destin Richter
(e-mail address removed)

 

[John]

Destin,

With all do respect, I have many student SSN's in the database with other
personal info. This would be against the company's policy. However, I do
hope to go over this with you on the phone. Let me know if this will work.
Thank you in advance. Here is my email if interested in sending me a contact
number: (e-mail address removed).

 

[Destin Richter]

John, I understand your concern. Naturally, all data is confidential and
treated thusly. You can strip your data from the tables and just have a
dummy record in place. I'm on the phone much with existing clients and can't
set time aside for phone convesations for this now.

Destin
(e-mail address removed)