Question
There is a Foreign Key (FK) in BOOK for AuthorID to the Primary Key of Author Identify the primary keys in BOOK (1 pt. )
There is a Foreign Key (FK) in BOOK for AuthorID to the Primary Key of Author
-
Identify the primary keys in BOOK (1 pt. )
-
Identify the primary keys in AUTHOR (1 pt.)
-
What is the domain of BOOK? (1 pt)
-
What constraints would the following code obviously violate if any (there may be none in which case write none, or more than one.) ? (1pt each)
-
INSERT INTO BOOK (ISBN, BookName, AuthorID, Type) VALUES (Null, 1984, 190, Fiction)
-
INSERT INTO AUTHOR (AuthorID, AuthorName) VALUES (10, Arthur C. Clarke)
-
INSERT INTO AUTHOR (AuthorID, AuthorName) VALUES (15, Dodie Smith)
-
INSERT INTO BOOK (ISBN, BookName, AuthorID, Type) VALUES (5, Emma, 10, Fiction)
-
DELETE FROM AUTHOR WHERE AuthorID = 12
-
DELETE FROM AUTHOR WHERE AuthorID = 14
-
UPDATE AUTHOR SET AUTHORNAME = Jane Austen WHERE AuthorID = 10
-
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started