Topic: Database Design It is known that can use the DBMS system to create a surrogate primary key when there is a natural key. What implications does this have on the DB performancewhen searching the table for a specific column (such as ROOM). Hint: When the table is created, the DBMS setups the table to be able to search on the primary key very quickly. What if this Event table was used by a Corporate Hotel chain to keep track of every they have hosted over the past 30 years in all of their hotels across all their chains (i.e. 8000 locations, 5 events a week avg, 30 years of data ~62.4 million events)?

Question

Topic: Database Design

It is known that can use the DBMS system to create a surrogate primary key when there is a natural key. What implications does this have on the DB performancewhen searching the table for a specific column (such as ROOM). Hint: When the table is created, the DBMS setups the table to be able to search on the primary key very quickly. What if this Event table was used by a Corporate Hotel chain to keep track of every they have hosted over the past 30 years in all of their hotels across all their chains (i.e. 8000 locations, 5 events a week avg, 30 years of data ~62.4 million events)?