Question

Help please

ASSIGNEMENT 1: Create table NATION along with following data: 40create table nation 41 (natcode char(3) not null 42 natname varchar (20) 43 exchrate decimal(9,5) 44 constraint pk nation primary key (natcode))s 45 Add data into the table nation 46insert into nation values ('UK', 'United Kingdom',1) 47insert into nation values USA, 'United States',0.67) 48insert into nation values ('AUS,'Australia',0.46) 49insert into nation values (' IND,India',0.8228) DELIVERABLE 1: Screen shot evidence of the above table and data in MySQL workbench

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

This demonstration is using MySQL Workbench.

Table Name :nation

/*1.Table Name : nation*/
create table nation(
natcode char(3) not null,
natname varchar(20),
exchrate decimal(9,5),
constraint pk_nation primary key (natcode));

/*add data into the table nation*/
insert into nation values('UK','United Kingdom',1);
insert into nation values('USA','United States',0.67);
insert into nation values('AUS','Australia',0.46);
insert into nation values('IND','India',0.0228);

/*selecting record*/
select * from nation;

Screen in SQL Workbench :

MySQL Workbench A Local instance wampmysqd64× File Edit View Query Database Server Tools Scripting Help VountryDb x SQL File 3 MarinaDB f f 0 B 0 C /*1.Table Name nation* Limit to 1000rows 25 26 ) create table nation( 27 natcode char(3) not null, 28 29 30 31 32insert into nation values ("UK', United Kingdom',1)5 33insert into nation values('USA, United States',0.67) 34insert into nation values('AUS,'Australia',0.46) 35insert into nation values ('IND', India',.8228) 36 37select from nation; 38 natname varchar (20), exchrate decimal(9,5), constraint pk_nation primary key (natcode)); /*add data into the table nation /*selecting record Result GridFiter Rows: | Edit:菌劻卧 Export/Import:聐勸wrap Cel Content: E natcode natname exchrate United Kingdom 1.00000 United States 0.67000 Australia India UK USA AUS IND 0.46000 0.02280 HULL

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.