Answer Happy

Q1 :- create database travel and build table name car owner and data travel with all columns This question must be solved by the oracle database Also, solutions must include clear images and be of high resolution Car Owner Data travel Car - no Name Travel-no [pk) Model Address Date Color Car-110 Car -110 [fk] Day of travel • Create database travel • Create table cars (car-no char (8), model char (10), color char(8)) • Create table owner (name char (10), address char (20), car-no char (8) • Create table data travel (travel-no numeric (10), date date, car-no char (8), days of travel numeric (3) • Insert into car values (*1134567”, “Toyota”, “white") Insert into owner values ("ahmed", "Baghdad", "1134567") Insert into data travel (234, {10/10/2003),"1134567" Get all car information Ge: car model for car no (65378) Get cars with Toyota models Before you answer can you draw the schema the ER-Diagram and explain to the primary key and forgery key at the Q above