Design an implementation approach for the database design process to the Kelsey Elementary School.

                                                                                                                          Include recommendations on how the Kelsey Elementary School should design and implement these processes and approaches. Ensure that the processes and approaches that you recommend address the phases of the database design process, including the following:                                                                                                               o Conceptual design of the database                                                                                              •  Data analysis and requirements                                                                                              • Entity relationship modeling and normalization                                                             • Data model verification                                                                                                              • Distributed database design      

Sheet1

2/25/13

2/19/13 2/25/13 Derrick

2/26/13 3/4/13

2/26/13 3/4/13 George

2/26/13 3/4/13

2/26/13 3/4/13 John

Val

3/5/13 3/11/13 Tavie

Tavie

3/12/13 3/18/13 Val

Task

Start Date

Completion Date

Responsible Team Member

Define the business goals, objectives, and needs that the database management system will meet in Kelsey Elementary School.

2/19/20013

2/25/13

Val

Create a staffing model to support database administration and development in the IT organization.

2/19/13

Derrick

Document the use of a Microsoft® Visio® diagram as an entity relationship diagram (ERD) modeling tool for the IT orgainization.

Define the standards, polices, and practices that the Kelsey Elementary School should put in place to use a Microsoft Visio diagram for ERD within the orgainzation.

2/26/13

3/4/13

Tavie

Design an implementation approach for the database design process to the Kelsey Elementary School. Include recommendations on how the Kelsey Elementary School should design and implement these processes and approaches. Ensure that the processes and approaches that you recommend address the phases of the database design process, including the following: o Conceptual design of the database • Data analysis and requirements • Entity relationship modeling and normalization • Data model verification • Distributed database design

George

o Database management system (DBMS) selection o What does a DBMS do? o Why did you pick this DBMS to meet the Kelsey Elementary School’s requirements? o How does the DBMS integrate with the rest of the technology infrastructure in the organization?

• Define integrity and security measure. • Determine performance measures. • Define backup and recovery processes.

John

o How the organization will meet database application and reporting requirements

A team progress report to your instructor explaining what your team accomplished during the week, challenges your team faced, and questions.

3/5/13

3/11/13

Draft the following for Kelsey Elementary School’s Database • Logical database design • Physical database design • How the organization will meet database application and reporting requirements

Compile final paper. Write your paper and presentation for an executive audience. Include justification, rationale, advantages, and examples to support the analysis and recommendations that your team is presenting to senior management in your team’s paper and presentation.

3/12/13

3/18/13

Design a power point reflecting database project.

Val:

Sheet2

Sheet3

2

>Sheet

1

1 2

1 2

2 4 6 4

2 4 6 4

1 2 7 6

1 2 7 6

1 3 6 6

2 5 5 4

2 6 4 4

2 4 6 4

1 2 7 6

Post Project

Survey Results

Scale

3

4

Question 1

7

6

Question 2

Question 3

Question 4

Question

5

Question 6

Question 7

Question 8

Question 9

Question 10

Step 1: CLICK this BOX
Step 2: SAVE this spreadsheet to your computer

Sheet2

Sheet3

Sheet1

54

moved

83 81

79 88

69

79 79

83

92 69

98

93 93

95 98 72

new

97

98

53

52 53

82

92

90 86 88 56

96 100 95

93 93 96

90

new

Post Project	Standard Test Scores
Name	Math	Reading	Writing	PE
Alex				79			88	85		54
Anthony	42			83	77
Blair		moved
Brooke	40		52	48		81
Carmen	91			95				98	46
Charlita
Christina	84					93			new
Douglas	89		86
Jorge		72			69	60
Joshua		82
Kim			92		97
Latisha			90
Li		100
Olga	39	49			53	12
Rachel	87			96
Robert	35		56	38
Rupert	55	28
Sara	99	43
Seth
Sheetal	13
Tawayna	70	68	61	33
Wayne	66
William	75	94	65

Step 1: CLICK this BOX
Step 2: SAVE this spreadsheet to your computer

Sheet2

Sheet3

2

>Sheet

1

ssignments

ard

iscipline

Math Reading Writing

B B

C B C

2

C D D

100 A A A

moved

X

91 91 B B B

1 X

B B B

4 X 82

C C C

5

89 90 B B B

2 92

A A A

0 100 90 92 A B B

1 97 100 100 A A A

new X

7

F F

2

95 A A A

59 F D F

4 X 72

67 C D D

3 97 100 94 B A A

0 99

99 B B B

0 99 100 99 A A A

X

C C D

1 100 100 100 A B A

new

98 93 C A B

Post Project	Homework/																					A	Report										C
Name	Absences							D		Math		Reading		Writing
Alex	6			92		9	5	9		4																					B
Anthony	22	79	84		82
Blair		moved
Brooke							X	55	56		59
Carmen				0		98										100
Charlita
Christina			new			91
Douglas	87	95			90
Jorge	68		72
Joshua		89
Kim			97					99
Latisha
Li
Olga		3	46	63					F
Rachel		94	96
Robert	42	60	62
Rupert		67
Sara
Seth		93
Sheetal
Tawayna	16	85	76	74
Wayne
William	73

Step 1: CLICK this BOX
Step 2: SAVE this spreadsheet to your computer
Douglas talks too much and is disruptive.
Jorge has had several fights and has been known to steal.

Sheet2

Sheet3

2

>Sheet

1

1 2

2

4 4

2

3 3

2 8 3 3

2

4 3

2 6 4 4

2

4 0

2 7 4 3

2 6 4 4

2 7 4 3

2 8 3 3

Pre Project

Survey Results

Scale

3

4

Question 1

6

Question 2

8

Question 3

Question 4

7

Question 5

Question 6

1

0

Question 7

Question 8

Question 9

Question 10

Step 1: CLICK this BOX
Step 2: SAVE this spreadsheet to your computer

Sheet2

Sheet3

Sheet1

73

43

51

86

77

76 79

71

79

91

92

71

91

95

48

54

82 93 95 39

91

87 61

97 95

67 54

94

100

Pre Project	Standard Test Scores
Name	Math	Reading	Writing	PE
Alex		76	78	84		51
Anthony		43		73	53
Blair	66		67			71		93
Brooke		39	37		77
Carmen	96				91	98	46
Charlita	47	57	23
Douglas	80	81		86
Jorge		61	58	70	56
Joshua			79
Kim		92		94		97
Latisha		87		82
Li		100				95
Rachel	85	90
Robert	38		48	42
Rupert			54	55	24
Sara
Seth	88
Sheetal	99	14
Tawayna	64	33
Wayne	89	69

Step 1: CLICK this BOX
Step 2: SAVE this spreadsheet to your computer

Sheet2

Sheet3

2

>Sheet

1

ssignments

ard

iscipline

Math Reading Writing

85

B B

C B C

3 74

C C C

2

53 C D D

100 A A A

D D D

1 X

85 B B B

4 X

71 69 C C C

5

87 B B B

2

99

A A A

0

A B B

1 100 100 100 A A A

2 89

A A A

57

57

D F

4 X 67

67 C D D

3

100 95 B A A

0 91 95 95 B B B

0 100 95 99 A A A

X 81

73 C C D

1 100 100 96 A B A

Pre Project	Homework/																				A	Report												C
Name	Absences										D		Math		Reading		Writing
Alex		5		87			85																	B
Anthony	18		71	8		3		7		4
Blair	82	77
Brooke					X			57		53
Carmen				0			99									100
Charlita	16		69	65			67
Douglas	84	90
Jorge	72
Joshua	86		81
Kim		89					95
Latisha	98	88	93
Li
Rachel		96		91
Robert	37	52		F
Rupert	60
Sara	92
Seth
Sheetal
Tawayna	14		73
Wayne

Step 1: CLICK this BOX
Step 2: SAVE this spreadsheet to your computer
Douglas talks too much and is disruptive.
Jorge has had several fights and has been known to steal.

Sheet2

Sheet3