Answer A B and C : Exercise 7.2.5: Write the following as tuple-based CHECK constraints about our “battleships” schema: Classes (class, type, country, numGuns, bore,
Answer A B and C : Exercise 7.2.5: Write the following as tuple-based CHECK constraints about
our “battleships” schema:
Classes (class, type, country, numGuns, bore, displacement)
Ships (name, class, launched)
Battles (name, date)
Outcomes (ship, battle, result)
a) No class of ships may have guns with larger than a 16-inch bore.
b) If a class of ships has more than 9 guns, then their bore must be no larger
than 14 inches.
! c) No ship can be in battle before it is launched.
How it Works
1
It only takes a couple of minutes to fill in your details, select the type of paper you need (essay, term paper, etc.), give us all necessary information regarding your assignment.
2
Once we receive your request, one of our customer support representatives will contact you within 24 hours with more specific information about how much it'll cost for this particular project.
3
After receiving payment confirmation via PayPal or credit card – we begin working on your detailed outline, which is based on the requirements given by yourself upon ordering.
4
Once approved, your order is complete and will be emailed directly to the email address provided before payment was made!