Reference no: EM13965831
Database schema for a customer sale database scenario:
customer(cust_id,cust_name) primary key(cust_id).
Item(item_id,item_name,price) primary key(item_id)
Sale(bill_no,bill_date,cust_id,item_id,qty_sold) primary key(bill_no),foreign key(cust_id),foreign key(item_id).
1) Create the tables with appropriate integrity constraints.Insert around 10 records in each of the tables.
2) List all the bills for the current date with the customer name and item_no.
3) List the total bill detail with the quantity sold,price of the item and final amount.
4) List the details of the customer who have brought a product which has a price>200.
5) Give a count of how many product have been brought by each customer.
6) Give a list of product brought by a customer having cust_id as 5.
7) List the item details which are sold as of today.
|
Therapeutic and nontherapeutic communication techniques
: Differentiate components of verbal and non-verbal expressionin persons with mental illness; Differentiate therapeutic and nontherapeutic communication techniques; and Identify types of treatment modalities to promote mental health/wellness
|
|
What is the purpose of critical appraisal
: What is the purpose of critical appraisal? Discuss how you would perform critical appraisal of articles selected for your topic.
|
|
Makes parts of a machine with a productivity
: A manufacturing plant makes parts of a machine with a productivity of 10 parts/hour. A quality inspector then inspects and tests the parts. The quality inspector can inspect 5 parts an hour. Show how you can optimize the schedule. Assume 5 day work w..
|
|
Probabilistic activity time estimates
: The following probabilistic activity time estimates are for a CPM/PERT network. Time Estimates (days) Time Estimates (days) Activity a m b Activity a m b 1 1 2 6 7 1 1.5 2 2 1 3 5 8 1 3 5 3 3 5 10 9 1 1 5 4 3 6 14 10 2 4 9 5 2 4 9 11 1 2 3 6 2 ..
|
|
Schema for a customer sale database scenario
: Database schema for a customer sale database scenario: customer(cust_id,cust_name) primary key(cust_id). Item(item_id,item_name,price) primary key(item_id)
|
|
Distinguish between recourse and nonrecourse financing
: Distinguish between recourse and nonrecourse financing. Give an example of each. Should the investor select the origination LTV that maximizes the expected return on equity? Explain why or why not.
|
|
What are economies of scale in a manufacturing plant
: What are economies of scale in a manufacturing plant? Do they continue forever? What are diseconomies of scale? How might you decide the optimal size of a plant?
|
|
There are several tools for appraising performance
: There are several tools for appraising performance. Assume you were charged with designing (or redesigning) the performance system at your organization. Which tool(s) would you desire to implement and why? Be sure to include any concerns that you mig..
|