Databases | SQL | Oracle | MS Access Answers

how SAP’s Ariba suite of solutions can aid CQ in managing their relationship with the overseas suppliers.

https://drive.google.com/file/d/0BxxknQPQ0yUCc3RhcnRlcl9maWxl/view?usp=sharing&resourcekey=0-nJh0ENVbNWdYvw28tEVpiQ

Kobla Amevor’s Tech Systems Company at Battor offers a large selection of computers, keyboards, servers,

scanners, networking equipment, peripherals and security systems. The prices of computers and networking

equipment are constantly changing.

When a customer requests for information about the prices of products, a sales agent refers to a book

containing the price list and then calls the supplier for the current price to check if there’s been a price

increment.

The supplier also utilizes a manual catalogue sheet, which has to be refreshed every day. Frequently, Kobla

Amevor’s sales agent spend some time waiting for the supplier to confirm prices as they usually do not

have the most current pricing promptly available.

What are the implications of the current business processes on the efficiency and profitability of Kobla

Amevor’s Tech Systems Company? Explain ways in which the business can be improved through the use

of information systems.

. Create a table Customers(CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_ADDRESS, CUST_INCOME)

Create a table Orders(ORDER_ID, ORDER_DATE, CUSTOMER_ID, ORDER_TOTAL)

For each of the above attributes, define their corresponding data types as per your understanding.

Write an SQL query to Insert 6 tuples to each table

Write an SQL query to fetch the details of customers who lives in 'Delhi'.

Write an SQL query to print details of the customers whose FIRST NAME ends with ‘s’ and contains 'five' alphabets.

Write an SQL query to find the maximum of order total from orders table.

Write an SQL query to print details of customers excluding customer address as "Delhi" and "Bombay".

Write an SQL query to fetch customer id of the customers having maximum income and group by first name.

Write a SQL query to print the customer details whose income lies between 40000 to 60000.

Write an SQL query to print details of the Employee whose FIRST NAME ends with ‘n’ and s.

Identify and with practical examples give the different types of languages that are

available in the DBMS?

How is the pattern matching done in the SQL?

1) a. Explain the concept of ACID properties in DBMS in your own words?

b. How is the pattern matching done in the SQL?

2) Identify and with practical examples give the different types of languages that are

available in the DBMS?

Identify and with practical examples give the different types of languages that are available in the DBMS?

How is the pattern matching done in the SQL?