I have created the DDL below:I am getting an error about an existing constraint with the borrower_fkey for the borrower relation. At the same time, I feel like I have not satisfied all the requirements. Could someone show me what I did wrong?The class is being taught using PostgreSQL so the changes have to be applicable to postgreSQL.Thank you! CREATE TABLE branch (branch_name varchar(25) NOT NULL,branch_city varchar(15),assets numeric(15,2),CONSTRAINT branch_pkey PRIMARY KEY (branch_name));CREATE TABLE customer (ID varchar(10),customer_name varchar(25) NOT NULL,customer_street varchar(25) NOT NULL,customer_city varchar(15) NOT NULL,CONSTRAINT customer_pkey PRIMARY KEY (ID));CREATE TABLE loan (loan_number varchar(25) NOT NULL,branch_name varchar(25) NOT NULL,amount numeric(25,2) NOT NULL,CONSTRAINT loan_pkey PRIMARY KEY (loan_number),CONSTRAINT loan_fkey FOREIGN KEY (branch_name) REFERENCES branch (branch_name) ON DELETE CASCADE);CREATE TABLE borrower (ID varchar(25),loan_number varchar(25) NOT NULL,CONSTRAINT borrower_pkey PRIMARY KEY (ID, loan_number),CONSTRAINT borrower_fkey FOREIGN KEY (ID) REFERENCES customer (ID) ON DELETE CASCADE,CONSTRAINT borrower_fkey FOREIGN KEY (loan_number) REFERENCES loan (loan_number) ON UPDATE CASCADE );CREATE TABLE account (account_number varchar(25),branch_name varchar(25) NOT NULL,balance numeric(25,2),CONSTRAINT account_pkey PRIMARY KEY (account_number),CONSTRAINT account_fkey FOREIGN KEY (branch_name) REFERENCES branch (branch_name) ON DELETE CASCADE);CREATE TABLE depositor (ID varchar(25),account_number varchar(25) NOT NULL,CONSTRAINT depositor_pkey PRIMARY KEY (ID, account_number),CONSTRAINT depositor_fkey FOREIGN KEY (ID) REFERENCES customer (ID) ON DELETE CASCADE); Query Editor Query History2324CREATE TABLE borrower (25ID varchar (25),26loan_number varchar (25) NOT NULL,27CONSTRAINT borrower_pkey PRIMARY KEY (ID, loan_number),28CONSTRAINT borrower_fkey FOREIGN KEY (ID) REFERENCES customer (ID) ON DELETE CASCADE,29CONSTRAINT borrower_fkey FOREIGN KEY (loan_number) REFERENCES loan (loan_number) ON UPDATE CASCADE30) ;3132CREATE TABLE account (33account_numbervarchar(25),34branch_name varchar (25) NOT NULL,35balance numeric(25,2),36CONSTRAINT account_pkey PRIMARY KEY (account_number),37CONSTRAINT account_fkey FOREIGN KEY (branch_name) REFERENCES branch (branch_name) ON DELETE CASCADE38) ;3940CREATE TABLE depositor (41IDvarchar(25),42account_numbervarchar(25) NÓNULL,43CONSTRAINT depositor_pkey PRIMARY KEY (ID, account_number),44CONSTRAINT depositor_fkey FOREIGN KEY (ID) REFERENCES customer (ID) ON DELETE CASCADE45) ;Data Output ExplainMessagesNotificationsERROR:constraint "borrower_fkey" for relation "borrower" already existsSQL state: 42710LO 2. Consider the bank database schema given below, where the primary keys are underlined.Write the SQL DDL corresponding to this schema (i.e. the CREATE TABLE statements).Make any reasonable assumptions about the data types. Be sure to declare primary andforeign keys; both types of constraints should be given appropriate names. Correctly andappropriately implement at least one instance for each of the following: check constraint,not null constraint, on delete cascade clause, on update cascade clause, and a defaultvalue statement. Lastly, construct the following SQL queries for this relational database.NOTE THE FOLLOWING: You are free to define the DDL for this banking database asyou wish, provided that the above requirements are satisfied. However, there is oneprohibition: You must not include a foreign key constraint on the account numberattribute of the depositor relation that references the account relation. To be perfectlyclear, this means you must not include the following foreign key constraint in your DDL:CREATE TABLE depositorCONSTRAINT depositor_fkey FOREIGN KEY (account_number)REFERENCES account (account number)ON DELETE CASCADEON UPDATE CASCADE);The reason for this specific foreign key prohibition concerns question (3) of thisassignment. The spirit behind question (3) is to write a trigger that performs the sameaction that is accomplished by the ON DELETE CASCADE clause of the above foreignSo, if you were to include this foreign key constraint with the ONkey constraint.DELETE CASCADE clause in your DDL, then the trigger you must define in question (3)would be useless since the action would be performed not by the trigger - but, rather bythe ON DELETECASCADE clause instead. If you were to include this foreign keyconstraint without the ON DELETE CASCADE clause in your DDL, then the DBMSwould disallow you from deleting any tuples from the account relation. If you include thespecified foreign key constraint in your DDL, you will receive a grade of zero forquestion (3).Database Schema:branch ( branch_name, branch_city, assets )customer ( ID, customer_name, customer_street, customer_city )loan (loan mиmber, branch пате, атоиnt)borrower ( ID, loan number )ассоunt (аccount mumber, branch_name, balance)depositor ( ID. account_number )Note that in the following problem, there is only one bank, and the individual brancheslisted in the data are all owned by the one bank.Data for this bank database can be found on Brightspace. You may, of course, add moredata if it aids you in testing queries.

Question

I have created the DDL below:I am getting an error about an existing constraint with the borrower_fkey for the borrower relation. At the same time, I feel like I have not satisfied all the requirements. Could someone show me what I did wrong?The class is being taught using PostgreSQL so the changes have to be applicable to postgreSQL.Thank you! CREATE TABLE branch (branch_name varchar(25) NOT NULL,branch_city varchar(15),assets numeric(15,2),CONSTRAINT branch_pkey PRIMARY KEY (branch_name));CREATE TABLE customer (ID varchar(10),customer_name varchar(25) NOT NULL,customer_street varchar(25) NOT NULL,customer_city varchar(15) NOT NULL,CONSTRAINT customer_pkey PRIMARY KEY (ID));CREATE TABLE loan (loan_number varchar(25) NOT NULL,branch_name varchar(25) NOT NULL,amount numeric(25,2) NOT NULL,CONSTRAINT loan_pkey PRIMARY KEY (loan_number),CONSTRAINT loan_fkey FOREIGN KEY (branch_name) REFERENCES branch (branch_name) ON DELETE CASCADE);CREATE TABLE borrower (ID varchar(25),loan_number varchar(25) NOT NULL,CONSTRAINT borrower_pkey PRIMARY KEY (ID, loan_number),CONSTRAINT borrower_fkey FOREIGN KEY (ID) REFERENCES customer (ID) ON DELETE CASCADE,CONSTRAINT borrower_fkey FOREIGN KEY (loan_number) REFERENCES loan (loan_number) ON UPDATE CASCADE );CREATE TABLE account (account_number varchar(25),branch_name varchar(25) NOT NULL,balance numeric(25,2),CONSTRAINT account_pkey PRIMARY KEY (account_number),CONSTRAINT account_fkey FOREIGN KEY (branch_name) REFERENCES branch (branch_name) ON DELETE CASCADE);CREATE TABLE depositor (ID varchar(25),account_number varchar(25) NOT NULL,CONSTRAINT depositor_pkey PRIMARY KEY (ID, account_number),CONSTRAINT depositor_fkey FOREIGN KEY (ID) REFERENCES customer (ID) ON DELETE CASCADE); Query Editor Query History2324CREATE TABLE borrower (25ID varchar (25),26loan_number varchar (25) NOT NULL,27CONSTRAINT borrower_pkey PRIMARY KEY (ID, loan_number),28CONSTRAINT borrower_fkey FOREIGN KEY (ID) REFERENCES customer (ID) ON DELETE CASCADE,29CONSTRAINT borrower_fkey FOREIGN KEY (loan_number) REFERENCES loan (loan_number) ON UPDATE CASCADE30) ;3132CREATE TABLE account (33account_numbervarchar(25),34branch_name varchar (25) NOT NULL,35balance numeric(25,2),36CONSTRAINT account_pkey PRIMARY KEY (account_number),37CONSTRAINT account_fkey FOREIGN KEY (branch_name) REFERENCES branch (branch_name) ON DELETE CASCADE38) ;3940CREATE TABLE depositor (41IDvarchar(25),42account_numbervarchar(25) NÓNULL,43CONSTRAINT depositor_pkey PRIMARY KEY (ID, account_number),44CONSTRAINT depositor_fkey FOREIGN KEY (ID) REFERENCES customer (ID) ON DELETE CASCADE45) ;Data Output ExplainMessagesNotificationsERROR:constraint &#34;borrower_fkey&#34; for relation &#34;borrower&#34; already existsSQL state: 42710LO 2. Consider the bank database schema given below, where the primary keys are underlined.Write the SQL DDL corresponding to this schema (i.e. the CREATE TABLE statements).Make any reasonable assumptions about the data types. Be sure to declare primary andforeign keys; both types of constraints should be given appropriate names. Correctly andappropriately implement at least one instance for each of the following: check constraint,not null constraint, on delete cascade clause, on update cascade clause, and a defaultvalue statement. Lastly, construct the following SQL queries for this relational database.NOTE THE FOLLOWING: You are free to define the DDL for this banking database asyou wish, provided that the above requirements are satisfied. However, there is oneprohibition: You must not include a foreign key constraint on the account numberattribute of the depositor relation that references the account relation. To be perfectlyclear, this means you must not include the following foreign key constraint in your DDL:CREATE TABLE depositorCONSTRAINT depositor_fkey FOREIGN KEY (account_number)REFERENCES account (account number)ON DELETE CASCADEON UPDATE CASCADE);The reason for this specific foreign key prohibition concerns question (3) of thisassignment. The spirit behind question (3) is to write a trigger that performs the sameaction that is accomplished by the ON DELETE CASCADE clause of the above foreignSo, if you were to include this foreign key constraint with the ONkey constraint.DELETE CASCADE clause in your DDL, then the trigger you must define in question (3)would be useless since the action would be performed not by the trigger - but, rather bythe ON DELETECASCADE clause instead. If you were to include this foreign keyconstraint without the ON DELETE CASCADE clause in your DDL, then the DBMSwould disallow you from deleting any tuples from the account relation. If you include thespecified foreign key constraint in your DDL, you will receive a grade of zero forquestion (3).Database Schema:branch ( branch_name, branch_city, assets )customer ( ID, customer_name, customer_street, customer_city )loan (loan mиmber, branch пате, атоиnt)borrower ( ID, loan number )ассоunt (аccount mumber, branch_name, balance)depositor ( ID. account_number )Note that in the following problem, there is only one bank, and the individual brancheslisted in the data are all owned by the one bank.Data for this bank database can be found on Brightspace. You may, of course, add moredata if it aids you in testing queries.

Accepted Answer

Below is the answer with explanation: