Based on this implemented physical schema diagram create database. Also, use Data Manipulation Language (DML) to add (insert), delete, and modify (update) data.

--Selecting the database

Use EZRentalDB

Testing Tables.

--Tables used and order to test

This table are parent #1

1. DriverLicense

2. CustomerUserAccount

3. CreditCardMerchant

4. Company

5. Discount

6. EzPlus

tables with associate child table or supertype paren table

7. Customer

8. CreditCard

9. CorporateCustomer

10. RetailCustomer

11. Customer_CreditCard

Please help me create all this 11database

Transcribed Image Text:

Credit Card Merchant * 8 Column Name Data Type Allow Nulls MerchantCode tinyint MerchantName varchar(50) ko Credit Card * 8 Column Name Credit CardNumber CreditOwnerName Credit CardIssuing Company MerchantCode ExpDate AddressLine1 AddressLine2 City StateCode ZipCode Country Credit Card Limit Credit CardBalance Activation Status Data Type varchar(16) varchar(50) varchar(50) Email tinyint date varchar(50) varchar(50) varchar(30) char(2) varchar(10) varchar(50) decimal(8, 2) decimal(8, 2) bit Allow Nulls CustomerUser Account Column Name UserAccountID Username UserPassword ✓ Data Type uniqueidentifi... varchar(20) varchar(20) varchar(100) O Allow Nulls Customer Credit Card * Column Name Data Type Credit CardNumb.... varchar(16) CustomerlD DriverLicense * 8 Column Name Data Type DriverLicenseNumber varchar(25) DriverLicenseExpDa... date char(2) DriverLicense State Discount int Column Name DiscountID Discount Code Discount CodeDe.... Allow Nulls Data Type int Allow Nulls varchar(10) varchar(150) O Customer * RetailCustomer * Column Name CustomerlD DiscountID EZPlusID Allow Nulls Column Name CustomerlD FirstName LastName BirthDate AddressLine1 AddressLine2 City StateCode ZipCode Country Phone Email DriverLicenseNumber CustomerUser AccountID CustomerType Data Type int int int EZPlus * 8 Allow Nulls ✓ Column Name int Data Type varchar(50) varchar(50) date varchar(50) varchar(50) varchar(30) char(2) varchar(10) varchar(50) varchar(20) varchar(100) varchar(25) uniqueidentifi... bit loo oo 8 Data Type int EZPlusID EZPlusRewards Code EZPlusRewards EarnedPoi.... bigint varchar(13) Allow Nulls ✓ ✓ Allow Nulls ✓ to USState 8 Column Name StatelD StateCode StateName Company Data Type tinyint char(2) varchar(30) Column Name Company D CompanyName AddressLine1 AddressLine2 City StateCode ZipCode Country Data Type smallint varchar(50) varchar(50) varchar(50) varchar(30) char(2) varchar(10) varchar(50) varchar(50) varchar(10) varchar(100) CorporateDiscountPercentageR... decimal(3, 2) Allow Nulls CompanyRepName ContactPhone ContactEmail Country Column Name Data Type tinyint Country D CountryCode2Ch... char(2) CountryCode3Ch... char(3) CountryName varchar(100) Allow Nulls ✓ to Allow Nullst CorporateCustomer * Column Name CustomerlD Company D Data Type Allow Nulls. int smallint Credit Card Merchant * 8 Column Name Data Type Allow Nulls MerchantCode tinyint MerchantName varchar(50) ko Credit Card * 8 Column Name Credit CardNumber CreditOwnerName Credit CardIssuing Company MerchantCode ExpDate AddressLine1 AddressLine2 City StateCode ZipCode Country Credit Card Limit Credit CardBalance Activation Status Data Type varchar(16) varchar(50) varchar(50) Email tinyint date varchar(50) varchar(50) varchar(30) char(2) varchar(10) varchar(50) decimal(8, 2) decimal(8, 2) bit Allow Nulls CustomerUser Account Column Name UserAccountID Username UserPassword ✓ Data Type uniqueidentifi... varchar(20) varchar(20) varchar(100) O Allow Nulls Customer Credit Card * Column Name Data Type Credit CardNumb.... varchar(16) CustomerlD DriverLicense * 8 Column Name Data Type DriverLicenseNumber varchar(25) DriverLicenseExpDa... date char(2) DriverLicense State Discount int Column Name DiscountID Discount Code Discount CodeDe.... Allow Nulls Data Type int Allow Nulls varchar(10) varchar(150) O Customer * RetailCustomer * Column Name CustomerlD DiscountID EZPlusID Allow Nulls Column Name CustomerlD FirstName LastName BirthDate AddressLine1 AddressLine2 City StateCode ZipCode Country Phone Email DriverLicenseNumber CustomerUser AccountID CustomerType Data Type int int int EZPlus * 8 Allow Nulls ✓ Column Name int Data Type varchar(50) varchar(50) date varchar(50) varchar(50) varchar(30) char(2) varchar(10) varchar(50) varchar(20) varchar(100) varchar(25) uniqueidentifi... bit loo oo 8 Data Type int EZPlusID EZPlusRewards Code EZPlusRewards EarnedPoi.... bigint varchar(13) Allow Nulls ✓ ✓ Allow Nulls ✓ to USState 8 Column Name StatelD StateCode StateName Company Data Type tinyint char(2) varchar(30) Column Name Company D CompanyName AddressLine1 AddressLine2 City StateCode ZipCode Country Data Type smallint varchar(50) varchar(50) varchar(50) varchar(30) char(2) varchar(10) varchar(50) varchar(50) varchar(10) varchar(100) CorporateDiscountPercentageR... decimal(3, 2) Allow Nulls CompanyRepName ContactPhone ContactEmail Country Column Name Data Type tinyint Country D CountryCode2Ch... char(2) CountryCode3Ch... char(3) CountryName varchar(100) Allow Nulls ✓ to Allow Nullst CorporateCustomer * Column Name CustomerlD Company D Data Type Allow Nulls. int smallint

Answer rating: 100% (QA)

This step creates DriverLicense Table Explanation for step 1 Use db command is to enter the database you want to use For creating a database use Creat... View the full answer