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. Entity Integrity O Referential Integrity O Key O Null Domain O None

EBK JAVA PROGRAMMING
9th Edition
ISBN:9781337671385
Author:FARRELL
Publisher:FARRELL
Chapter10: Introduction To Inheritance
Section: Chapter Questions
Problem 2PE
icon
Related questions
Question
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
Transcribed Image 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
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
Transcribed Image 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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Linux
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781305480537
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT