Create records in a table - data structures, Database Management System

In this exercise you will create ten records, each containing the following fields: student name, class:  Freshman, Sophomore, Junior or Senior, Major:  Liberal Arts or General Science and ten randomly generated test scores between 0 and 100 for each student.  You will also incorporate the following calculated fields into your record:  Mean, median, mode and standard deviation.  Once record is prepared properly, you will insert it into a Binary Search Tree so that a list of students can be printed in ascending order by standard deviation.

Rules and definition of terms:

1. While the mean or standard deviation may be a floating point number, the grades MUST be integers.  Acceptable grades 89, 72, 91, etc.  Unacceptable grades 65.4, 38.7, etc. (you can not have a floated grade)

2. The mean is calculated by dividing the sum of the grades by the number of tests.  The result is often, but not always, floating point.

3. The median is the grade that is physically located in the middle of the ten grades.  This cannot be floating point.

4. The mode is the most commonly achieved grade; the one that appears more often.  There are problems with this however.  What happens if there is not common grade; that is, the grade does not appear more than once.  The mode would then be the average of all the grades.  What happens if there is more than one mode?  If the modes are physically adjacent to each other, then find their average.  If not, then you have a bimodal or, perhaps, multimodal situation.  List each mode.

5. The standard deviation requires some specialized math on your part.  Firstly, find the mean grade of the ten grades.  Secondly, subtract the mean from each grade.  Thirdly, square the differences and add them up.  Fourthly, divide this value by the number of tests and you will now have what is called "the mean squared deviation" or the variance.  Lastly, take the square root of the variance and you should now have the standard deviation.

6. Again, all of this information is placed into each record and then is displayed via Binary Search Tree.

To complete this work successfully, it must be GRAPHICAL with a nice G.Frame, must contain your source listing and executable file.  The names, classes and majors of your students are of your own choosing.  Test grades, of course, are randomly generated.

Posted Date: 3/1/2013 6:35:09 AM | Location : United States







Related Discussions:- Create records in a table - data structures, Assignment Help, Ask Question on Create records in a table - data structures, Get Answer, Expert's Help, Create records in a table - data structures Discussions

Write discussion on Create records in a table - data structures
Your posts are moderated
Related Questions
What is SQL Profiler? SQL Profiler is a graphical tool that permits system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save dat

A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;

What is Management System? A management system is a set of rules and process which help us to create organize and manipulate the database. It also helps us to add, change delet

Home based assignment Consider an ORDER table with the following attributes: • Order Number (ONo),Customer Number (CNo),Customer Name (CNa),Item Number (INo),Unit Price (UP), Quant

Examine about the Behavioural Diagrams  The main objective of behavioural diagrams is to visualize, specify, construct and document dynamic aspects of a system. The interactio

Data Handling and Research Methods: The dataset encompassing 130 participants contains several variables measuring detrimental health related behaviours referring to the use o

Information about a bank is about customers and their account. Customer has a name, address that consists of house number, area and city, and one or more phone numbers. Account ha

What is a dataset? A dataset is an in-memory database that is disconnected from any regular database, but has all the significant characteristics of a regular database. Dataset

#questiononsider the following relation: CAR_SALE =(CAR_ID,oPTION_TYPE, Option_listpreice, Sale_date, Option_discountedprice)..

Properties of a Transaction        A transaction has four main properties. These are: Atomicity Consistency Isolation or Independence Durability or Permanen