Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a) Records of student performance are stored in a data file called 'marks.dbf' .The data file contains the following information: Field Name StudentName ChemMarks

image text in transcribed

image text in transcribed

a) Records of student performance are stored in a data file called 'marks.dbf' .The data file contains the following information: Field Name StudentName ChemMarks PhyMarks Maths Marks Description Name of student Marks in chemistry Marks in Physics Marks in Maths Write a FoxPro program that would read data from the marks. dbf compute average mark of each student and display the student name and grade of each student according to the following criteria. The students are graded as shown in the table below. Your program should include a function to find grade. FDCBA Use DO While and Do Case control structures. [8 Marks] b) List any three Data Definition Language (DDL) and any four Data Manipulation Language statements used by SQL [7 Marks] Average marks Grade Less than 40 Less than 50 Less than 60 Less than 70 70 and above

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics For Business And Economics

Authors: Paul Newbold, William Carlson, Betty Thorne

8th Edition

0132745658, 978-0132745659

More Books

Students also viewed these Databases questions