Database containing two tablesstudents and grades

Assignment Help Other Subject

Reference no: EM13193002

A teacher maintains a database containing two tablesStudents and Grades. The Students table has six fields: socSecNumber, lastName, firstName, streetAddress, cityAndState, and zipCode. The Grades table has four fields: socSecNumber, firstExam, secondExam, and finalExam. At the beginning of the semester, the Students table is filled in completely with a record for each student in a class, and the Grades table has a record for each student that contains only the student's social security number.

2.1 Create an appropriate database using the above specifications for the table. (10)

Write a program that allows the instructor to record and process the grades for the semester. The program should do the following.

2.2 Create a data grid view that can be used to fill in the grades for each student after each exam. (10)

2.3 At the end of the semester, display a data grid view showing the name of each student and his or her semester average. The semester average should be calculated as (firstExam + secondExam + 2 * finalExam)/4. (10)

2.4 Print a list of semester grades that the instructor can post on his or her office door. The list should contain the last four digits of each student's social security number and the student's semester grade. The semester grade should be determined by the semester average with an A for 90-100, a B for 8089, and so on. The list should be ordered by semester average. Note: You can just display the list in a list box instead of actually printing it. (10)

2.5 Print a letter for a student (identified by his or her social security number) similar to the one shown below. Note: You can just display the letter in a list box instead of actually printing it.

George Jackson

123 Main Street

Washington, DC 20015

Dear George,

Your grades for CMSC 100 are as follows:

Final Exam: 87

Semester Grade: B

Best wishes for a good summer,

Professor Jones.

Reference no: EM13193002

Questions Cloud

Creating a slave society existed in virginia in the 1620s : If the ingredients for creating a slave society existed in Virginia in the 1620s, why did slavery not develop until the 1660s? Why did slavery increase dramatically after 1670?

Preventable cause of death : Which product is associated with the single most preventable cause of death in the U.S.?: A. MarijuanaB. CaffeineC. AlcoholD. Tobacco

International marketing involvement : McDonald's is at what stage of "international Marketing Involvement"? Support your choice by providing specific examples from the teams chosen articles.

Examples of foreign environmental uncontrollable forces : Identify and provide three specific examples of foreign environmental uncontrollable forces that McDonald's faced in their efforts to future expand globally. Use specific examples from your selected articles to support your answer.

Database containing two tablesstudents and grades : A teacher maintains a database containing two tablesStudents and Grades. The Students table has six fields: socSecNumber, lastName, firstName, streetAddress, cityAndState, and zipCode. The Grades table has four fields:

Terms of economy-politics-music-religion : Note some differences between the Middle Ages and the Renaissance (in terms of economy, politics, music, religion and anything additional would be great!). Please offer your opinions on your own material and other's. (1-2 paragraph)

Era of dual federalism : Which of the following was not a function of government most commonly performed by state governments during the era of dual federalism?

How are risk-uncertainty and effective resource : Write a page paper on how are risk, uncertainty, and effective resource allocation best managed when it comes to the design and planning schools.

Unencrypted passwords and the data inside files : A sniffer program shows all the data on an unswitched network segment by including unencrypted passwords and the data inside files.

User Account

All Pages