Question: Could you please check this in SQL if it's correct! Please correct the mistake if there is any. Thank you! I appreciate your efforts to

Could you please check this in SQL if it's correct! Please correct the mistake if there is any.
Thank you! I appreciate your efforts to help us.

CREATE TABLE user (

user_id NUMBER(10),

user_name VARCHAR2(10),

user_adress VARCHAR2(10),

user_phone NUMBER(10),

CONSTRAINT user_pk PRIMARY KEY (user_id)

(;

CREATE TABLE account (

acct_no NUMBER(16),

acct_type VARCHAR2(15),

user_ID NUMBER(10),

CONSTRAINT acct_pk PRTMARY KEY (acct_no),

CONSTRAINT acct_fk FOREIGN KEY (user_ID) REFERENCES user(user_id)

);

CREATE TABLE card (

card_no NUMBER(16),

card_type VARCHAR2(10),

user_ID NUMBER(10),

acct_NO NUMBER(16),

CONSTRAINT card_pk PRTMARY KEY (card_no),

CONSTRAINT card_fk FOREIGN KEY (user_ID) REFERENCES user(user_id),

CONSTRAINT card_fk2 FOREIGN KEY (acct_NO) REFERENCES account(acct_no)

);

CREATE TABLE transaction (

Trans_ID NUMBER(15),

Trans_Tybe VARCHAR2(10),

card_no NUMBER(16)

acct_no NUMBER(16),

CONSTRAINT Trans_pk PRIMARY KEY (Trans_ID),

CONSTRAINT Trans_fk FOREIGN KEY (card_no) REFERENCES card (card_no)

CONSTRAINT Trans_fk2 FOREIGN KEY (acct_no) REFERENCES card (acct_no)

);

CREATE TABLE receipt (

receipt_id NUMBER(15),

Trans_id NUMBER(15),

user_id NUMBER(10),

CONSTRAINT recepit_pk PRIMARY KEY (receipt_id),

CONSTRAINT receipt_fk FOREIGN KEY (TRANS_ID) REFERENCES transaction (TRANS_ID),

CONSTRAINT receipt_fk2 FOREIGN KEY (user_id) REFERENCES user (user_id)

);

CREATE TABLE user_transaction (

cust_trans_id NUMBER(15),

user_id NUMBER(10),

Trans_id NUMBER(15),

acct_no NUMBER(16),

receipt_id NUMBER(15),

CONSTRAINT user_trans_pk PRIMARY KEY (cust_trans_id),

CONSTRAINT user_trans_fk FOREIGN KEY (user_id) REFERENCES user (user_id),

CONSTRAINT user_trans_fk2 FOREIGN KEY (Trans_ID) REFERENCES transaction(TRANS_ID),

CONSTRAINT user_trans_fk3 FOREIGN KEY (acct_no) REFERENCES account (acct_no),

CONSTRAINT user_trans_fk4 FOREIGN KEY (receipt_id) REFERENCES account (receipt_id)

);

CREATE TABLE user_acct (

user_acct_id NUMBER(10),

acct_no NUMBER(16),

user_id NUMBER(10),

CONSTRAINT user_acct_id_pk PRIMARY KEY (user_acct_id),

CONSTRAINT acct_no_fk FOREIGN KEY (acct_no) REFERENCES account (acct_no),

CONSTRAINT user_id_fk2 FOREIGN KEY (user_id) REFERENCES user (user_id)

);

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!