Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

. Retrieve a list of customer names and address information for those who have terminated accounts using SQL commands (I am using APEX). Customer Account

. Retrieve a list of customer names and address information for those who have terminated accounts using SQL commands (I am using APEX).

Customer Account Person serves as a bridge table, between the person table and customer table.

image text in transcribedimage text in transcribed

image text in transcribed

Table: PERSON ? Column Data Type Length Precision Scale Nullable NUMBER PERSON_ID PERSON GIVEN_NAME PERSON MIDDLE_NAME PERSON FAMILY_NAME PERSON ADDRESS 1 0 No 25 - No -Yes - No - Yes VARCHAR2 VARCHAR2 25 VARCHAR2 25 VARCHAR2 100 Table: CUSTOMER ACCOUNT_PERSON Column Data Type Length Precision Scale Nullable CUSTOMER_ACCOUNTID NUMBER 0 No PERSON ID NUMBER 0 No Table: CUSTOMER ACCOUNT Column Data Type Length Precision Scale Nullable CUSTOMER ACCOUNT ID CUSTOMER HOLD_INDIC DATE ENROLLED DATE TERMINATED NUMBER 0 No - No - No Yes CHAR DATE 7 DATE 7

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 11G SQL

Authors: Joan Casteel

2nd Edition

1133947360, 978-1133947363

More Books

Students also viewed these Databases questions

Question

Define Administration and Management

Answered: 1 week ago

Question

Define and measure service productivity.

Answered: 1 week ago