Answer:
The correct option is option 4 from the options indicated below:
Explanation:
The options are as given below
1-SELECT customer# FROM customers
UNION
SELECT customer# FROM orders;
2-SELECT customer# FROM orders
MINUS
SELECT customer# FROM customers;
3-SELECT customer# FROM orders
INTERSECT
SELECT customer# FROM customers;
4-SELECT customer# FROM customers
MINUS
SELECT customer# FROM orders;
Option 1 is not correct as it will provide the list of all the customers whether they have placed order or not.
Option 2 is not correct as it will provide the list of customers who have placed order but are not in the customers table. This will return the empty records.
Option 3 is not correct as it will provide the list of customers who have placed the order.
Option 4 is correct as it will provide the list of customers from the CUSTOMERS table which are not in the Orders table. thus the list of customers who have not placed the order yet.
Answer: Market-space
Explanation:
Market-space is defined as marketing concept that states electronic information exchange mechanism. Physical constraints do not interrupt selling and buying mechanism in this environment.This space is constructed through online facility of technology.
Market space provides the service to customer as well as seller to display their requirements and accordingly interact for exchanging the product with payment. Both the parties agree on time location and transaction method for buying and selling.
Query data
Arrange data in certain order
Update information in more than one place at the same time
Merge data into a word processing document
Calculate loan payment is something you could possibly make a database do, but more likely you would simply use a spreadsheet. Databases are mostly for for storing, retrieving, sorting and manipulating data.
