Question: The below sample data in the third normal form was provided by a database designer. Answer the below questions using this data and assume that

The below sample data in the third normal form was provided by a database designer. Answer the below questions using this data and assume that the below data will exist in the tables. Table: Ship Primary key: ShiplD Table: Sailing Primary key: SailingID Foreign key: ShipID Q.6.2.1 Write a SQL statement to create the table Sailing. Hint: The sample data should give you an indication of the data types you should use. Q.6.2.2 Write a SQL statement that will add the below row to the Sailing table. Q.6.2.3 Write a SQL statement that will change the value of the sailing description for sailing number 3 to "Alaska
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
