Need Help To create Table Design (1 Viewer)

A

akhon

Registered User.

Local time

Today, 10:52

Joined

Dec 19, 2018

Messages

27

• Jan 19, 2019

• #1

Hello Guyz I want to Create a database in which i have to entered a student details and subject Name (Not result/ marks card) and for each subject I have to give a grade on Writing and Reading. but i am confused how to create a table for this how many table i have to create for this.
therefore plss help to to create a table structure.

 

NauticalGent

Ignore List Poster Boy

Local time

Today, 01:22

Joined

Apr 27, 2015

Messages

6,337

• Jan 19, 2019

• #2

Hello akhon,

It sounds like you need at least 3 tables, one for student information (make sure you include a Primary Key Field that is an autonumber), one for class subjects (again, a PK field that is an autonumber) and a table that holds the classes taken by each student.

Why not start with the tables and post back here so we can take a look and offer some advice?

 

mike60smart

Registered User.

Local time

Today, 06:22

Joined

Aug 6, 2017

Messages

1,904

• Jan 19, 2019

• #3

Hi

Can you upload a zipped copy of your current db ?

 

A

akhon

Registered User.

Local time

Today, 10:52

Joined

Dec 19, 2018

Messages

27

• Jan 19, 2019

• #4

thanks for reply......

I have not created a table because i have no idea how to design it but i have attached an excel file which describe the table details.

 

Attachments

• Table.xlsx

  11.1 KB · Views: 102

mike60smart

Registered User.

Local time

Today, 06:22

Joined

Aug 6, 2017

Messages

1,904

• Jan 19, 2019

• #5

Hi

Will the Student be a member of a specific Class for a Specific Term?

Will there just be 1 Term for EACH Year?

For EACH Term I take it that the Student will sit specific Subjects

 

A

akhon

Registered User.

Local time

Today, 10:52

Joined

Dec 19, 2018

Messages

27

• Jan 19, 2019

• #6

mike60smart said:

Hi

Will the Student be a member of a specific Class for a Specific Term?

Will there just be 1 Term for EACH Year?

For EACH Term I take it that the Student will sit specific Subjects

Click to expand...

thanks for reply
If you are talking about earlier request then this thread is not for that it it totally different from that.


if you are talking about earlier than i will e-mail you because i have already cross my PM limits.
thanks

 

mike60smart

Registered User.

Local time

Today, 06:22

Joined

Aug 6, 2017

Messages

1,904

• Jan 19, 2019

• #7

Hi

So all you will need are tables as follows:-

tblStudents
-StudentID - PK Autonumber
-StudentFirstname
-StudentLastname
-(Other fields describing the Student)

tblStudentSubjects
-StudentSubjectID - PK Autonumber
-StudentID - FK - Number (Linked to PK from tblStudents - Enforce Referential Integrity)
-SubjectID - FK (Linked to PK from tblSubjects)
-Grade

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 06:22

Joined

Jul 9, 2003

Messages

16,280

• Jan 19, 2019

• #8

You might find this example on my website along with it YouTube instructions handy...

http://www.niftyaccess.com/many-to-many-relationship/

it shows students related to hobbies and the opposite, hobbies related to student. It shows you how to put them together....

Sent from my SM-G925F using Tapatalk