What would happen when a customer was deleted

Assignment Help Basic Computer Science

Reference no: EM131216657

The Orders table contains a foreign key, Customer Num, that must match the primary key of the Customer table. What type of update to the Orders table would violate referential integrity? If deletes do not cascade, what type of update to the Customer table would violate referential integrity? If deletes do cascade, what would happen when a customer was deleted?

Reference no: EM131216657

Questions Cloud

How would you use sql to change a table''s structure : How would you use SQL to change a table's structure? What general types of changes are possible? Which commands are used to implement these changes?

Why would you create these indexes : You have a table that contains the following fields: Member Last Name, Member First Name, Street, City, State, Postal Code, and Membership Fee. There are 75,000 records in the table. What indexes would you create for the table, and why would you c..

Find the x- and y-intercepts of the polynomial function f : Find the x- and y-intercepts of the polynomial function f. Determine whether the graph of f crosses or touches the x-axis at each x-intercept. Find the power function that the graph of f resembles for large values of |x|.

How do you think law enforcement agencies or support service : What do you think are the biggest challenges for local law enforcement agencies regarding identifying and preventing potential terrorist activities? Explain. Have law enforcement capabilities been hindered or improved because of the implementation ..

What would happen when a customer was deleted : If deletes do cascade, what would happen when a customer was deleted?

What is the direction and magnitude of the electric field : Electrostatics, Magnetism, Electronic Circuits, and Induction - ENGN102 What are the magnitude and direction of the net electrostatic force on charge B due to charges A and C and what is the direction and magnitude of the electric field at point P?

Prepare journal entry to record year end adjusting entry : Prepare the journal entry to record the year-end adjusting entry for uncollectible accounts. - What is total bad debt expense for 2003?

Would toys galore be included in the query results : If you run the SQL query in Question 2b after the credit limit has been increased, would Toys Galore be included in the query results? Why or why not?

Discuss the criteria for evaluating a potential supplier : BPM6115 Purchasing and Supply Management Assignment. Briefly explain the advantages that an organization will gain from subcontracting or outsourcing a specific service. Discuss the criteria for evaluating a potential supplier to deliver a goods or s..

User Account

All Pages