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 :
- By Using Microsoft Sql Management Studio Please Answer This Insert Statements Insert Records Rows Into The Creditcar 1 (53.79 KiB) Viewed 55 times