Reference no: EM13968400
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.
|
Eligible number of voters in the united states
: Why is the eligible number of voters in the United States who participate in elections lower than it is in Netherlands, Belgium or Italy? Will this trend continue? (250 words)
|
|
Provide a synopsis of the article
: Title: Sports Nutrition Article, For this Forum 4 post you will need to go to following website:http://www.gssiweb.org. Choose one article. Read the article. Provide a synopsis of the article
|
|
Add a strong acid to a solution of phosphate buffer
: If you add a strong acid to a solution of phosphate buffer, which form(s) of phosphate in the equilibrium above would increase in abundance first? Which would decrease first? If you kept adding strong acid until the solution was no longer able to buf..
|
|
Post a paragraph that explaining to your constituents
: Post a paragraph, explaining to your constituents what you think about this proposed amendment, and why you would support or oppose it.
|
|
Database schema for a customer sale
: 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)
|
|
What type of research design was used
: Read the Gilmour et al. article. What type of research design was used? What questions/hypotheses were being evaluated? What methods were used? How were the results summarized and organized
|
|
What characteristics of data would lead you to select
: What characteristics of data would lead you to select one type of statistical analysis over another? Be specific, give examples, and support your answer
|
|
What would be your preference as a researcher and why
: How does the selection of a one-tail or two-tail test affect the risk of each type of error? How does it affect power? What would be your preference as a researcher and why
|
|
What are advantages of moving to experimental designs
: What are advantages of moving to experimental designs to evaluate a treatment? What might be some difficulties in following rules for proper/valid experimental designs when evaluating a type of clinical treatment? Be specific in your answers and g..
|