|
If you are asking about the language, english is ok, but maybe you migh want to add spanish as well and load the corresponding language depending on the user's blowser configuration
If you are asking about programming language... Develop it using asp.net with vb or c# as the programming languaje (vb is easier)
Alexei Rodriguez
|
|
|
|
|
Hi,
Sorry i don't speak english
I started in informatic and I must make my first project for the management reviews of students.
I have the following tables:
Student:
ID_Etudiant Name
Matter
ID_matière_ Coefficient ID_Module
Notation
ID_Etudiant ID_Matière Note Année_universitaire
Module:
ID_Module Libelle_module
Moyenne_module:
ID_Etudiant ID_Module Average Année_Universitaire
Academic Year:
Année_universitaire
I registered the notes on Rating but I planted in the calculation of averages I do not know how to
I am trying to get a detailed as follows:
ID_Etudiant Moyenne_module1 Myenne_module2 Moyenne_module3
For example, the module1
Id_matiere Id_module
11 Module1
21 Module1
31 Module1
So the average _module1 be:
(Note (11) * coefficient (11) + note (21) * coefficient (21) + note (31) * coefficient (31)) / (coefficient (11) + coefficient (21) + coefficient (31))
thank you read me and show me the track to follow.
|
|
|
|
|
You are designing a students database, make it a school database software something you can install in any school, easier to think that way.
Important to think about the structure, to avoid start from the begining, I am not sure about yours it seems ok, i don´t understand very well french
forget the code, talk a little more about the database, maybe i can help.
Good luck
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
thanks a lot nelsonpaixao merci bcp;
My database:
VALIDATION_MODULE (CODE_VALIDATION_MODULE ,........)
VALIDATION_SEMESTRE (CODE_VALIDATION_SEMESTRE ,........)
AVERAGE (NOTE_MODULE, CODE_MODULE #, # NUM_student, # CODE_VALIDATION_MODUE ,........)
final_average (NOTE_SEMESTRE, NUM_INSCRIPTION #, # CODE_SEMESTRE, # CODE_VALIDATION_semestre .......)
REVIEW (review, NUM_student #, # CODE_MATIERE)
STUDENT (NUM_student. .....)
FIELD [CODE_MATIERE, COEFFICIENT, # CODE_MODULE ........)
MODULE (CODE_MODULE, .. # CODE_SEMESTRE.)
semestre (CODE_SEMESTRE ,...)
i don't understand make it a school database software something you can install .
merci encore
|
|
|
|
|
i don´t know i can assist you here, try invest in the database structure to avoid you to start from the beginning later, you will get easier sp also.
i builted a videoclub (movie rental) project, i knew the structure i needed(major table was 'rents' that got who rented and what rented, 75% of store procedures feeded from that table), in your case i imagine but no sure of structure, they did gave you a check list, right?
For exemple i am accountant i can easely built a accountant software and give suggestions because i know the algorhitms, if it is of other kind i need assistance i needed a ckeck list of what they want and i will keep asking question all the time!!!
i mean school database software, didn´t you seen a videoclub, library, or other software? i mean that because you didn´t show no info besides students and grades, nothing of teachers or rooms etc, but it may be all you need you know.
Good luck, sorry couldn´t help 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Hi..
I have paradox database files I opened it using Access but the arabic text looks unreadable I changed the font to arabic but this was no use.Do you have any suggestion?
I am too late but i will never give up
|
|
|
|
|
It's probably the cultureinfo of the database rather than the font, fixing it - no idea sorry.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I set the collation for the database to arabic before migrating the database using DTS and the data still unreadable.I tried and copy the data to an email and send it to another employee in the company.In outlook He set the encoding to Arabic(Windows) and it becomes readeable.So I think I have two choices to solve the problem:
1-Set the Encoding in Access to Arabic(Windows):I couldn't find any Encoding settings in Access.
2-Set the Encoding in code for that field in the dataset.
Please if any one knows how to reach one of these solutions tell me about it.
I am too late but i will never give up
|
|
|
|
|
|
Here is google translator.[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
"An error occurred connecting to SQL server 2005. Unable to accept remote connections."
What you need to do is run the SQL Server Configuration Manager and make sure that protocol TCP/IP is enabled. Try that.
|
|
|
|
|
an error as occurred when connection to the server.
while connecting sql server 2005, this error is likely to be caused by, according to sql server setting, remote connections are not allowed
(provider: ... -there was not possible to connect to sql server
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Hi!
I had upgraded Visual Studio 2005 to 2008 and then upgraded SQL EXPRESS 2005 to SQL EXPRESS 2008. However, When I try to add a new "mdf" file under APP_Data directory. I am getting the following error message. How can I solve the problem? The Microsoft.Net Framework Version 3.5 SP1 and Microsoft SQL Server compact SP1 has been already installed.
ERROR MESSAGE
"Connections to SQL Server files (*.mdf) require SQL Server Express 2005"
Thanks.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
Did you try to search on google[^]before post here?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Of course I did so that is why I decided to post the problem right here. You don't expect one to go and spend hours and hours the find the correct link related to problem in google right?
If you don't know the answer, please do not reply to my message.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
I know answer i am sure 100% but i wont give it to you.
Same problem i had too and i solved, so keep searching dude. 
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
I will keep searching and you will mess up the forums. (DUDE!)
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
No,you are messing up forum with your beginners questions.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Where does it indicated that the forums are not for beginners? show me the link!
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
The link is with this subject on question:
"How can I solve SQL EXPRESS 2005 problem in Visual Studio 2008?"
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Your aim is not to help the others in this forum, therefore do not post any more messages. Take a long walk. I think you are experiencing some sortf of behaviour problems.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
|
if i use varchar(max) instead of varchar(50), and use "chandra" only , then will both give the same performance.
“You will never be a leader unless you first learn to follow and be led.”
–Tiorio
"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford
|
|
|
|
|
I assume your question is 'will they give the same performance?' - if so the answer is yes.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
well,
i use varchar(max) for very long strings, that i don´t know the size
i use varchar(50) if i know the string never goes of that border
var means variable, so is from 0 to 50.
if you know you only need 3 chars you use char(3)
if you need 0,1,2 or 3 chars you use varchar(3)
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
