Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started