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

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*ve

Generalized statements relating to a group of people

Identify the rhetorical strategy in each of the following statements. 1. I did not say the meat was tough. I said I did not see the horse that is usually outside (W. C.

Problem related to computer architecture

For snoopy bus control what will happen on CPU A for a line in the shared state if there is a miss on CPU A for another memory cell that also maps to that line you assume CP

Questions based on computer science

Which of these statements are true, for propositional logic? (In an exam you would have to justify your answers). A. If a formula is not satisfiable then it is not valid B. X

Questions of true and false

Question 1: The are 6 generations of computer languages Selected Answer: 1- True 2- False Question 2: As discussed in class the computer memory can be divided in RAM

What criteria must be met for a binomial probability

Describe and discuss the difference between the various types of discrete probability distributions. What criteria must be met for a binomial probability distribution? Whic

Explain the three main channels

Explain the three main channels (not the Fed's tools: omo, rr, dr) through which the Fed can influence economic activity. Specifically explain the ways that Fed policy ca

Assignment related to excel

1. Use the "Select All" button and the "bold" buttons to bold the entire worksheet. 2. Design and create your own Company name and worksheet title 3. Enter column titles (Sal

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd