Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hai Sir,

I have a small requirement in my mini project,I am explaining in this post briefly.

I want to do the project on Internal Assessment System. In that I have Course(B.TECH,B.E,MBA etc.),Department(CSE,ECE,IT etc.),Semester(I-I,I-II,II-I,II-II etc.),Subjects(OS,JAVA,EDC etc.).For that I want to calculate internal marks for every semester has 3 internals and assign every subject have three internals at every semester.

So,How can I choose tables in the Database?
Posted

1 solution

For the above requirement ,you can design table structure as below

1. Create master tables for Course, Department, Semester, Subjects (With primary key)

2. Create one table for Internal marks entry of every semester (table contain columns for foreign key of Course, Department, Semester, Subjects table and Marks column to put actual marks of that subject)
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900