Welcome

Anti Essays offers essay examples to help students with their essay writing.

Sign Up

Chapter 5 Essay

  • Submitted by: mjohnson2490
  • on April 1, 2014
  • Category: Miscellaneous
  • Length: 411 words

Open Document

Below is an essay on "Chapter 5" from Anti Essays, your source for research papers, essays, and term paper examples.

2. . Give an example of a column A and a column B such that B is functionally dependent on A. Give an example of a column C and a column D such that D is not functionally dependent on C.
Student ‘s address is dependent on the student’s number.   The student’s address is not dependent on the student’s name.
4. Define candidate key.
A candidate key is a column or a collection of columns on which all columns in the table are functionally dependent; the defini-tion for primary key also defines a candidate key.
6. Define second normal form. What types of problems would you find in tables that are not in second normal form?
A table is in second normal form if it is in first form and no non-key column is dependent on only a portion of the primary key.  
If a table isn’t in second normal form, redundant data will cause wasted space and update problems.   A major problem can occur with inconsistent data.
8. Define fourth normal form. What types of problems would you find in tables that are not in fourth normal form?
A table is in fourth normal form if it is in third normal form and there are no multivalued dependencies.   If a table isn’t in fourth normal form, redundant data will cause space to be wasted and problems in updating.   A major problem can occur with inconsistent data.
10. Consider a Student table containing StudentNum, StudentName, student’s StudentMajor, student’s AdvisorNum, student’s AdvisorName, student’s AdvisorOfficeNum, student’s AdvisorPhone, student’s NumCredits, and stu-dent’s Class (freshman, sophomore, and so on). List the functional dependencies that exist, along with the assumptions that would support those dependencies.
StudentNum           StudentName, StudentMajor, AdvisorNum,
AdvisorName, AdvisorOfficeNum, AdvisorPhone,
NumCredits, Class
AdvisorNum           AdvisorName, AdvisorOfficeNum, AdvisorPhone,
NumCredits             Class
Some assumptions are: Class is determined by the number of credits a student has earned, Advisor...

Show More


Citations

MLA Citation

"Chapter 5". Anti Essays. 13 Dec. 2018

<http://trenmayamx.com/free-essays/Chapter-5-602788.html>

APA Citation

Chapter 5. Anti Essays. Retrieved December 13, 2018, from the World Wide Web: http://trenmayamx.com/free-essays/Chapter-5-602788.html