Michael L John (10/21/2015)

---

There are couple things I see that don't make sense to me.

1. The "semester_id" in the Student table. This is a lookup to the Semester...

hi, I have come so far. Now i need to know something. In the Subjects table , I have columns for four types of marks(THPA, THET, PRPA, PRET) for each...

rmechaber (10/20/2015)

---

hlsc1983 (12/16/2013)

---

this is my first SQL server project.. student registration system using SQL server 2008 and VB.net.

can you please help me in designing the database?

the system will...

Grant Fritchey (10/20/2015)

---

Assuming I'm reading this correctly, we can see the Student to Subject Relationship through the Semester to Subject table? I find that a little confusing. The Student isn't...

hi, i did but i am not getting any response...

hi am back after a long time . so sorry for that. Now i need to enter 'Marks ' . Each student will have two types of marks for the...

ScottPletcher (3/5/2014)

---

The core thing is not to skimp on the design. It may look 'leaner' to just leave out some relationship tables, or to combine some relationship tables, but...

thanks again...i think its a very open ended question. I think I will continue with the front end in VB.net and as and when the need arises I will make...

Sean Lange (3/5/2014)

---

hlsc1983 (3/5/2014)

---

i have a query regarding my database design. The snapshot of my database was posted in my earlier post.

In my database i wanted to include a table...

i have a query regarding my database design. The snapshot of my database was posted in my earlier post.

In my database i wanted to include a table called 'Subjects' to...

Sean Lange (1/15/2014)

---

hlsc1983 (1/15/2014)

---

Grant Fritchey (1/15/2014)

---

I agree on the number of students. Also, what's the difference between student_pk and student_id? Seems like one or the other isn't needed unless the...

Grant Fritchey (1/15/2014)

---

I agree on the number of students. Also, what's the difference between student_pk and student_id? Seems like one or the other isn't needed unless the ID is some...

thanks.. i never expected the problems it might create in the future.

this is what i have come up with so far. please review it and suggest necessary changes.

This is what i have come up with so far. please review it and give necessary input.thanks,.