Database DesignsUsing the types of entities found in the attached database (trips, guides, customers, and reservations), create an example of a table that is in first normal form but not in second normal form, justify your answer and show how to convert to the higher forms Customer TableCUSTOMERCUSTOMER_NUM LAST_NAME FIRST_NAME ADDRESSCITYSTATE POSTAL_CODE PHONEGuide TableGUIDEGUIDE NUM LAST NAME FIRST NAME ADDRESSSTATE POSTAL, CODE PHONE_NUM HRE DATECITYReservation TableRESERVATION_ ID TRIP_ID TRIP_DATE NUM_PERSONS TRIP_PRICE OTHER_FEES CUSTOMER_NUMTrip TableTRIPTRIP_ID TRIP_NAMESTATE DISTANCE MAX_GRP_SIZE TYPESTART LOCATIONSEASONTrip Guide TablelTRIP_GUIDESTRIP_ID GUIDE_NUM

Normalization and Normal Forms - Normalization in the database is a process to reduce and remove…

Answered: Using the types of entities found in…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Database Designs

Using the types of entities found in the attached database (trips, guides, customers, and reservations), create an example of a table that is in first normal form but not in second normal form, justify your answer and show how to convert to the higher forms