In: Computer Science
CREATE TABLE Hotel
(
roomNumber INTEGER PRIMARY KEY,
type CHAR(10) NOT NULL,
rate INTEGER NOT NULL,
--
CONSTRAINT IC1 CHECK (type IN ('suite', 'king', 'queen')),
CONSTRAINT IC2 CHECK (type <> 'suite' OR rate > 200),
CONSTRAINT IC3 CHECK (NOT (type = 'king' AND (rate < 80 OR rate > 220))),
CONSTRAINT IC4 CHECK (NOT (type = 'queen' AND rate >= 100))
);
which 8 of these inserts will be rejected only 8 are rejected
1. |
INSERT INTO Hotel VALUES (21, 'king', 90); |
|
2. |
INSERT INTO Hotel VALUES (42, 'suite', 230); |
|
3. |
INSERT INTO Hotel VALUES (52, 'suite', 200); |
|
4. |
INSERT INTO Hotel VALUES (40, 'queen', 230); |
|
5. |
INSERT INTO Hotel VALUES (31, 'king', 50); |
|
6. |
INSERT INTO Hotel VALUES (30, 'queen', 50); |
|
7. |
INSERT INTO Hotel VALUES (22, 'suite', 90); |
|
8. |
INSERT INTO Hotel VALUES (10, 'queen', 210); |
|
9. |
INSERT INTO Hotel VALUES (20, 'queen', 90); |
|
10. |
INSERT INTO Hotel VALUES (51, 'king', 220); |
|
11. |
INSERT INTO Hotel VALUES (41, 'king', 230); |
|
12. |
INSERT INTO Hotel VALUES (32, 'suite', 50); |
|
13. |
INSERT INTO Hotel VALUES (11, 'king', 210); |
|
14. |
INSERT INTO Hotel VALUES (12, 'suite', 210); |
|
15. |
INSERT INTO Hotel VALUES (50, 'queen', 100); |
1.
INSERT INTO Hotel VALUES (21, 'king', 90); -- not rejected
2.
INSERT INTO Hotel VALUES (42, 'suite', 230); -- not rejected
3.
INSERT INTO Hotel VALUES (52, 'suite', 200); -- rejected
Reason : The INSERT statement conflicted with the CHECK constraint
"IC2". The conflict occurred in database "master", table
"dbo.Hotel".
4.
INSERT INTO Hotel VALUES (40, 'queen', 230); --rejected
Reason :The INSERT statement conflicted with the CHECK constraint
"IC4". The conflict occurred in database "master", table
"dbo.Hotel".
5.
INSERT INTO Hotel VALUES (31, 'king', 50); --rejected
Reason : The INSERT statement conflicted with the CHECK constraint
"IC3". The conflict occurred in database "master", table
"dbo.Hotel".
6.
INSERT INTO Hotel VALUES (30, 'queen', 50); -- not rejected
7.
INSERT INTO Hotel VALUES (22, 'suite', 90); -- rejected
Reason : The INSERT statement conflicted with the CHECK constraint
"IC2". The conflict occurred in database "master", table
"dbo.Hotel".
8.
INSERT INTO Hotel VALUES (10, 'queen', 210); -- rejected
Reason: The INSERT statement conflicted with the CHECK constraint
"IC4". The conflict occurred in database "master", table
"dbo.Hotel".
9.
INSERT INTO Hotel VALUES (20, 'queen', 90); -- not rejected
10.
INSERT INTO Hotel VALUES (51, 'king', 220); -- not rejected
11.
INSERT INTO Hotel VALUES (41, 'king', 230); -- rejected
Reason :The INSERT statement conflicted with the CHECK constraint
"IC3". The conflict occurred in database "master", table
"dbo.Hotel".
12.
INSERT INTO Hotel VALUES (32, 'suite', 50); -- rejected
Reason : The INSERT statement conflicted with the CHECK constraint
"IC2". The conflict occurred in database "master", table
"dbo.Hotel".
13.
INSERT INTO Hotel VALUES (11, 'king', 210); -- not rejected
14.
INSERT INTO Hotel VALUES (12, 'suite', 210); -- not rejected
15.
INSERT INTO Hotel VALUES (50, 'queen', 100); -- rejected
Reason : The INSERT statement conflicted with the CHECK constraint
"IC4". The conflict occurred in database "master", table
"dbo.Hotel".