Name of Student
Name of Instructor
Course Code
Date of Submission
SQL Queries
Question 1
SQL command and results
Command
Create table
Insert data
Copy
Paste
Return 0
Results
Command
Insert id, trip name, and distance:
Id = 42
Trip name = South Africa
Distance = 40km
Results
Command
Alter table
Drop table
Results
Updating the database creates some problems of error being incurred. The database requires a new set of data because the previous set lacks some details (Klein, 20). Thus the database has to be updated, and new information added.
Question 2
Command
Insert reservation id, trip ID, Trip date, customer number, customer last name, customer first name, phone number
Reservation id = 32
Trip id= 92
Rip date= 12/12/2018
Customer number = 32
Customer last name= Hank
Customer first name= John
Phone number= +2343111111134
Print data
Return zero
Results
Command
Retrieve reservation ID, trip ID, trip date, and customer last name;
Print data
Return 0
Results
Command
Create database
Print data
Results
Updating the database creates some problems of error being incurred. The database requires a new set of data because the previous set lacks some details. Thus the database has to be updated, and new information added (Klein, 21).
Question 3
Command
Create table
Select column = units
Select rows = total number of trips
Command
Retrieve trip and units
Create table
Command
Select Database information
Display …
Free SQL Queries Essay Sample, Download Now
Order Original Essay on the Similar Topic
Get an original paper on the same topicfrom $10 per-page
Leave a Reply