Database Design - Help needed urgent -New member

[tripoliguy]

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

[June7]

Work through these tutorials http://www.rogersaccesslibrary.com/

Search this forum for threads on topic. Student database has been discussed frequently.

Design ERD fitting your requirements and post for analysis.

[ranman256]

[DEPT] tbl
college
dept

[courses] tbl
dept
course
startDate

[Student] tbl
student id
name

[student class] tbl
student id
course