Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Relationship values duplicating

Hello,

I am creating a database, for enroll register but I have some questions.

I attached the relationship between the tables.

What is supposed to do are: 1- Register of the student. 2- Register for a program. 3- Register for a semester. 4- Register for classes.

So, one student can register in one program. One program can have more than one semester. Each semester can have more than one classes.

What is happening is the data are duplicating. When we register the classes for the second semester, for example, they duplicate the information with the information from the first semester. For example: Semester 1
Class A 40 credits 40 hours Class B 40 credits 40 hours Class C 40 credits 40 hours

Semester 2 Class D 50 credits 50 hours CLass E 50 credits 50 hours Class F 50 credits 50 hours

The query view shows: Semester 1 Class A 40 credits 40 hours Class B 40 Credits 40 hours Class c 40 Credits 40 hours Class D 50 Credits 50 hours Class E 50 credits 50 hours Class F 50 credits 50 hours

So, all data is duplicated in each semester. When a look just the table information, the information is correct.

So, I dont know how to fix it. If anybody can help, Ill appreciate.

Thank you,

C:\fakepath\Screen Shot 2017-12-11 at 9.34.28 AM.png

click to hide/show revision 2
None

Relationship values duplicating

Hello,

I am creating a database, for enroll register but I have some questions.

I attached the relationship between the tables.

What is supposed to do are: 1- Register of the student. 2- Register for a program. 3- Register for a semester. 4- Register for classes.

So, one student can register in one program. One program can have more than one semester. Each semester can have more than one classes.

What is happening is the data are duplicating. When we register the classes for the second semester, for example, they duplicate the information with the information from the first semester. For example: Semester 1
Class A 40 credits 40 hours Class B 40 credits 40 hours Class C 40 credits 40 hours

Semester 2 Class D 50 credits 50 hours CLass E 50 credits 50 hours Class F 50 credits 50 hours

The query view shows: Semester 1 Class A 40 credits 40 hours Class B 40 Credits 40 hours Class c 40 Credits 40 hours Class D 50 Credits 50 hours Class E 50 credits 50 hours Class F 50 credits 50 hours

So, all data is duplicated in each semester. When a look just the table information, the information is correct.

So, I dont don't know how to fix it. If anybody can help, Ill I'll appreciate.

Thank you,

C:\fakepath\Screen Shot 2017-12-11 at 9.34.28 AM.png