Information Modeling and Relational Database Question 1 In a word .doc document,
ID: 3928860 • Letter: I
Question
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
Explanation / Answer
CREATE TABLE TravelEvent( truckId INT, Name VARCHAR (30), weightCode DECIMAL(6,2), acquisitionDate DATE(), PRIMARY KEY (truckId) );