A
Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcoming training session.
Write a paper in which you:
- Describe the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form.
- Provide one example that is relevant to a college environment that illustrates reasons for converting database tables to the First, Second, and Third Normal Forms.
- Explain typical situations when denormalizing a table is acceptable. Provide one example of denormalizing a database table to justify your response.
- Explain the significant manner in which business rules impact both database normalization and the decision to denormalize database tables.
- Use at least three quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
- This course requires use of Strayer Writing Standards (SWS). The format is different than other Strayer University courses. Please take a moment to review the SWS documentation for details.
- Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date.
