rect Question 12 What constraints would the following command violate? There may be more than one or none. The changes should be taken individually on the data shown above and not as a result of...


rect<br>Question 12<br>What constraints would the following command violate? There may be more than<br>one or none. The changes should be taken individually on the data shown above and<br>not as a result of previous problems.<br>Update RaceType record, change type to be 'Marathon' for record with Rtype ID 2.<br>O Null<br>None<br>V Key<br>O Domain<br>O Referential Integrity<br>O Entity Integrity<br>Question 13<br>What constraints would the following command violate? There may be more than<br>one or none. The changes should be taken individually on the data shown above and<br>not as a result of previous problems.<br>Update Race record with Raceid of 2 and set name to 'Laketown Ultra'.<br>O Referential Integrity<br>V None<br>O Null<br>O Entity Integrity<br>O Key<br>O Domain<br>Question 15<br>What constraints would the following command violate? There may be more than<br>one or none, The changes should be taken individually on the data shown above and<br>not as a result of previous problems.<br>Insert a new record into Race with the values (2, 'Strut Your Mut, 12/05/2021, 23)<br>for the respective columns,<br>None<br>2 Key<br>Domain<br>Null<br>O Entity Integrity<br>

Extracted text: rect Question 12 What constraints would the following command violate? There may be more than one or none. The changes should be taken individually on the data shown above and not as a result of previous problems. Update RaceType record, change type to be 'Marathon' for record with Rtype ID 2. O Null None V Key O Domain O Referential Integrity O Entity Integrity Question 13 What constraints would the following command violate? There may be more than one or none. The changes should be taken individually on the data shown above and not as a result of previous problems. Update Race record with Raceid of 2 and set name to 'Laketown Ultra'. O Referential Integrity V None O Null O Entity Integrity O Key O Domain Question 15 What constraints would the following command violate? There may be more than one or none, The changes should be taken individually on the data shown above and not as a result of previous problems. Insert a new record into Race with the values (2, 'Strut Your Mut, 12/05/2021, 23) for the respective columns, None 2 Key Domain Null O Entity Integrity
Raceid : Int<br>name : Varchar(20)<br>raceDate : DateTime<br>raceType : Int<br>Strut Your Mut<br>10/20/2020<br>1<br>2<br>Kickoff Run<br>09/25/2020<br>1<br>3<br>Laketown Ultra<br>11/05/2020<br>RACETYPE<br>RTypelD : int<br>Type : varchar(40)<br>5k<br>Half Marathon<br>3<br>10k<br>Foreign Keys Race.RaceType is a Foreign Key to RACETYPE.RTypelD<br>Keys RaceType.Type is a key and must be unique Race.Name is a key a<br>unique<br>Race.RaceDate is not nullable<br>Questions:<br>Question 10<br>What constraints would the following command violate? There may be more than<br>one or none. The changes should be taken individually on the data shown above and<br>not as a result of previous problems.<br>Remove RaceType record with rtypeid equal to 1.<br>O Entity Integrity<br>Referential Integrity<br>O Key<br>O Null<br>Domain<br>None<br>

Extracted text: Raceid : Int name : Varchar(20) raceDate : DateTime raceType : Int Strut Your Mut 10/20/2020 1 2 Kickoff Run 09/25/2020 1 3 Laketown Ultra 11/05/2020 RACETYPE RTypelD : int Type : varchar(40) 5k Half Marathon 3 10k Foreign Keys Race.RaceType is a Foreign Key to RACETYPE.RTypelD Keys RaceType.Type is a key and must be unique Race.Name is a key a unique Race.RaceDate is not nullable Questions: Question 10 What constraints would the following command violate? There may be more than one or none. The changes should be taken individually on the data shown above and not as a result of previous problems. Remove RaceType record with rtypeid equal to 1. O Entity Integrity Referential Integrity O Key O Null Domain None
Jun 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here