Complete the following problem using basic SQL commands.  Basic SQL
means not specifically tied to TSQL, SQL PL or DB 2 Versions.
You a clerk at hotel SQL and I have the following table:
Create table Hotel
	(rommno smallint not null,
	arrival date not null,
	departure date not null,
guest char (30),
Primary Key (roomno, arrival),
Check (departure >= arrival));
Right now the Check() clause enforces the data integrity constraint
that you cannot leave before  you arrived, but you want more.  How do
I enforce the rule that I cannot add a reservation that has given an
arrival date conflicting with the prior departure date for a given
room?

---

Request for Question Clarification by wlk115-ga on 27 Sep 2002 08:36 PDT

This series of questions looks like a Homework Assignment, in which
case we can’t answer them for you. Google Answer Researchers are not
allowed to do your homework for you.
Their policy reads, in part "[...]we do not condone cheating or
encourage customers to use this service in lieu of doing their own
schoolwork[...]"

---

Clarification of Question by fahd-ga on 28 Sep 2002 11:05 PDT

thank you for your note.
the questions I am posting (asking) are not a school related
questions.
they are methods for me to establish some understanding as I am
educating myself about materials I am rearing and coming across.

Thanks for your questions fahd-ga. This particular question however is
beyond my level of expertise. For future reference, however, I did
want, however, to respond to wlk115-ga's request for clarification:
researchers are permitted to answer homework questions (I am not sure
where his quotation comes from but it either isn't correct or it isn't
current).