|
Sir!
I am trying to develop a computer based Result Tabulation System for the school I work in.
I have designed the tables for Teachers, Classes, Students etc. but am stuck with the design of tables for exam system itself. Can you please guide me as to how better it could be done?
The examination system of school is as follows.
1. There are Two Terms in an academic year
2. There are two Bimontlhy's(BM) in each term
3. There are Four Class works(cw), One Oral Project(OP) and One Assessment Test(AT) in one Bimonthly
4. The aggregate of all the class works and OP and ATs make one Bimonlthly
Its Like
cw1+cw2+cw3+cw4+OP+AT = BiMonthly(BM)
5. The aggregate of two Bi Monthly and Term Exams make A Term Assements
and
BM1+BM2+First Term Exam = First Term
I am wondering as how to make normalized tables and avoid any anomalies.
Should I make separate tables for Classworks like
tblClasswork: cwID, cwname, cwshort
1 , Classwork1, cw1
and same for AT and OPs.
and them make a table for Bimonthly to Put CWID in it ...
and then for term?
I have also tried to create a table named
tblExamData with fields: stuID, teacherID, subjectID, sessionID, cwID, opID, atID, bmID, termID
but it won't serve the purpose coz it will store the information about CWs, Ops and Ats not the obtained marks of the students.
I have also tried to change it like
tblExamData: stuID, teacherID, subjectID, sessionID, cwID, cwMarks, opId, opMarks, atID, atMarks, bmID, bmMarks, termID, termMarks.
but then there may be some update, delete anomalies.?
what to do with it?
I apologise for this long write up but i am writing in a hope to get a better guideline.
thank you
regards,
|
|
|
|
|
I am also working on the same system but this one is for the university,
I will send it to you in few days be in contact with me...
my cell No. is +92-333-7112553
|
|
|
|
|
Yeah! thank you! Its nice to hear that you are working with a same kind of system!... Good to be in contact haa'n
mine cell is +92-321-4169324
Tahir
|
|
|
|
|
I'm not sure if I should be posting this here or in one of the .net forums.
I'm trying to get data from two access tables:
tblFoo
FooID FooText
1 Text1
2 Text2
3 Text3
...
lnkFoo
FooID1 FooID2
1 2
1 3
2 7
...
I want to get the FooText for every row in lnkFoo eg:
Text1 Text2
Text1 Text3
Text2 Text7
...
Using the Configure Data Adaptor wizard I can get both FKs from lnkFoo and the FooText value for either FooID1 or FooID2 by putting both tables in the query builder and dragging to link either FooID1 or FooID2 in lnkFoo to FooID in tblFoo, but if I create links to both FK's in lnkFoo no records are returned.
The nonworking query that is generated looks like this:
SELECT lnkFoo.FooID1, lnkFoo.FooID2, tblFoo.FooText, tblFoo.FooID
FROM (lnkFoo INNER JOIN
tblFoo ON lnkFoo.FooID1 = tblFoo.FooID AND lnkFoo.FooID2 = tblFoo.FooID)
--
You have to explain to them [VB coders] what you mean by "typed". their first response is likely to be something like, "Of course my code is typed. Do you think i magically project it onto the screen with the power of my mind?" --- John Simmons / outlaw programmer
|
|
|
|
|
Putting a second copy of the table into the query designer and linking FooID1 and FooID2 to different instances of tblFoo worked. Is there a more graceful way to do this though?
--
You have to explain to them [VB coders] what you mean by "typed". their first response is likely to be something like, "Of course my code is typed. Do you think i magically project it onto the screen with the power of my mind?" --- John Simmons / outlaw programmer
|
|
|
|
|
select
(select FooText from tblFoo where FooID=a.FooID1),
(select FooText from tblFoo where FooID=a.FooID2)
from lnkFoo a
|
|
|
|
|
Has anybody out there come across problems when trying to search a DB of person names, when those names contain non-standard characters? I've got a DB full of Irish names, a generic search function in my app, and the user is complaining that he can't search independent of fadas. I.E., For the name Ciarán Martin, if he searches for ciaran it doesn't return a row.
This must be an issue in other countries too, I mean all you German developers, come on, with the weird S and the umlaut... How do you get around this? Or is the only way to implement a character map in the .NET code, for all the specific characters in question, to their lower case standard alphabet equivalents? I really really don't wanna do that....
All the dude ever wanted... was his rug back.
|
|
|
|
|
You need to disable accent-sensitivity in the column's collation. You can do this with the ALTER TABLE table ALTER COLUMN statement.
Generally you replace AS (for Accent Sensitive) in the name of the collation with AI (for Accent Insensitive). So if the collation is now Latin1_General_CI_AS (Windows collation, uses 1252 character set, general dictionary sort, case insensitive, accent sensitive), you should change it to Latin1_General_CI_AI.
|
|
|
|
|
Do any one know the tool for migrating the MS Access functions to Oracle Procedures/Functions.
Ravi
|
|
|
|
|
Do you mean the SQL code behind the queries or do you mean VB6 functions?
______________________
stuff + cats = awesome
|
|
|
|
|
Tool to convert functions in MS Access to oracle pl/sql procedure
|
|
|
|
|
|
Either using SQL or C#/ADO.NET is there a way for me to "probe" a stored procedure to return the names of its input parameters to my code?
Thanks.
|
|
|
|
|
Interseting!!! but I dont think its possible. 
|
|
|
|
|
In Sql Server theres atleast 2 different ways to achive this 
|
|
|
|
|
I assume your talking about sql server?
If it's 2005 you want to use the System Views:
http://www.microsoft.com/downloads/details.aspx?FamilyID=2ec9e842-40be-4321-9b56-92fd3860fb32&displaylang=en[^]
If it's 2000 you want the system tables:
http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx[^]
Unfortunatly I dont have a link handy on how to use them, but they are pretty straight forward and will provide all you need 
Edit: just spotted this article. It looks old but relivent:
http://www.devx.com/vb2themax/Tip/18282[^]
-- modified at 6:16 Tuesday 26th June, 2007
Edit: I also forgot to tell you about DMO and SMO 
SMO (Sql Management Objects) in 2005, is a set of objects you can use in .Net that retrive a lot of information about Sql Server and allows you to perform admin operations. They definatly allow you to list the stored procs and all the details about them. A little warning when used with a complex database the SMO's can require a fair bit of tweaking to perform well but it's well worth it if you need that much control.
DMO is similar and used in 2000. I've never personally used DMO so you'dh ave to look into what it can achive.
|
|
|
|
|
exec sp_sproc_columns MyStoredProcesure
i guess is that what you're looking for!
|
|
|
|
|
See ... we live and learn
Nice one
|
|
|
|
|
it woulde be better if you've said
" We learn and live  "
|
|
|
|
|
Except the phrase is "We live and learn" :P
We live and learn : (phrase used when sb has heard sthg new, unexpected, and surprising.)
-- modified at 7:31 Tuesday 26th June, 2007
|
|
|
|
|
oh thanks for the information mate
so We Live and Learn!
|
|
|
|
|
I'm not sure I can think of a valid business case as to why you'd want to do that. From a programmatic perspective, you'd still need the type and, depending upon the type, the size of the field. If you know both sides of the system, there are myriad better methods to perform what you're asking.
|
|
|
|
|
Thanks guys I managed to do it in with .NET by using SqlCommandBuilder.DeriveParameters(MySqlCommand)
It was used to create a generic method to loop through values from a DTO and place them into input parameters for a given Stored procedure on the mapper layer of our code. If I cache the results (for speed) it saves us lots of time rewriting very similar stuff inside each mapper to take the dto and asign its values to known paramaters in different procedures.
So what i have is
DataAdapter myMethod(string SProcName, DTOType inputParamsDTO)
{
DataAdapter da = new DataAdapter.
[psudo] open connection to sql
SqlCommandBuilder.DeriveParameters(SProcName)
[psudo] loop
[psudo] if SProcName.Param.Direction == input OR input/Output
[psudo] if inputParamsDTO.Tables[0].Rows[0][i].Contains(SProcName.Param[i].ParamaterName)
[psudo] SProcName.Param[i] = inputParamsDTO.Tables[0].Rows[0]["SProcName.Param[i].ParamaterName"]
[psudo] end loop
[psudo] close connection to sql
[psudo] return da
}
So we pass it a SProc and a DTO (or dataset) and it gives us back a data adapter we can just calla Fill() on.
But it needs to cache some where to stop excessive round trips
|
|
|
|
|
Microsft provide a class to do just this - SQLHelperParameterCache as part of its SQLHelper class as part of its Data Access Application Block. I don't have any links to hand, but google is your friend.
Adam
|
|
|
|
|
Hi all,
I am installing SQL Server 2005 with 2000 already installed. After I go through the whole setup process now with several instances created I can't launch the program from the strt menu. It only gives me the 'configuration tools' option.
Also I think 2000 was installed as a local user but now I am installing from a domain account.
What's going on here, should I install sql using the domain account even though I only plan to use it locally?
Thanx,
Kiefie
The man with an idea.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
