473,320 Members | 1,832 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Maybe just a little redundancy?

Hello Everyone,

I have the following 3 tables setup:(Thanks Marsh!)

Students Table
StudentID (1 to many)
Last
First
Class (Class Name)
Period ( 1 to 8)

Lessons Table
LessonID (1 to many)
LessonType (E,N,T) Effort, Notes, Tests
LessonDescr
Note (extra time, etc.)
Grade

Junction Table
JunctionID
StudentID
LessonID

I can directly add lessons for each student using the SubDatasheet in
the Students Table.
I could also use a Form/SubForm but the SubDatasheet method is quicker

I am the only one using the database.

The fields in the Lessons table are all Constants except Note & Grade

If a student is absent and needs more time I will note the additional
days in the Note field
A student can increase his Grade for a lesson under some
circumstances.

How can I use the Same SubDatasheet in the student table to not only
assign a lesson to a student but ALSO to enter data in the Note &
Grade Fields?
I know this might create some redundancy but speed of entry is my
first priority.

All suggestions & directions are appreciated!

Dave
Feb 11 '07 #1
4 1825
since the Grade and Note fields store data about a particular lesson for a
particular student, those fields properly belong in the junction table -
*not* in the Lessons table, which should only have fields that describe a
lesson, without any data about any student(s).

hth
"Dave White" <dj*****@snet.netwrote in message
news:sg********************************@4ax.com...
Hello Everyone,

I have the following 3 tables setup:(Thanks Marsh!)

Students Table
StudentID (1 to many)
Last
First
Class (Class Name)
Period ( 1 to 8)

Lessons Table
LessonID (1 to many)
LessonType (E,N,T) Effort, Notes, Tests
LessonDescr
Note (extra time, etc.)
Grade

Junction Table
JunctionID
StudentID
LessonID

I can directly add lessons for each student using the SubDatasheet in
the Students Table.
I could also use a Form/SubForm but the SubDatasheet method is quicker

I am the only one using the database.

The fields in the Lessons table are all Constants except Note & Grade

If a student is absent and needs more time I will note the additional
days in the Note field
A student can increase his Grade for a lesson under some
circumstances.

How can I use the Same SubDatasheet in the student table to not only
assign a lesson to a student but ALSO to enter data in the Note &
Grade Fields?
I know this might create some redundancy but speed of entry is my
first priority.

All suggestions & directions are appreciated!

Dave

Feb 11 '07 #2
oops, sent too fast and didn't finish my thought:

btw, this is not "redundant" data. if StudentA and StudentB happen to get
the same grade for an assignment, that's not redundant or duplicate data -
it just happens to be the same grade value for two different assignments
submitted by two different people (unless one copied from the other! <g>).
redundant data would be, for instance, storing StudentA's name as hard data
in every record in the junction table, rather than properly storing it once
in the Students table and referring to that record with a foreign key in the
junction table.

hth
"tina" <no****@address.comwrote in message
news:QJ*******************@bgtnsc05-news.ops.worldnet.att.net...
since the Grade and Note fields store data about a particular lesson for a
particular student, those fields properly belong in the junction table -
*not* in the Lessons table, which should only have fields that describe a
lesson, without any data about any student(s).

hth
"Dave White" <dj*****@snet.netwrote in message
news:sg********************************@4ax.com...
Hello Everyone,

I have the following 3 tables setup:(Thanks Marsh!)

Students Table
StudentID (1 to many)
Last
First
Class (Class Name)
Period ( 1 to 8)

Lessons Table
LessonID (1 to many)
LessonType (E,N,T) Effort, Notes, Tests
LessonDescr
Note (extra time, etc.)
Grade

Junction Table
JunctionID
StudentID
LessonID

I can directly add lessons for each student using the SubDatasheet in
the Students Table.
I could also use a Form/SubForm but the SubDatasheet method is quicker

I am the only one using the database.

The fields in the Lessons table are all Constants except Note & Grade

If a student is absent and needs more time I will note the additional
days in the Note field
A student can increase his Grade for a lesson under some
circumstances.

How can I use the Same SubDatasheet in the student table to not only
assign a lesson to a student but ALSO to enter data in the Note &
Grade Fields?
I know this might create some redundancy but speed of entry is my
first priority.

All suggestions & directions are appreciated!

Dave


Feb 11 '07 #3
On Sun, 11 Feb 2007 16:51:11 GMT, "tina" <no****@address.comwrote:
>oops, sent too fast and didn't finish my thought:

btw, this is not "redundant" data. if StudentA and StudentB happen to get
the same grade for an assignment, that's not redundant or duplicate data -
it just happens to be the same grade value for two different assignments
submitted by two different people (unless one copied from the other! <g>).
redundant data would be, for instance, storing StudentA's name as hard data
in every record in the junction table, rather than properly storing it once
in the Students table and referring to that record with a foreign key in the
junction table.

hth
"tina" <no****@address.comwrote in message
news:QJ*******************@bgtnsc05-news.ops.worldnet.att.net...
>since the Grade and Note fields store data about a particular lesson for a
particular student, those fields properly belong in the junction table -
*not* in the Lessons table, which should only have fields that describe a
lesson, without any data about any student(s).
Hi Tina,

Worked like a charm!

Thanks for your help!
Dave
Feb 11 '07 #4
you're welcome :)
"Dave White" <dj*****@snet.netwrote in message
news:k4********************************@4ax.com...
On Sun, 11 Feb 2007 16:51:11 GMT, "tina" <no****@address.comwrote:
oops, sent too fast and didn't finish my thought:

btw, this is not "redundant" data. if StudentA and StudentB happen to get
the same grade for an assignment, that's not redundant or duplicate
data -
it just happens to be the same grade value for two different assignments
submitted by two different people (unless one copied from the other!
<g>).
redundant data would be, for instance, storing StudentA's name as hard
data
in every record in the junction table, rather than properly storing it
once
in the Students table and referring to that record with a foreign key in
the
junction table.

hth
"tina" <no****@address.comwrote in message
news:QJ*******************@bgtnsc05-news.ops.worldnet.att.net...
since the Grade and Note fields store data about a particular lesson
for a
particular student, those fields properly belong in the junction
table -
*not* in the Lessons table, which should only have fields that describe
a
lesson, without any data about any student(s).

Hi Tina,

Worked like a charm!

Thanks for your help!
Dave

Feb 12 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Warrick FitzGerald | last post by:
Hi Guys, I'm missing something in the MySQL clustering design. In the basic design outlined in the How-To, there are two NDBD nodes, a manager node and a MySQL node (ndb). If I now write an...
9
by: Colin McGuire | last post by:
Hi, I have an report in Microsoft Access and it displays everything in the table. One column called "DECISION" in the table has either 1,2, or 3 in it. On my report it displays 1, 2, or 3. I want...
4
by: Carlos | last post by:
Hello Forum, I would appreciate it if you could recommend software to build redundancy in my application (my application stores data in a PostgreSQL v7.3.x database running in Linux RedHat) The...
28
by: liorm | last post by:
Hi everyone, I need to write a web app, that will support millions of user accounts, template-based user pages and files upload. The client is going to be written in Flash. I wondered if I coudl...
17
by: TC | last post by:
In the past I always regarded user/group security as fairly tight. It is tricky to implement, but once implemented properly, it can't be cracked except through a dedicated effort. Recently,...
7
by: brucepayne | last post by:
what is the query for reduce redundancy in table plz help me
2
by: PeterAlt | last post by:
Hello all! This is my first post here. I've been going crazy lately trying to master the art of working with and creating my own objects with Javascript. I see the HUGE power potential of object...
1
by: forrestgump | last post by:
I am looking to create a statutory redundancy calculator (UK) in either access or excel. I need to calculate large batches of employees statutory redundandancies. Has anyone created one before...
3
by: mfareed | last post by:
Can somebody help me with the CRC (Cyclic Redundancy Code) algorithm implementation given below: There is a three byte packet header. <--------1st byte-----><--------2nd...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.