Using the types of entities found in the Colonial Adventure Tours database (trips, guides, clients, and reservations), 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.

Question
Asked Oct 7, 2019
57 views

Using the types of entities found in the Colonial Adventure Tours database (trips, guides, clients, and reservations), 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.

check_circle

Expert Answer

Step 1

The Set of entities provided for Colonial Adventure Tours Database includes Trips, Guides, Clients and Reservations. Now, A table is in first normal form if,

  • It contains a primary key which can uniquely identify all its record
  • There is no grouped data present.

A table is in second normal form if,

  • It is in first normal form
  • There is no partial dependency i.e. all non-prime attributes should be functionally dependent on whole of primary key and not on a part of it.

A table is in third normal form if,

  • It is in second normal form
  • There is no transitive dependency i.e. no non-prime attribute should be determined by another non-prime attribute. 
Step 2

Example of table using entities of the given database which is in first normal form and not in second normal will be a table which includes some attributes having partial dependency. Following is an example of such table.

Here attributes LastName and FirstName are dependent GuideNum while attributes TripName, StartLocation and Distance are dependent on TripID. Therefore, there is partial dependency in ...

help_outline

Image Transcriptionclose

GuideNum| LastName | FirstName StartLocation Distance TripName TripID

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Engineering

Computer Science

Databases

Related Computer Science Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Hi I was given help with the problem with the java programming   Generate a random number in java be...

A: A java program to check whether the user’s input is a factor of random number generated, is given be...

question_answer

Q: Given the following snippet of C++ code: int int1 = -125;unsigned int uInt1 = int1;float float1 = in...

A: The variables are stored in the following format:int1 is a signed int type variable and 32 bits long...

question_answer

Q: I am getting stuck on the code to see if its a factor or not. Im not sure where I went wrong.

A: The following is the source code which prints whether a number is a factor of generated random numbe...

question_answer

Q: What is an example of an if else statement in C#?

A: The syntax for if-else statement in C# is:if(boolean_expression) {// stataments} else {   // statame...

question_answer

Q: I have a HW that is asking me to draw on ERD diagram for a simple purchasing system that has order w...

A: ERD diagram for Purchasing System:The ERD diagram for the simple purchasing system is as follows:

question_answer

Q: Consider the following procedure: procedure mystery (x, y, z); integer x, y, z;beginz =2; y = z + x;...

A: Call by reference The arguments passed to a function will copy the address of an argument into the f...

question_answer

Q: I can't figure this one out for the life of me. I've been stuck on it for 4 hours now... HELP! The p...

A: import re inputs = 0numbers_sum = 0 # enter the stringstring = input('Enter a string: ') # condition...

question_answer

Q: I am trying to write a java code to see if the number entered by the user is a factor of the random ...

A: The following source code will print whether a number is a factor of generated random number or not ...

question_answer

Q: Explain in at least a paragraph what are considered pervasive security infrastructure risks

A: Pervasive security infrastructure refers to cloud security risks. As many users possibly from differ...