Answer Happy

by using Microsoft SQL management studio, please answer
this
INSERT STATEMENTS:
INSERT Records (ROWS) INTO THE CREDITCARDMERCHANT TABLE:
Insert 11 records into the CreditCardMerchant Table.
Show proof of the CreditCardMerchant Table before and after
insertion

INSERT Records (ROWS) INTO THE CREDITCARDMERCHANT TABLE:
INSERT 5 or more records into the CreditCard Table.
Use what ever data you like for the 5 records.
Show proof of the CreditCard Table before and after
Insertion.

SELECT STATEMENTS:
Create and execute the following SELECT statement to the CREDITCARD
TABLE:
Select ALL COLUMNS and RETURN the ONE RECORD whose CreditCardNumber
= a Primary Key value that exist in the CreditCard
table.
THIS QUERY ONLY RETURNS ONE RECORD BASED ON PRIMARY KEY.
UPDATE STATEMENTS:
UPDATE ONE Record from the CREDITCARD TABLE:
UPDATE a record of your choice in the CreditCard Table.
Modify ALL COLUMNS EXCEPT the primary key.
Show proof of the CreditCard Table before and after update.
DELETE STATEMENT
DELETE ONE Record from the CREDITCARD TABLE:
DELETE ONE record of your choice in the CreditCard Table based on
PRIMARY KEY.
Show proof of the CreditCard Table before and after update.
here is the database diagram :
Data Type Allow Nu. Allow Nu... CUSTOMER CREDITCARD Column Name Data Type Customers int Credit CardNu... varchar(16) CREDITCARD Column Name Credit CardNumber varchar(16) Credit CardOwnerName varchar(50) Credit Cardissuing Com... varchar(50) MerchantCode tinyint ExpDate date AddressLine1 varchar(50) AddressLine2 varchar(50) City varchar(30) StateCode char(2) Zip Code varchar(10) Country varchar(100) Credit Card Limit decimal(7.2) Credit CardBalance decimal(7,2) Activation Status bit Allow Nu... CREDITCARDMERCHANT Column Name Data Type MerchantCo... tinyint MerchantNa... varchar(50)