Supposethat you are the database developer for a local college. The Chief InformationOfficer (CIO) has asked you to provide a summary of normalizing database tablesthat the IT staff will use in the upcoming training session.
Writea two to three (2-3) page paper in which you:
- Describe thesteps that you would use in order to convert database tables to the FirstNormal Form, the Second Normal Form, and the Third Normal Form.
- Provide one (1) examplethat is relevant to a college environment that illustrates reasons for convertingdatabase tables to the First, Second, and Third Normal Forms.
- Explain typical situationswhen denormalizing a table is acceptable. Provide one (1) example ofdenormalizing a database table to justify your response.
- Explain the significantmanner in which business rules impact both database normalization and thedecision to denormalize database tables.
- Use at leastthree (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as qualityresources.
Yourassignment must follow these formatting requirements:
- Be typed, doublespaced, using Times New Roman font (size 12), with one-inch margins on allsides; citations and references must follow APA or school-specific format.Check with your professor for any additional instructions.
- Include a coverpage containing the title of the assignment, the student’s name, theprofessor’s name, the course title, and the date. The cover page and thereference page are not included in the required assignment page length.
Thespecific course learning outcomes associated with this assignment are:
· Recognizethe purpose and principles of normalizing a relational database structure.
· Designa relational database so that it is at least in 3NF.
· Usetechnology and information resources to research issues in database systems.
· Writeclearly and concisely about relational database management systems using properwriting mechanics and technical style conventions.
Gradingfor this assignment will be based on answer quality, logic / organization ofthe paper, and language and writing skills, using the following rubric.
Points:100
Assignment2: Normalization
Criteria
Unacceptable
Below 60% F
Meets Minimum Expectations
60-69% D
Fair
70-79% C
Proficient
80-89% B
Exemplary
90-100% A
1.Describe the steps that you would use in order to convert database tables tothe First Normal Form, the Second Normal Form, and the Third Normal Form.
Weight:21%
Didnot submit or incompletely described the steps that you would use in order toconvert database tables to the First Normal Form, the Second Normal Form, andthe Third Normal Form.
Insufficientlydescribed the steps that you would use in order to convert database tables tothe First Normal Form, the Second Normal Form, and the Third Normal Form.
Partiallydescribed the steps that you would use in order to convert database tables tothe First Normal Form, the Second Normal Form, and the Third Normal Form.
Satisfactorilydescribed the steps that you would use in order to convert database tables tothe First Normal Form, the Second Normal Form, and the Third Normal Form.
Thoroughlydescribed the steps that you would use in order to convert database tables tothe First Normal Form, the Second Normal Form, and the Third Normal Form.
2.Provide one (1) example that is relevant to a college environment thatillustrates reasons for converting database tables to the First, Second, andThird Normal Forms.
Weight: 21%
Didnot submit or incompletely provided one (1) example that is relevant to a collegeenvironment that illustrates reasons for converting database tables to theFirst, Second, and Third Normal Forms.
Insufficientlyprovided one(1) example that is relevant to a college environment that illustratesreasons for converting database tables to the First, Second, and Third NormalForms.
Partiallyprovided one(1) example that is relevant to a college environment that illustratesreasons for converting database tables to the First, Second, and Third NormalForms.
Satisfactorilyprovided one(1) example that is relevant to a college environment that illustratesreasons for converting database tables to the First, Second, and Third NormalForms.
Thoroughlyprovided one(1) example that is relevant to a college environment that illustratesreasons for converting database tables to the First, Second, and Third NormalForms.
3.Explain typical situations when denormalizing a table is acceptable. Provideone (1) example of denormalizing a database table to justify your response.
Weight:21%
Didnot submit or incompletely explained typical situations when denormalizing a tableis acceptable. Did not submit or incompletely provided one (1) example ofdenormalizing a database table to justify your response.
Insufficientlyexplained typical situations when denormalizing a table is acceptable. Insufficientlyprovided one (1) example of denormalizing a database table to justify yourresponse.
Partiallyexplained typical situations when denormalizing a table is acceptable. Partiallyprovided one (1) example of denormalizing a database table to justify yourresponse.
Satisfactorilyexplained typical situations when denormalizing a table is acceptable. Satisfactorilyprovided one (1) example of denormalizing a database table to justify yourresponse.
Thoroughlyexplained typical situations when denormalizing a table is acceptable. Thoroughlyprovided one (1) example of denormalizing a database table to justify yourresponse.
4.Explain the significant manner in which business rules impact both databasenormalization and the decision to denormalize database tables.
Weight:21%
Didnot submit or incompletely explained the significant manner in which businessrules impact both database normalization and the decision to denormalizedatabase tables.
Insufficientlyexplained the significant manner in which business rules impact both databasenormalization and the decision to denormalize database tables.
Partiallyexplained the significant manner in which business rules impact both databasenormalization and the decision to denormalize database tables.
Satisfactorilyexplained the significant manner in which business rules impact both databasenormalization and the decision to denormalize database tables.
Thoroughlyexplained the significant manner in which business rules impact both databasenormalization and the decision to denormalize database tables.
5.3 references
Weight:6%
Noreferences provided
Doesnot meet the required number of references; all references poor qualitychoices.
Doesnot meet the required number of references; some references poor qualitychoices.
Meetsnumber of required references; all references high quality choices.
Exceedsnumber of required references; all references high quality choices.
6.Clarity, writing mechanics, and formatting requirements
Weight:10%
Morethan 8 errors present
7-8errors present
5-6errors present
3-4errors present
0-2errors present
