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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!