Information Modeling and Relational Database Question 1 In a

Information Modeling and Relational Database

Question 1 In a word .doc document, write the below requested SQL code. When done, upload this document to Blackboard NOTE: for this exam you can simply type in the correct SQ in your word doc. , in future quizzes though I will ask you to actually run Netbeans( or your preferred database), type in the DDL code, insert a couple of rows of data, run a request , and paste in your result, ********************* Here is the \'pseudocode for that table creation, you are to write correct SQL code to effect it. ( I have given you the data types I would like you to use). Construct the table called TravelEvent that has an id of truckId ,of type Integer,a name of type Varchar(30) and a weight with identifier of weightCode with a data type of Decimal(6,2) and an acquisitionDate of type Date. Write the SQL code to create that table, pay attention to punctuation

Solution

CREATE TABLE TravelEvent( truckId INT, Name VARCHAR (30), weightCode DECIMAL(6,2), acquisitionDate DATE(), PRIMARY KEY (truckId) );