The grading scale for this class is as follows:

[95%, ∞] = A       

[90%, 95%) = A-

[87%, 90%) = B+

[83%, 87%) = B

[80%, 83%) = B-

[77%, 80%) = C+

[73%, 77%) = C      

[70%, 73%) = C-

[67%, 70%) = D+

[63%, 67%) = D

[60%, 63%) = D-

[-∞, 60%) = F  

IMPORTANT: If you think (1) your achievements were not graded fairly, or (2) I made a mistake in my calculations, please inform me by e-mail immediately.

 

Grades so far:

NIC

Hmrk 1

Hmrk 2

Test 1

Hmrk3

Hmrk4

Hmrk5

Test 2

SQL Hmwrk

Test 3

Project

Final

NIC

FINAL SCORE

FINAL GRADE

107

100.0

100.0

95.0

9.2

84.0

8.5

97.1

92.9

100.0

98.0

100.0

107

95

A

!BA

100.0

100.0

90.0

9.0

82.0

8.0

90.0

97.0

100.0

105.0

92.4

!BA

94

A-

CES

100.0

100.0

100.0

9.7

92.0

9.5

98.2

100.0

98.6

100.0

99.5

CES

97

A

CHU

100.0

100.0

75.0

9.0

91.0

8.0

87.6

89.4

67.9

104.0

94.9

CHU

89

B+

CRA

100.0

100.0

100.0

9.5

89.0

9.0

100.0

98.0

100.0

95.0

100.0

CRA

96

A

HAI

100.0

100.0

100.0

0.0

80.0

7.0

52.9

79.8

81.4

0.0

0.0

HAI

40

F

HOS

0.0

100.0

90.0

7.6

0.0

0.0

43.5

27.8

55.7

104.0

92.9

HOS

67

D+

INI

0.0

100.0

90.0

9.9

99.0

7.5

92.4

90.4

72.9

96.0

94.9

INI

89

B+

ITM

0.0

100.0

80.0

9.5

91.0

9.5

96.5

97.5

67.1

97.0

90.9

ITM

87

B+

JEW

0.0

0.0

85.0

9.2

68.0

8.0

60.6

0.0

0.0

0.0

0.0

JEW

19

W

KUR

100.0

100.0

75.0

9.9

84.5

7.5

85.3

78.8

61.4

0.0

0.0

KUR

41

F

OMN

34.0

100.0

75.0

9.0

49.0

6.5

82.4

70.2

63.6

90.0

84.8

OMN

76

C

RAC

100.0

100.0

65.0

0.0

76.0

8.5

80.6

89.9

71.4

97.0

92.9

RAC

84

B

RED

100.0

100.0

65.0

9.0

81.0

8.5

60.0

0.0

0.0

0.0

0.0

RED

21

W

SIN

0.0

100.0

65.0

8.6

72.0

7.0

51.8

92.9

61.4

96.0

75.3

SIN

74

C

SNW

0.0

100.0

60.0

8.4

62.0

6.0

72.9

78.8

0.0

0.0

0.0

SNW

26

F

SQL

34.0

100.0

85.0

9.0

80.0

7.5

88.2

75.8

85.7

100.0

87.4

SQL

87

B+

VER

100.0

100.0

100.0

8.5

74.0

7.0

86.5

93.4

100.0

98.0

98.5

VER

93

A-

Z

100.0

100.0

15.0

8.5

50.0

7.5

40.0

91.4

84.3

97.0

87.4

Z

75

C

MIN

0.0

0.0

15.0

0.0

0.0

0.0

40.0

0.0

0.0

0.0

0.0

MIN

19.0

 

MAX

100.0

100.0

100.0

9.9

99.0

9.5

100.0

100.0

100.0

105.0

100.0

MAX

97.0

 

AVG

61.5

94.7

79.5

8.1

73.9

7.4

77.2

76.0

66.8

72.5

68.0

AVG

71.0

 

MED

100.0

100.0

85.0

9.0

80.0

7.5

85.3

89.9

71.4

97.0

90.9

MED

84.2

 

% OF FINAL GRADE

1.0

1.0

5.0

1.0

8.0

1.0

15.0

8.0

15.0

25.0

20.0

 

 

 

 

Test 1 Grades (5% of your final grade):

NIC

Part 1

Part 2

Part 3

Total

107

3

4

2.5

9.5

!BA

3.5

3

2.5

9

CES

3.5

4

2.5

10

CHU

2.5

4

1

7.5

CRA

3.5

4

2.5

10

HAI

3.5

4

2.5

10

HOS

3.5

3

2.5

9

INI

3.5

3

2.5

9

ITM

3

4

1

8

JEW

3.5

4

1

8.5

KUR

3.5

1.5

2.5

7.5

OMN

1.5

3.5

2.5

7.5

RAC

3.5

2

1

6.5

RED

1.5

4

1

6.5

SIN

3.5

2

1

6.5

SNW

1.5

3.5

1

6

SQL

3.5

4

1

8.5

VER

3.5

4

2.5

10

Z

0.5

0

1

1.5

MIN

0.5

0

1

1.5

MAX

3.5

4

2.5

10

AVG

2.92

3.24

1.79

7.95

MED

3.5

4

2.5

8.5

% OF TOTAL

35

40

25

100

 

Music DB ER Design Grades (1% of your final grade):

NIC

Total

107

9.2

!BA

9.0

CES

9.7

CHU

9.0

CRA

9.5

HAI

0.0

HOS

7.6

INI

9.9

ITM

9.5

JEW

9.2

KUR

9.9

OMN

9.0

RAC

0.0

RED

9.0

SIN

8.6

SNW

8.4

SQL

9.0

VER

8.5

Z

8.5

MIN

0.0

MAX

9.9

AVG

8.1

MED

9.0

 

ER Diagrams Grades (8% of your final grade):

NIC

3.21

3.23

3.24

3.25

Total

107

24

13

24

23

84

!BA

18

20

23

21

82

CES

17

25

25

25

92

CHU

23

23

23

22

91

CRA

22

24

18

25

89

HAI

16

20

23

21

80

HOS

0

0

0

0

0

INI

24.5

24.5

25

25

99

ITM

21

25

20

25

91

JEW

17

24

6

21

68

KUR

18

20.5

23

23

84.5

OMN

15

19

0

15

49

RAC

22

13

20

21

76

RED

18

13

25

25

81

SIN

15

14

18

25

72

SNW

17

11

19

15

62

SQL

15

17

25

23

80

VER

17

12

20

25

74

Z

15

19

9

7

50

MIN

0

0

0

0

0

MAX

24.5

25

25

25

99

AVG

17.61

17.74

18.21

20.37

73.92

MED

17

19

20

23

80

 

Music ER Mapping Grades (1% of your final grade):

NIC

Total

107

8.5

!BA

8.0

CES

9.5

CHU

8.0

CRA

9.0

HAI

7.0

HOS

0.0

INI

7.5

ITM

9.5

JEW

8.0

KUR

7.5

OMN

6.5

RAC

8.5

RED

8.5

SIN

7.0

SNW

6.0

SQL

7.5

VER

7.0

Z

7.5

MIN

0.0

MAX

9.5

AVG

7.4

MED

7.5

 

Test 2 Grades (15% of your final grade):

NIC

Part 1

Exe.1

Exe.2.1

Exe.2.2

Exe.2.3

Exe.3.1

Exe.3.2

Exe.3.3

Part 2 - Total

Total

Total CURVED

NIC

107

3.5

26.0

4.5

12.0

10.0

4.5

10.0

12.0

79.0

82.5

97.1

107

!BA

2.0

25.0

4.5

12.0

10.0

5.0

9.5

8.5

74.5

76.5

90.0

!BA

CES

15.5

23.0

5.0

4.0

10.0

5.0

9.0

12.0

68.0

83.5

98.2

CES

CHU

6.5

24.0

4.0

6.0

9.0

5.0

10.0

10.0

68.0

74.5

87.6

CHU

CRA

14.0

30.0

4.5

12.0

10.0

5.0

10.0

11.0

82.5

96.5

100.0

CRA

HAI

0.5

16.0

4.5

2.0

5.0

4.5

7.5

5.0

44.5

45.0

52.9

HAI

HOS

3.0

8.0

1.0

1.0

1.0

5.0

9.0

9.0

34.0

37.0

43.5

HOS

INI

6.5

27.0

4.5

7.5

10.0

1.0

11.0

11.0

72.0

78.5

92.4

INI

ITM

9.0

27.0

5.0

9.0

10.0

5.0

8.0

9.0

73.0

82.0

96.5

ITM

JEW

0.0

28.0

2.5

2.0

1.0

2.0

5.0

11.0

51.5

51.5

60.6

JEW

KUR

2.0

23.0

5.0

10.5

10.0

3.0

9.0

10.0

70.5

72.5

85.3

KUR

OMN

8.0

22.0

5.0

5.0

6.0

5.0

10.0

9.0

62.0

70.0

82.4

OMN

RAC

2.0

25.0

4.5

8.0

10.0

5.0

9.0

5.0

66.5

68.5

80.6

RAC

RED

0.5

20.0

4.5

6.0

0.0

5.0

9.0

6.0

50.5

51.0

60.0

RED

SIN

0.0

23.0

3.0

0.0

0.0

1.0

9.0

8.0

44.0

44.0

51.8

SIN

SNW

-1.5

20.0

4.5

9.0

8.0

4.0

10.0

8.0

63.5

62.0

72.9

SNW

SQL

4.5

27.0

3.0

9.0

10.0

4.5

10.0

7.0

70.5

75.0

88.2

SQL

VER

3.5

24.0

4.5

9.0

8.0

5.0

9.0

10.5

70.0

73.5

86.5

VER

Z

-4.5

16.0

4.5

3.0

6.0

1.0

2.0

6.0

38.5

34.0

40.0

Z

MIN

-4.5

8.0

1.0

0.0

0.0

1.0

2.0

5.0

34.0

34.0

40.0

MIN

MAX

15.5

30.0

5.0

12.0

10.0

5.0

11.0

12.0

82.5

96.5

100.0

MAX

AVG

3.9

22.8

4.1

6.7

7.1

4.0

8.7

8.8

62.3

66.2

77.2

AVG

MED

3.0

24.0

4.5

7.5

9.0

5.0

9.0

9.0

68.0

72.5

85.3

MED

 

SQL Grades (8% of your final grade):

NIC

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

TOTAL

TOTAL CURVED

107

4

4

3

4

4

4

4

4

2.5

4

4

2.5

4

4

4

4

4

3

4

3

4

4

2.5

3.5

4

92

92.9

!BA

3

3

4

4

4

4

4

4

2.5

4

4

4

4

4

4

4

4

4

4

4

4

4

4

3.5

4

96

97.0

CES

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

3

4

4

4

4

4

4

4

99

100.0

CHU

4

3

4

4

4

4

4

4

2.5

4

4

3

2.5

4

4

4

4

3

4

3

3

4

3.5

4

1

88.5

89.4

CRA

4

3

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

4

2.5

3.5

4

97

98.0

HAI

3

2

4

4

4

4

4

2

4

2

4

3

0

4

1.5

4

4

3

4

3

2.5

4

2

3

4

79

79.8

HOS

3

2

2

4

4

4

4

2

2.5

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

27.5

27.8

INI

3

4

3.5

4

4

4

4

4

2

4

4

2.5

4

3.5

4

4

4

3

2

4

4

3

3

4

4

89.5

90.4

ITM

4

4

4

4

4

4

4

4

3

3

4

4

3.5

4

4

4

4

3

4

4

4

4

4

4

4

96.5

97.5

JEW

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

0

0.0

KUR

3

3

2

4

4

4

4

4

2.5

2

3

3

3

3

3

3

3

2

4

3

2.5

4

1.5

3.5

4

78

78.8

OMN

3

2

3.5

4

4

4

4

2

2.5

4

4

2

0

4

1.5

0

1.5

3

2

3

4

3

1

3.5

4

69.5

70.2

RAC

3

3

4

4

4

4

4

4

4

2

4

3

3

4

4

4

4

3

4

3

4

4

2.5

2.5

4

89

89.9

RED

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

0

0.0

SIN

3

3

3.5

4

4

4

4

4

3

4

4

3.5

4

4

4

4

4

3

2

4

4

3

4

4

4

92

92.9

SNW

3

3

2

4

4

4

4

4

2.5

2

3

3

3

3

3

3

3

2

4

3

2.5

4

1.5

3.5

4

78

78.8

SQL

4

2

4

4

4

3.5

4

3

1

2

4

3

3

3

2

4

4

3.5

2

3

3

2.5

1.5

2

3

75

75.8

VER

3

3

4

4

4

4

4

4

4

3

4

4

4

4

4

4

4

3

2

4

4

4

2.5

4

4

92.5

93.4

Z

4

4

3.5

4

4

4

4

4

3

4

4

3

2.5

4

4

4

4

3

2

4

4

4

3

2.5

4

90.5

91.4

MIN

3.0

2.0

2.0

4.0

4.0

3.5

4.0

2.0

1.0

2.0

3.0

2.0

0.0

3.0

1.5

0.0

1.5

2.0

2.0

3.0

2.5

2.5

1.0

2.0

1.0

0.0

0.0

MAX

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

4.0

99.0

100.0

AVG

3.4

3.1

3.5

4.0

4.0

4.0

4.0

3.6

2.9

3.3

3.9

3.2

3.0

3.8

3.4

3.6

3.7

3.0

3.3

3.5

3.6

3.7

2.7

3.4

3.8

75.2

76.0

MED

         3.00

         3.00

         4.00

         4.00

         4.00

         4.00

         4.00

         4.00

         2.50

         4.00

         4.00

         3.00

         3.25

         4.00

         4.00

         4.00

         4.00

         3.00

         4.00

         3.50

         4.00

         4.00

         2.50

         3.50

         4.00

89.00

89.9

 

Test 3 Grades (15% of your final grade):

NIC

Part 1

Exe.1.1

Exe.1.2

Exe.1.3

Exe.2

Exe.3

Part 2 - Total

Total

Total CURVED

NIC

107

6.5

14.0

15.0

19.0

25.0

10.0

83.0

89.5

100.0

107

!BA

7.5

10.0

7.0

20.0

18.0

10.0

65.0

72.5

100.0

!BA

CES

8.0

12.0

7.0

18.0

14.0

10.0

61.0

69.0

98.6

CES

CHU

3.5

10.0

7.0

20.0

7.0

0.0

44.0

47.5

67.9

CHU

CRA

6.0

15.0

7.0

19.5

25.0

0.0

66.5

72.5

100.0

CRA

HAI

8.0

10.0

10.0

0.0

19.0

10.0

49.0

57.0

81.4

HAI

HOS

-5.0

14.0

7.0

7.0

16.0

0.0

44.0

39.0

55.7

HOS

INI

-1.0

12.0

5.0

16.0

19.0

0.0

52.0

51.0

72.9

INI

ITM

-2.0

10.0

10.0

10.0

16.0

3.0

49.0

47.0

67.1

ITM

JEW

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

JEW

KUR

3.5

13.5

15.0

5.0

6.0

0.0

39.5

43.0

61.4

KUR

OMN

-1.0

13.5

12.0

6.0

8.0

6.0

45.5

44.5

63.6

OMN

RAC

3.0

14.0

10.0

10.0

13.0

0.0

47.0

50.0

71.4

RAC

RED

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

RED

SIN

0.0

10.0

3.0

13.0

17.0

0.0

43.0

43.0

61.4

SIN

SNW

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

SNW

SQL

7.0

11.0

7.0

19.0

11.0

5.0

53.0

60.0

85.7

SQL

VER

5.5

15.0

7.0

17.0

23.0

5.0

67.0

72.5

100.0

VER

Z

1.0

15.0

7.0

17.0

14.0

5.0

58.0

59.0

84.3

Z

MIN

-5.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

0.0

MIN

MAX

8.0

15.0

15.0

20.0

25.0

10.0

83.0

89.5

100.0

MAX

AVG

2.7

10.5

7.2

11.4

13.2

3.4

45.6

48.3

66.9

AVG

MED

3.0

12.0

7.0

13.0

14.0

0.0

49.0

50.0

71.4

MED

 

Projects Grades (25% of your final grade):

PROJECT

System Requirements

Contextual DFD

ER in Min, Max notation

Rationale for DBMS

Normalized & Implementation-ready Models

Data Dictionary

SQL

Documentation

Presentation

Bonus for NON-PROFIT

TOTAL

Restaurant

15

4

20

4

25

5

12

5

5

 

95

Daycare

14

5

19

4

25

5

15

5

5

 

97

MMORPG

15

4

20

4

25

5

15

5

5

 

98

WSC

15

5

20

5

25

5

15

5

5

5

105

CORONA

15

5

20

4

25

5

15

5

5

5

104

Blood Drive

13

5

20

0

25

5

12

5

5

 

90

Clinic

15

5

20

5

25

5

12

5

4

 

96

Quiz Sys.

15

5

20

5

25

5

15

5

5

 

100

Hockey

15

5

20

5

25

5

12

5

5

 

97

MIN

13.0

4.0

19.0

0.0

25.0

5.0

12.0

5.0

4.0

5.0

90.0

MAX

15.0

5.0

20.0

5.0

25.0

5.0

15.0

5.0

5.0

5.0

105.0

AVG

14.7

4.8

19.9

4.0

25.0

5.0

13.7

5.0

4.9

5.0

98.0

MED

15.0

5.0

20.0

4.0

25.0

5.0

15.0

5.0

5.0

5.0

97.0

 

Final Exam Grades (20% of your final grade):

NIC

Part 1

Exe. 5

Exe. 6

Exe. 7

Exe. 8.a

Exe. 8.b

Exe. 8.c

Exe. 8.d

Part 2 - Total

Total

Total CURVED

NIC

107

16.0

20.0

20.0

10.0

5.0

5.0

11.0

12.0

83.0

99.0

100.0

107

!BA

12.0

17.5

20.0

10.0

5.0

5.0

10.0

12.0

79.5

91.5

92.4

!BA

CES

16.0

18.5

20.0

10.0

5.0

5.0

12.0

12.0

82.5

98.5

99.5

CES

CHU

12.0

19.5

18.5

10.0

5.0

5.0

12.0

12.0

82.0

94.0

94.9

CHU

CRA

16.0

20.0

19.5

10.0

5.0

5.0

12.0

12.0

83.5

99.5

100.0

CRA

HAI

 

 

 

 

 

 

 

 

0.0

0.0

HAI

HOS

12.0

19.5

18.5

10.0

5.0

5.0

12.0

10.0

80.0

92.0

92.9

HOS

INI

12.0

18.5

19.5

10.0

5.0

5.0

12.0

12.0

82.0

94.0

94.9

INI

ITM

16.0

19.0

20.0

5.0

5.0

5.0

10.0

10.0

74.0

90.0

90.9

ITM

JEW

 

 

 

 

 

 

 

 

0.0

0.0

JEW

KUR

 

 

 

 

 

 

 

 

0.0

0.0

KUR

OMN

12.0

18.0

17.5

10.0

4.5

5.0

7.0

10.0

72.0

84.0

84.8

OMN

RAC

16.0

17.5

19.5

10.0

5.0

5.0

7.0

12.0

76.0

92.0

92.9

RAC

RED

 

 

 

 

 

 

 

 

0.0

0.0

RED

SIN

4.0

15.5

16.0

10.0

4.5

5.0

8.5

11.0

70.5

74.5

75.3

SIN

SNW

 

 

 

 

 

 

 

 

0.0

0.0

SNW

SQL

8.0

17.0

17.5

10.0

5.0

5.0

12.0

12.0

78.5

86.5

87.4

SQL

VER

16.0

19.0

18.5

10.0

5.0

5.0

12.0

12.0

81.5

97.5

98.5

VER

Z

12.0

18.0

17.5

10.0

5.0

5.0

7.0

12.0

74.5

86.5

87.4

Z

MIN

4.0

15.5

16.0

5.0

4.5

5.0

7.0

10.0

0.0

0.0

0.0

MIN

MAX

16.0

20.0

20.0

10.0

5.0

5.0

12.0

12.0

83.5

99.5

100.0

MAX

AVG

12.9

18.4

18.8

9.6

4.9

5.0

10.3

11.5

57.9

67.3

68.0

AVG

MED

12.0

18.5

19.0

10.0

5.0

5.0

11.5

12.0

76.0

90.0

90.9

MED