Using the types of entities found in the henry

Assignment Help Basic Computer Science

Reference no: EM13726411

Using the types of entities found in the Henry Books database (books, authors, and publishers), create an example of a table that is in first normal form but not in second normal form and an example of a table that is in second normal form but not in third normal form. In each case, justify your answers and show how to convert to the higher forms.
2. Henry Books is considering selling textbooks to a local college. To do so, it must maintain information about courses, textbooks, and instructors. Determine the multivalued dependencies in the following table, and then convert this table to an equivalent collection of tables that are in fourth normal form. Each course is associated with a specific set of textbooks independent of the instructors who are teaching the course. In other words, although many instructors may be teaching the course, they all will use the same set of textbooks.
   Course (CourseNum, Textbook, InstructorNum, InstructorName)
3. The following unnormalized table is similar in content to the table in Exercise 2. Note that this table has two separate repeating groups: one listing the textbooks used for the course and the other listing the instructors who teach the course. Convert it to fourth normal form. Did you encounter the table from Exercise 2 along the way?
   Course (CourseNum, Description, NumCredits, (Textbook), (InstructorNum, InstructorName) )
4. Identify the functional dependencies in the following unnormalized table. Convert the table to third normal form. Is the result also in fourth normal form? Why or why not?
   Book (BookCode, Title, PublisherCode, PublisherName, (AuthorNum, AuthorLast, AuthorFirst) )

1. Using the types of entities found in the Alexamara Marina Group database (marinas, owners, boat slips, categories, and service requests), create an example of a table that is in first normal form but not in second normal form and an example of a table that is in second normal form but not in third normal form. In each case, justify your answer and show how to convert to the higher forms.
2. Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form:
   Marina (MarinaNum, Name, (SlipNum, Length, RentalFee, BoatName) )
3. Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form:
   MarinaSlip (SlipID, MarinaNum, SlipNum, Length, RentalFee, BoatName, BoatType, OwnerNum, LastName, FirstName

Reference no: EM13726411

Questions Cloud

Diversity in the workplace and work-life balance : Research the Internet or the Strayer Library for articles on issues of work / life balance in other countries (particularly European countries). Diversity in the Workplace and Work-Life Balance

Differences between total exports versus total imports : Compare the fundamental differences between total exports versus total imports

What is the value of assuming this mortgage : Suppose we are assuming a $5 million 20-year mortgage with 8 years remaining at a rate of 4%. If we could obtain a new 8-year mortgage for 5%, what is the value of assuming this mortgage?

Discuss three aspects of us history : Discuss three aspects of US history since 1865 that have led to the USA's rise as a world super power policeman. Identify three to five international incidents since World War II where America has taken on a policing role.

Using the types of entities found in the henry : Using the types of entities found in the Henry Books database (books, authors, and publishers), create an example of a table that is in first normal form but not in second normal form and an example of a table that is in second normal form but ..

Write about income inequality in the u.s. : Read the articles provided on moodle and write about income inequality in the U.S. One of the best ways of doing this is to start summarizing the articles.

Calculate the finance charge and monthly payment : Zachary Porter of Highland Heights, Kentucky, is contemplating borrowing $10,000 from his bank. The bank could use add-on rates of 6.5 percent for 3 years, 7 percent for 4 years, and 8 percent for 5 years. Use Equation 7.1 to calculate the finance ch..

Examine the components of a marketing plan : Examine the components of a marketing plan. Determine the component you believe to be the most important and the component you believe to be the least important. Provide a rationale for your response

Calculates the velocity and momentum of an object : Write a program that does the following: Calculates the Velocity and Momentum of an object. The formula for the velocity is V=d/t and the formula for Momentum is m=mass*velocity. Your program should consist of two functions: Passing By Values (..

User Account

All Pages