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
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
Get step-by-step solutions from verified subject matter experts
