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 04:30, justbepunky

There is a simple pattern for determining if a binary number is odd. what is it and why does this pattern occur? how many bits would you need if you wanted to have the ability to count up to 1000? how high could you count in binary if you used all 10 of your fingers as bits? (finger up means 1, finger down means 0)

Answers: 3

continue

Computers and Technology, 22.06.2019 18:30, Jessieeeeey

Kto rozmawia z clamentain przez krótkofalówke w the walking dead która śledzi lee w 4 epizodzie

Answers: 1

continue

Computers and Technology, 23.06.2019 00:30, lm18618

Which one of the following is considered a peripheral? a software b mouse c usb connector d motherboard

Answers: 2

continue

Computers and Technology, 24.06.2019 23:30, binkyv15

Adrian has decided to subscribe for a new internet connection. he wants a high speed connection so that he can stream video content smoothly. which access technology would you advise adrian against using?

Answers: 1

continue

Do you know the correct answer?

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