ID_Etudiant ID_Module Average 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
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.
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.
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.
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
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.
"Connections to SQL Server files (*.mdf) require SQL Server Express 2005"
What a curious mind needs to discover knowledge is noting else than a pin-hole.