using this create statements, can you populate these tables using sql queries;

$--$ Create Database EZ$\_$Rentals$\_$DB

CREATE DATABASE EZ$\_$RentalsDB;

GO

USE EZ$\_$RentalsDB;

GO

$--$ Create the CreditCardMerchantServiceCompany table

CREATE TABLE CreditCardMerchantServiceCompany $($

CreditCardProcessingMerchantServiceCompanyCode TINYINT PRIMARY KEY CHECK $($CreditCardProcessingMerchantServiceCompanyCode BETWEEN $1$ AND $10),$

CreditCardProcessingMerchantServiceCompanyName VARCHAR$(60)$ UNIQUE NOT NULL

$)$;

$--$ Create the CreditCardNetworkCompany table

CREATE TABLE CreditCardNetworkCompany $($

CreditCardNetworkCompanyCode TINYINT PRIMARY KEY CHECK $($CreditCardNetworkCompanyCode BETWEEN $1$ AND $25),$

CreditCardNetworkCompanyName VARCHAR$(60)$ UNIQUE NOT NULL

$)$;

$--$ Create the CreditCardCorporateMerchantBank table

CREATE TABLE CreditCardCorporateMerchantBank $($

CreditCardCorporateMerchantBankCode TINYINT PRIMARY KEY CHECK $($CreditCardCorporateMerchantBankCode BETWEEN $1$ AND $10),$

CreditCardCorporateMerchantBankName VARCHAR$(30)$ UNIQUE NOT NULL

$)$;

$--$ Create the CreditCardIssuingBank table

CREATE TABLE CreditCardIssuingBank $($

CreditCardIssuingBankCode TINYINT PRIMARY KEY CHECK $($CreditCardIssuingBankCode BETWEEN $1$ AND $25),$

CreditCardIssuingBankName VARCHAR$(20)$ UNIQUE NOT NULL

$)$;

$--$ Create the States table

CREATE TABLE States $($

StateID TINYINT PRIMARY KEY CHECK $($StateID BETWEEN $1$ AND $75),$

StateCode$2$Char CHAR$(2)$ UNIQUE NOT NULL,

StateName VARCHAR$(50)$ UNIQUE NOT NULL

$)$;

$--$ Create the Countries table

CREATE TABLE Countries $($

CountryID TINYINT PRIMARY KEY CHECK $($CountryID BETWEEN $1$ AND $250),$

CountryCode$2$Char CHAR$(2)$ UNIQUE NOT NULL,

CountryCode$3$Char CHAR$(3)$ UNIQUE NOT NULL,

CountryName CHAR$(100)$ UNIQUE NOT NULL

$)$;

CREATE TABLE CreditCard $($

CreditCardNumber VARCHAR$(16)$ PRIMARY KEY, $--$ Primary Key for the credit card table

CreditCardOwnerName VARCHAR$(100)$ NOT NULL, $--$ Name of the credit card owner

CreditCardProcessingMerchantServiceCompanyCode TINYINT CHECK $($CreditCardProcessingMerchantServiceCompanyCode BETWEEN $1$ AND $10)$ NOT NULL, $--$ Foreign key referencing CreditCardProcessingMerchantServiceCompany table

CreditCardNetworkCompanyCode TINYINT CHECK $($CreditCardNetworkCompanyCode BETWEEN $1$ AND $25)$ NOT NULL, $--$ Foreign key referencing CreditCardNetworkCompany table

CreditCardIssuingBankCode TINYINT CHECK $($CreditCardIssuingBankCode BETWEEN $1$ AND $25)$ NOT NULL, $--$ Foreign key referencing CreditCardIssuingBank table

CreditCardCorporateMerchantBankCode TINYINT CHECK $($CreditCardCorporateMerchantBankCode BETWEEN $1$ AND $10)$ NOT NULL, $--$ Foreign key referencing CreditCardCorporateMerchantBank table

ExpDate DATE CHECK $($ExpDate $>=$ GETDATE$()),--$ Check constraint to ensure ExpDate is a valid future date

AddressLine$1$ VARCHAR$(50)$ NOT NULL, $--$ First part of address

AddressLine$2$ VARCHAR$(50),--$ Second part of address $($optional$)$

City VARCHAR$(50)$ NOT NULL, $--$ City of the address

StateCode CHAR$(2)$ NOT NULL, $--$ State code of the address

Zipcode VARCHAR$(10)$ NOT NULL, $--$ Zip code of the address

Country VARCHAR$(100)$ NOT NULL, $--$ Country of the address

CreditCardLimit DECIMAL$(8,2)$ NOT NULL, $--$ Maximum credit limit of the credit card

CreditCardAvailableCredit DECIMAL$(8,2)$ NOT NULL, $--$ Remaining available credit on the credit card

ActivationStatus BIT NOT NULL, $--$ Indicates whether the credit card is active or not

FOREIGN KEY $($CreditCardProcessingMerchantServiceCompanyCode$)$ REFERENCES CreditCardMerchantServiceCompany$($CreditCardProcessingMerchantServiceCompanyCode$)$ ON DELETE CASCADE ON UPDATE CASCADE, $--$ Foreign key constraint for credit card processing merchant service company

FOREIGN KEY $($CreditCardNetworkCompanyCode$)$ REFERENCES CreditCardNetworkCompany$($CreditCardNetworkCompanyCode$)$ ON DELETE CASCADE ON UPDATE CASCADE, $--$ Foreign key constraint for credit card network company

FOREIGN KEY $($CreditCardIssuingBankCode$)$ REFERENCES CreditCardIssuingBank$($CreditCardIssuingBankCode$)$ ON DELETE CASCADE ON UPDATE CASCADE, $--$ Foreign key constraint for credit card issuing bank

FOREIGN KEY $($CreditCardCorporateMerchantBankCode$)$ REFERENCES CreditCardCorporateMerchantBank$($CreditCardCorporateMerchantBankCode$)$ ON DELETE CASCADE ON UPDATE CASCADE $--$ Foreign key constraint for credit card corporate merchant bank

$)$;

Credit card Merchant Service Company table ;

$(\text{'}$Stax by Fattmerchant'$),$

$(\text{'}$Helcim$\text{'}),$

$(\text{'}$Dharma Merchant services'$),$

$(\text{'}$Payment Depot'$),$

$(\text{'}$National Processing'$),$

$(\text{'}$Block$\text{'}),$

$(\text{'}$Intuit Quickbooks'$),$

$(\text{'}$Paypal$\text{'}),$

$(\text{'}$Stripe$\text{'}),$

$(\text{'}$Flagship Merchant Services'$),$

$(\text{'}$Clover$\text{'})$;

$-$Credit Card Network Company;

American Express

Visa

MasterCard

Discover

Diners club

interlink

Star

Accel

Interac

Visa ReadyLink

Pulse

JCB $($Japan Credit Bureau$)$

Rupay