Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bilal_119
Starting Member
4 Posts |
 Posted - 2010-03-16 : 12:09:24
|
| Detail about my task---------------------i want to create database containing the students and their information in the following manner:• handle student information, such as Ids, names, addresses, contact info, gender, date of birth, and program enrolled.•handle programs offered and their details.• also handle courses enrolled by a student.• handle marks and grades obtained by a student in each course.• must generate a sample transcript of a student having details of the courses taken and their marks / grades etc.-----------------------MY Question????I have designed table now please tell me how to define their relationships. and how to normalize theses tables? and also tell me what is data diagrams and views in sql server 2008?Bilal Sohailhttp://visualstudiocheat.blogspot.com/ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
relationship and normalization