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

Assignment Help:

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.


Related Discussions:- Create records in a table - data structures

Discuss the count function, Discuss the count function? The COUNT funct...

Discuss the count function? The COUNT function used returns the number of tuples or values fixed in a query. The count function comprises two types of syntax: (1) COUNT (*)

The result of the union operation between r1 and r2, The result of the UNIO...

The result of the UNION operation between R1 and R2 is a relation that includes? The result of the operation between R1 and R2 includes all the tuples of R1 and R2 which have c

Domain constraint, Domain Constraint It shows that each attribute in a ...

Domain Constraint It shows that each attribute in a relation has to contain an atomic value only from the corresponding domains. The data types associated with commercial RDBMS

What is vertical fragmentation, What is vertical fragmentation? Vertica...

What is vertical fragmentation? Vertical fragmentation divides the relation by decomposing the scheme R of relation r.

Data flow diagram of structured analysis and design, From SAD to OOAD (Stru...

From SAD to OOAD (Structured Analysis and Design (SAD) to Object Oriented Analysis and Design (OOAD). We will find here how we can map various models in SAD to different model

What is the used of specifying alias, What is the used of specifying alias?...

What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.

What is association, What is association? Give an example of association ...

What is association? Give an example of association Association is used for establishing relationships among classes. Association describe links among/between classes. For exa

Job scheduling strategy, 1) Define a job scheduling strategy that will meet...

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

Write expressions in relational algebra, Given the subsequent relations: ...

Given the subsequent relations:    vehicle (reg_no, make, colour)    Person (eno, name, address)    Owner (eno, reg_no)   Write expressions

What are the causes of bucket overflow in a hash file, What are the causes ...

What are the causes of bucket overflow in a hash file organization? What can be done to reduce the occurrence of bucket overflow? When a record is inserted, the bucket to that

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd