Discuss the concept of the intersection table

Assignment Help Database Management System
Reference no: EM131340348

Database Design Discusion Posts

Part 1 Initial Post

Referential Integrity and Intersection Table

Hello Class! Please respond to BOTH of the following questions:

Question A

Referential integrity "rules" trigger some cleanup of your data when insertion, update, or deletion events would typically cause data anomalies. But the word "trigger" has its own place in database design and implementation. Research the concept of a "trigger" and compare and contrast "trigger" events with referential integrity rules.

Question B

Discuss the concept of the intersection table. Why is it needed in many to many relationships? Why is intersection data needed?

PART 2 Peer Responces

Respond to both peers discusion posts

Peer #1 Bill

Triggers are somewhat like a procedure is in computer languages such as a Java or JavaScript. Triggers are able to perform a few different functions whenever the operation is called; Insert, Update, Delete, Create, Alter, or perform events such as logon and off or startup and shutdown. Trigger events assist tables with referential integrity by maintaining their orphaned records. That is, inserting a child record when no parent record exists; deleting a parent record, and leave the child record alone; and changing a parent's record's pk value so that the fk no longer point to a valid parent record.

An intersection table provides an intersection between two components and is a table that defines many-to-many relationships. The intersection table is also created as another table to eliminate many-to-many relationships of two tables. The table contains two foreign keys that defines the many-to-many relationship between two separate tables.

Peer #2 John

Referential integrity rules are used when you want to update, insert, or delete information in certain tables. For instance, Figure 5.13 Saleperson and Office 1:1 relation table, were one office is occupied with one and only one Saleperson. If Saleperson 361 that occupies office 1227 is relocated to another building, then once the Saleperson is deleted from office 1227 in the office table it will be updated in the Saleperson table for Saleperson 361. Thus office 361 is vacant and can be use.

Triggers are used normally executed when an event associated with a specific table occurs in conjunction with an insert, delete, or update. You can also have the trigger execute before or after an update, deletion, or insert request for a table. For instance if we use Figure 5.14 of the General Hardware Company relational database. If a customer want to purchase a specific product form a company I would want to check to see if that company had that item in stock first. I would place a trigger on products table. The trigger would check the current stock of the item before the item is placed in the customer's checkout cart.

An intersection table is needed between a many to many relationship because it brings together information from two tables and gives it substance. You need an intersection table in order to account for the many to many relations of the entities or values that you want to represent in the table. For instance, you can have a Student table and a Class table. Since many students can be enrolled in multiple classes and Classes can have multiple Students you need to be able to represent and account for those values. If you put the PK of Students in the Class table you could not properly represent all of the students that are in a particular class because the cell can only hold one value and the same thing holds for the PK for the Classes in the Students table. So the best option you have is to put the PK for both Classes and Students in an intersection table in order to account for the multiple students and classes that with multiple values.

Reference no: EM131340348

Questions Cloud

What was the evo diet experiment : What was the Evo Diet experiment? What were its implications?Why does Wrangham think raw food is not as nutritious for modern humans as cooked food? What are the implications of the Raw Foodist/Giessen Raw Food study: (what happens to BMI as propo..
How to maintain the printers : Compare at least three print technologies. Criteria to address includes, but is not limited to: Different maintenance needs. How to maintain the printers.
Calculate the internal resistance : A battery has a terminal voltage of 1.8 V when supplying a current of 9 A. This voltage rises to 2.02 V when the load is removed. Calculate the internal resistance.
Describe computer algorithms and its significance : Explain computer algorithms and its significance. Explain some of the technologies that have contributed to the exponential growth of the Internet and the World Wide Web (WWW).
Discuss the concept of the intersection table : Discuss the concept of the intersection table. Why is it needed in many to many relationships? Referential integrity "rules" trigger some cleanup of your data when insertion, update, or deletion events would typically cause data anomalies.
Define the following concepts given below : With the links below, please define the following concepts using an example such as Darwin's finches, the Lemurs of Madagascar, flowering plants of Hawaii etc).common ancestor,adaptive radiation.
What is the climax of the text : What point-of-view is the text written in? Is the narrator reliable or unreliable - Who is the protagonist? The antagonist? The foil? The minor characters - What is the central conflict of the text and how does it change the protagonist and What is t..
Calculate the current drawn from a 240 v supply : Calculate the current drawn from a 240 V supply for each connection.
How many entity types are involve in a tertiary relationship : How many entity types are involved in a tertiary relationship? The process of arranging attributes of entities in a given business environment into database structures is known as.

Reviews

Write a Review

 

Database Management System Questions & Answers

  What is the advantage of storing data in database

When would you store data in database and when would you use functions

  Identify the modality of the relationship

You are working on the database design that will support PPI's new order entry system. PPI has many thousands of customers around the world who place and pay for orders. One customer can place an order for many products at a time.

  Why triggers are significant in database systems

What are triggers used for, and why are they significant in database systems? Give an example of situation where a trigger would be appropriate. What would implementation of this trigger look like?

  Design a relational database so that it is at least in 3nf

Explain typical situations when denormalizing a table is acceptable. Provide one (1) example of denormalizing a database table to justify your response.

  Draw context diagram data flow diagram for system described

Draw a context diagram data flow diagram for the system described above. The format should be similar to the context diagram in figure 5-13 of your textbook.

  Is it possible for r to be in bcnf if so under what conditon

Consider the relation schema R(A,B,C), which has the FD B → C. If A is a can-didate key for R, is it possible for R to be in BCNF? If so, under what conditions? If not, explain why not.

  Briefly describe what database normalization

Briefly describe what database normalization is and describe the four abnormalities that may occur when creating a database.

  What kind of a design would you try in this case

Suppose that your database system has very ine?cient implementations of index structures. What kind of a design would you try in this case?

  Craete the database to be fault tolerant

Explain the thought process of DBA as they craete the database to be fault tolerant. What policies would you suggest to get this goal?

  Consider a relation stored as a randomly ordered

Consider a relation stored as a randomly ordered ?le for which the only index is an unclustered index on a ?eld called sal. If you want to retrieve all records with sal > 20, is using the index always the best alternative? Explain.

  Create a database for use by the employees

The vegetable database: You have to create a database for use by the employees of vegetables.com, an online store which sells many different vegetables, including onions, tomatoes, carrots, potatoes, squash, eggplants and zuchini

  Describe object-orientated databases

"Object-Orientated Databases will eventually supplant Relational Databases and RDBMSs as the predominant data storage / retrieval paradigm.

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