Gradebook

DescriptionGradeBook is a sample database that store information that allows the user to keep track of grades for students in multiple classes. The data in the database is based on real data, but it is not real data. There is a MySQL database with the data in it on cse.unl.edu.
You can access the database wth username cusack2RO and password egbdf5s.
You can use MySQL Control Center, or the command line MySQL.
You will be able to query, but not able to change the database.

The complete design description of the GradeBook database (and another example) is available

DSExamples.doc (Word)
HTML

Some Grade Book Data

The following data from the database is intended to assist in performing queries. For instance, knowing the CourseID or DistributionID might make querying for grades, etc. easier. The purpose is to assist you as you start to learn to query a database. After practicing for a while, you should not use the information from these tables to help you in your queries.

The courses in the database are given below. Of course, you can also easily get this information with a simple queury:

SELECT * from Courses

CourseID	Department	CourseNumber	CourseName	Semester	Year
1	CSCE	155	Introduction to Computer Science I	Fall	2003
2	CSCE	155	Introduction to Computer Science I	Spring	2004
3	CSCE	156	Introduction to Computer Science II	Fall	2003
4	CSCE	156	Introduction to Computer Science I	Spring	2004
5	CSCE	235	Introduction to Computer Science I	Spring	2003
6	CSCE	235	Introduction to Computer Science I	Fall	2003
7	CSCE	235	Introduction to Computer Science I	Spring	2004
8	CSCE	310	Data Structures and Algorithms	Spring	2002
9	CSCE	310	Data Structures and Algorithms	Fall	2002
10	CSCE	310	Data Structures and Algorithms	Spring	2003
11	CSCE	310	Data Structures and Algorithms	Fall	2003
12	CSCE	310	Data Structures and Algorithms	Spring	2004
13	CSCE	496	Quantum Computing	Spring	2003
14	CSCE	423	Design and Analysis of Algorithms	Spring	2003

The distributions for each course is given in the following tables. Of course, you can also easily get this information with a simple queury:

SELECT * from Distribution WHERE CourseID=X;

CourseID=1

DistributionID Category Percent

1 Progs 25

2 Quiz 20

3 Mid 15

4 Final 15

5 Project 15

6 Part. 10

CourseID=2

DistributionID Category Percent

7 Quiz 40

8 Mid 15

9 Final 15

10 Project 30

CourseID=3

DistributionID Category Percent

15 HW 30

16 Quiz 15

17 Mid 15

18 Final 15

19 Proj. 15

20 Part. 10

CourseID=4

DistributionID Category Percent

11 HW 50

12 Pre 5

13 Mid 20

14 Final 25

CourseID=5

DistributionID Category Percent

21 HW 30

22 Quiz 25

23 Final 25

24 Project 15

25 Part 5

CourseID=6

DistributionID Category Percent

26 HW 25

27 Quiz 15

28 WS 30

29 Midterm 15

30 Final 15

CourseID=7

DistributionID Category Percent

31 Homework 40

32 Exam 25

33 Pretest 5

34 Project 20

35 Example 10

CourseID=8

DistributionID Category Percent

36 Homework 50

37 Pretest 5

38 Midterm Exam 20

39 Final Exam 25

CourseID=9

DistributionID Category Percent

40 Homework 40

41 Worksheets 15

42 Quiz 10

43 Pretest 5

44 Midterm 15

45 Final 15

CourseID=10

DistributionID Category Percent

48 Homework 35

49 Quiz 10

50 Worksheet 20

51 Pretest 5

52 Midterm 15

53 Final 15

CourseID=11

DistributionID Category Percent

46 Homework 50

47 Quiz 50

CourseID=12

DistributionID Category Percent

54 Homework 45

55 Quiz 20

56 Pretest 5

57 Final 15

58 Project 15