public ActionResult FunctionalDependencies()
{
using (MultipleChoiceModelDataContext MCdc = new MultipleChoiceModelDataContext())
{
MCdc.GenerateBaseElements("Functional Dependencies");
return(View(MCdc));
}
}
public ActionResult Anomalies()
{
using (MultipleChoiceModelDataContext MCdc = new MultipleChoiceModelDataContext())
{
MCdc.GenerateBaseElements("Anomalies");
return(View(MCdc));
}
}
public ActionResult Denormalization()
{
using (MultipleChoiceModelDataContext MCdc = new MultipleChoiceModelDataContext())
{
MCdc.GenerateBaseElements("Denormalization");
return(View(MCdc));
}
}
public ActionResult ScenarioToER()
{
using (MultipleChoiceModelDataContext MCdc = new MultipleChoiceModelDataContext())
{
MCdc.GenerateBaseElements("Scenario To ER");
return(View(MCdc));
}
}
public PartialViewResult GetTextualMultipleChoiceQuestion(string shortDescription)
{
using (MultipleChoiceModelDataContext MCdc = new MultipleChoiceModelDataContext())
{
MCdc.Question = MCdc.SelectMCQuestionByDescShort(shortDescription).ToList().First();
MCdc.Answers = MCdc.SelectMCAnswersByQuestionID(MCdc.Question.MCQuestionID).ToList();
MCdc.module = MCdc.SelectModuleByID(MCdc.Question.ModuleID).First();
return(PartialView("/Views/DatabaseDesign/TextualMultipleChoicePartialView.cshtml", MCdc));
}
}
