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.

fivewriters
Calculate your essay price
(550 words)

Approximate price: $22

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!