Computers & Internet Logo

Related Topics:

s
srimannarayana Posted on Mar 09, 2015
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

N student details and sort the stures as per total marks ,by creating a structure to store the roll number,name,marks1,marks2,marks3

1 Answer

ka4iup

Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

  • The Master 4,062 Answers
  • Posted on Mar 09, 2015
ka4iup
The Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Joined: Mar 16, 2009
Answers
4062
Questions
0
Helped
1095587
Points
51404

You need to create a database with six fields: Roll Number, Name, Marks1, Marks 2, Marks 3 and MarksT (sum of marks1+2+3)

Sort database on MarksT in decending order.

Easily one in Excel - other programs will be similar

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

7. Program to manipulate N student details and sort the structures as per total marks obtained by them, by creating a structure to store the following details. Roll number, name, marks1, marks2, marks3

You can use Windows Excel
or
Adobe Open Office (free)

Select 'Spreadsheet' and away you go
The column width can be adjusted to suit the text
Text size is adjustable
Exam marks 1.2,3,4 etc can be auto calculated
Suggested format below (Open Office)
Name Fred Mary Jane



Roll 1 2 3



Exam 1 75 55 73



Exam2 80 81 82



Exam 3 66 71 90







Total 222 209 248
1helpful
1answer

The Madison Local High School marching band sold gift wrap to earn money for a band trip to Orlando,Florida .The gift wrap in solid colors sold for $4.00 per roll ,and the print gift wrap sold for $6.00...

Ah, word problems! The trick is to convert the given information into two equations in two unknowns. Let's let S be the number of solid color rolls sold, and P be the number of print rolls.

The first equation is easy:

(eq. 1): S + P = 480

We're given that information: the total number of rolls sold. For the second equation, use the given price information ($4/roll for the plain, $6/roll for the print).

(eq. 2): 4S + 6P = 2340

Again, we're given the total sales, and we know how much each kind costs.

Now it's just some basic algebra. Let's rearrange equation 1 to get S by itself:

S = 480 - P

Then use that value in equation 2, and solve for P:

4S + 6P =2340
4(480 - P) + 6P = 2340
1920 - 4P + 6P = 2340
2P = 420
P = 210

Now we know that the MLHS band sold 210 rolls of print paper, which means they sold 270 rolls of solid. You can your answers in the original equations. If they are the right values, both equations will work out.

270 + 210 = 480, eq. 1 is right.
(4 x 270) + (6 X 210) = 1080 + 1260 = 2340, eq. 2 checks.
0helpful
2answers

How to remove linker error in Tc C++ 3.0 in graphics.h header file and iomanip.h and msoftcon.h and windows.h

#include<stdio.h>
#include<conio.h>
#include<string.h>
#include<stdlib.h>
#include<ctype.h>
struct student
{char name[20];
int rollno;
int mark;
};
void main()
{
int ch,f,roll,i,j,l;
char name[20];
struct student k,t,d[50];
FILE *fp,*temp;
clrscr();
fp=fopen("stud.c","wb");
fclose(fp);
while(1)
{printf("\n=========================\n");
printf("\n\n1.Insert\n2.Display\n3.Search\n4.Delete\n5.Sort\n6.Update\n7.Exit");
scanf("%d",&ch);
printf("\n==========================\n");
switch(ch)
{
case 1:
{
printf("\n Enter name");
scanf("%s",k.name);
printf("\n Roll no:");
scanf("%d",&k.rollno);
printf("\n Mark");
sanf("%d",&k.mark);
fp=fopen("stud.c","a+b");
fwrite(&k,sizef(k),l,fp);
fclose(fp);
break;}
case 2:
{
fp=fopen("stud.c","rb");
while(fread(&k,sizeof(k),l,fp)!=0)
printf("\n name:%s \t Rollno: %d \t Mark:%d",k.name,k.rollno,k.mark);
fclose(fp);
break;
}
case 3:
{f=0;
fp=fopen("stud.c","rb");
printf("\nEnter the rollnumber to be searched :");
scanf("%d",&roll);
while(fread(&k,sizeof(k),l,fp)!=0)
{ if(k.rollno==roll)
{
f=1;
printf("\n Name:%s \t Rollno:%d\t Mark:%d,k.Name,k.rollno,k.mark");
}
}
if(f==0)
printf("searched item does not exit");
fclose(fp);
break;
case 4:
f=0;
printf("enter the roll no for deleting the record:");
scanf("%d",&roll);
fp=fopen("stud.c","rb");
temp=fopen("temp.c","wb");
while(fread(&k,sizeof(k),l,fp)!=0)
{
if(k.rollno==roll)
f=1;
else
fwrite(&k,sizeof(k),l,temp);
}
fcloseall();
if(f==1)
{
temp=fopen("temp.c","rb");
fp=fopen("stud","wb");
while(fread(&k,sizeof(k),l,temp)!=0)
fwrite(&k,sizeof(k),l,fp);
printf("record deleted");
}
else
printf("roll no not found");
fclose(fp);
fclose(temp);
break;
}
case 5:
{
fp=fopen("stud.c","rb");
i=0;
while(fread(&d[i],sizeof(k),i,fp)!=0)
i++;
fclose(fp);
for(j=0;j<i-1;j++)
{
for(l=j;l<i;l++)
{
if(d[j].rollno>d[l].rollno)
{
t=d[j];
d[j]=d[l];
d[l]=t;
}
}
}
fp=fopen("stud.c","wb");
for(l=0;l<i;l++)
fwrite(&d[l],sizeof(k),l,fp);
fclose(fp);
printf("\nsuccessfully sorted");
break;
}
case 6:
{
f=0;
printf("enter roll number to update:");
scanf("%d",&roll);
fp=fopen("stud.c","rb");
temp=fopen("temp.c","wb");
while(fread(&k,sizeof(k),l,fp)!=0)
{
if(roll==k.rollno)
{
printf("enter the new record name,mark\n");
scanf("%s%d",k.name,&k.mark);
f=1;
}
else
fwrite(&k,sizeof(k),l,temp);
}
fcloseall();
fp=fopen("stud.c","wb");
temp=fopen("temp.c","rb");
while(fread(&k,sizeof(k),l,temp)!=0)
fwrite(&k,sizeof(k),l,fp);
if(f==0)
printf("roll no is not present");
fcloseall();
break;
}
case 7:
exit(1);
break;
}
}
}
0helpful
1answer

Project on student attendence.

Hi Radhika,
I can help you in making project, simply wat you have to do is :-
--- try to create Structure chart of the system
--- Try to create DFD
--- Try to create ERD for the system
send it to me at [email protected]
having problems in all this pl call me at 9899780221

Thanks

Zulfikar Ali
3helpful
3answers

Payroll system in DBMS. I don't know what data is to be taken.

Firstly you need to determine/state whether you are using a database application, such as Access, MtSQL or MS SQL and programming them to do create this application, or are you using a programming development tool such as Visual Studio, ASP.NET, PHP or the like, as the solution and guidance will be different for each.
In terms of the data design, you should store the data necessary to identify each employee uniquely and each data point per employee needed to calculate their payroll. You should then store the generic (applys to all employees) such as tax rates, in separate tables and call on it to calculate wages and other paystub data.
For instance, the employee first and last names and tax ID should be a sufficient unique identifier. Create a table for just employees, their names, tax ID, start date, schedule, pay rate, number of deductions, direct bank payment data, etc., and whatever else you decide you need for each employee. You can calculate their wages by multiplying their rate by their schedule and applying the appropriate tax rate and medical/witholding deductions as you go, so calculated data does not need to be stored and consume database space. 
You'll likely need a separate table for common data such as tax rates, one for deductions/witholdings, one for holidays, one for vacation accrual rates, one for medical rates, etc. This data if common to employees does not need to be stored per individual, as that would cause redundant replication of data. If the employees are on an hourly rate, rather than a set salary/wage, then you'll need a table of worked hours per employee, akin to their timesheet data. If you use a timesheet/timecard, the entering and storing only the totals and keeping the physical timesheet for backup records should suffice.
Once you design and populate your database as suggested above, then it's a relatively-simple task of calculating the computed paystub data and storing the salient resulting datapoints for the record.
Consider a reporting application, such as Crystal Reports, for your printing needs, as its far easier to configure Crystal or similar product to format reports, paystubs, checks, etc., than coding these from scratch.
Hope this helps.
Not finding what you are looking for?

72 views

Ask a Question

Usually answered in minutes!

Top The Computers & Internet Experts

Alexander

Level 2 Expert

171 Answers

vince

Level 3 Expert

2530 Answers

Steve Sweetleaf
Steve Sweetleaf

Level 3 Expert

1212 Answers

Are you a The Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...