What is a surrogate key, and when should you use one?
Answer to relevant QuestionsSuppose that someone tells you that an attribute that is part of a composite primary key is also a candidate key. How would you respond to that statement?Define and discuss the concept of transitive dependency.Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club’s members, to plan the meals, to ...What are “referential constraint actions”?Write a query to display the rental number, rental date, video number, movie title, due date, return date, detail fee, and number of days past the due date that the video was returned for each video that was returned after ...
Post your question