Computers and Technology, 13.05.2021 17:40 nakeytrag

Consider the following relations for ships visit ports application where primary keys are underlined. Answer all queries in the language asked for (alternate language gets no credit). MAKER (Maker_Name, Registration_Country)
SHIP (Ship_ID, Ship_Name, Maker_Name, Model, Built_Year )
PORT (Port_ID, Port_Name, Location_Country)
SHIP_VISIT(Ship_ID, Port_ID, Date, Duration_in_Days)

Required:
a. Show how to insert the tuple in SHIP_VISIT (using SQL). What kind of checks must the system perform to guarantee integrity of the above database?
b. Do the following queries in the language(s) indicated: 1B.1. list the ship_name and model of ships that visited the country where it was built. (using SQL)

Answers: 2

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 02:00, ashleyrobles2676

Consider how gaming consoles initially relied on joysticks and joypads and then made the switch to modern gaming controls, which include analog sticks, buttons and switches, touch controls, accelerometers, motion controls, etc. name at least two kinds of gaming experiences that are possible with these new control devices but were not possible on original joysticks. explain how new technologies made this newer game style possible.

Answers: 1

continue

Computers and Technology, 22.06.2019 06:00, Treezy11

In outlook how can cherie look at the details of an event that appears on the month view of her calendar? check all that apply. by switching to the detail view by switching to the week view by switching to the day view by right-clicking on the event by double-clicking on the event by highlighting the event

Answers: 2

continue

Computers and Technology, 23.06.2019 14:30, ladawnrowles005

The option enables you to modify a slide element in most presentation applications.

Answers: 2

continue

Computers and Technology, 23.06.2019 20:40, bobby3350

On nba 2k 19, every time i try to join a my park game, it leads ro a website telling my dad that he needs ps plus. i already have ps plus though. how do i fix this?

Answers: 2

continue

You know the right answer?

Consider the following relations for ships visit ports application where primary keys are underlined...