views:

45

answers:

0

I imported data into csv table via .net app, pls help, how can i aInsert into all the tables so that i can query;

  1. student avg score to a question or test
  2. student answers to a question or answer frequency to a question etc

My tables are in this form;

Csv             Ans         Quest      Test    Ans_Quest_Test
---------      ------      ------     ------    -------------
LName           id          id         Id       Ansid
FName           Ans         Quest      name     Questid
stdname        StdScore    ActScore             Testid
Quest                                           Stdname
Ans
ActualScore
StdScore