Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Database Exercise 6.5.2 write the following database modifications, based on the database schema Classes(class, type, country, numGuns, bore, displacement) Ships(name, class, launched) Battles(name, date) Outcomes(ship,

Database Exercise 6.5.2 write the following database modifications, based on the database schema Classes(class, type, country, numGuns, bore, displacement) Ships(name, class, launched) Battles(name, date) Outcomes(ship, battle, result) a) Modify the Classes relation so that gun bores are measured in centimeters (1 inch = 2.54 centimeters) and displacement are measured in metric tons (1 metric ton = 1.15 tons). b) Delete all classes with two or fewer ships. C) Each class is required to have a ship with the class name launched the same year the first ship in the class was launched. Add this fact to the database, for all the classes that do not satisfy it. I am using MySQL and these are database querys

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Shamkant B. Navathe

7th Edition Global Edition

1292097612, 978-1292097619

More Books

Students also viewed these Databases questions