a) Records of student performance are stored in a data file called 'marks.dbf' .The data file...

Transcribed Image Text:

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 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