Help needed urgent -New member

[tripoliguy]

Another Help needed urgent -New member Thanks for all

Hi all and I am really happy to find such forum..I need a help in creating tables that supports my project in my university.
I need to make a program to add students in the uni. records and in each course.
I need to know each student and his related courses.this is a brief of what i need
i have :
- Four departments in the college
- Each department has its own courses-subjects-
- Student may take an elective courses in other department
- I need a reports for:
- each student contains :his name - courses he attends -grades he takes in each course
- each course contains : course name - students that are participated in - credits of it

Thanks a lot for your help pleasseeee help me

how tables I need

 

[CJ_London]

To get you going,you need something along the following lines

departments
departmentID
departmentName

students
studentID
StudentName

courses
CourseID
CourseName

CoursesperDepartment
CourseDepartmentID
DepartmentID
CourseID

StudentsPerCourse
StudentCourseID
CourseDepartmentID
StudentID
ElectiveStatus

Since this is your projectwork it is presumably to help you learn so you will need to expand on the above - our object is to help people learn, not do their work for them

 

[tripoliguy]

Since this is your projectwork it is presumably to help you learn so you will need to expand on the above - our object is to help people learn, not do their work for them

Thanks a lot, and this is what I need some help not the whole project

 

[tripoliguy]

departments
departmentID
departmentName

students
studentID
StudentName
.and another fields
.
.

courses
CourseID
CourseName
Course Credits
Course type

CoursesperDepartment
CourseDepartmentID
DepartmentID
CourseID

StudentsPerCourse
StudentCourseID
(CourseDepartmentID)--i didn't include this-I made another table(studentPerDept).
StudentID
CourseID-I added this
Grade

StudentsPerDept.
StudentDeptID
DeptID
StdID


Now my question is on forms design...
I want to op the form whenever the file has been clicked
Any help please