Relationship / ERD according to data

[nyt1972]

Dear Experts,

Please help me creating an ER Diagram according to the following data, I am learning database programming please help.

Data is as below:

Students data

Class : Section : Session : Admission No : Roll No : Name : FName
Play Group A 2011 123 1 abc xyz
Play Group A 2011 124 2 cdf ghq
Play Group A 2011 125 3 def ryz

Nursary A 2011 213 1 ghh ddd
Nursary A 2011 214 2 jjj ttt
Nursary A 2011 215 3 rrr ppp

Nursary B 2011 315 1 ghh ddd
Nursary B 2011 316 2 jjj ttt
Nursary B 2011 317 3 rrr ppp

etc.

Please help, hope you understand

[goodguy]

Class : Section : Session : Admission No : Roll No : Name : FName
Play Group A 2011 123 1 abc xyz
Play Group A 2011 124 2 cdf ghq
Play Group A 2011 125 3 def ryz

Nursary A 2011 213 1 ghh ddd
Nursary A 2011 214 2 jjj ttt
Nursary A 2011 215 3 rrr ppp

Nursary B 2011 315 1 ghh ddd
Nursary B 2011 316 2 jjj ttt
Nursary B 2011 317 3 rrr ppp

Table Classes: ClassID, ClassName, Section
Table Sessions: SessionID, SessionName
Table Students: StudentID, AdmissionNo, FirstName, LastName
Table Classrooms: StudentID, ClassID, SessionID, RollCallNo

You do not need a table for Sections as they fit well into Classes table.
All three tables have foreign keys in table Classrooms.
RollCallNo is classroom-specific, do NOT include it in Students table.
You can show your desired output (including Section) via a query joining the Classrooms table to the three foreign key tables.
Classrooms is a junction table because Students and Classes have a many-to-many relationship.

[nyt1972]

Thanks for the reply dear, attached is the image of my tables relationships, pls check, is it ok?

[goodguy]

Perfect. Continue.

[nyt1972]

When I enter Student Record it say, duplicate values in the index, primary key or relationship.....

[goodguy]

That means you are trying to enter a record whose primary key (or index or relationship, as the message says) conflicts with that of an existing record. What happens when you try a different record?

[nyt1972]

problem is with StudentID, should I enter ID myself or computer with generate automatically if I enter new record.

[goodguy]

If the field's datatype is AutoNumber, then Access will supply the value, you do not have to specify it.