Reference no: EM13961121
Database Schema for a customer-sale scenario Customer(Cust id : integer, cust_name: string) Item(item_id: integer, item_name: string, price: integer) Sale(bill_no: integer, bill_data: date, cust_id: integer, item_id: integer, qty_sold: integer) For the above schema, perform the following-
a) Create the tables with the appropriate integrity constraints
b) Insert around 10 records in each of the tables
c) List all the bills for the current date with the customer names and item numbers
d) List the total Bill details with the quantity sold, price of the item and the final amount
e) List the details of the customer who have bought a product which has a price>200
f) Give a count of how many products have been bought by each customer
g) Give a list of products bought by a customer having cust_id as 5
h) List the item details which are sold as of today
i) Create a view which lists out the bill_no, bill_date, cust_id, item_id, price, qty_sold, amount
j) Create a view which lists the daily sales date wise for the last one week
|
Experiencing which part of the job design model
: Michaela works as an electrician and was recently sitting with a friend and explaining her job. "When I enter a job site, there is virtually nothing except the framing and a few walls. Explain which core job dimension from the Hackman and Oldham Mode..
|
|
Which of maslow five levels of need are on display in photo
: Which of Maslow's five levels of need are on display in this photo? Describe how the needs of the rescuer clearly differ from those of the person who is being rescued
|
|
Design and code a dictionary of words
: Design and code a dictionary of words, which can store words and should provide the following operation: 1) Words could be retrieved from the dictionary through a find utility.
|
|
What are the competencies needed
: What are the competencies needed (or should be required) to be an effective U.S. senator? A famous musician or actor? How are these competencies similar or different? minimum of 200 words please
|
|
Database schema for a customer-sale scenario
: Database Schema for a customer-sale scenario Customer(Cust id : integer, cust_name: string) Item(item_id: integer, item_name: string, price: integer) Sale(bill_no: integer, bill_data: date, cust_id: integer, item_id: integer, qty_sold: integer) Fo..
|
|
Describe the deductive reasoning process
: Describe the deductive reasoning process that was applied to analyze the hospitals’ rising cost of uncompensated care and justify the requirement for upfront payment.
|
|
Find the current in each resistor as well as the voltage
: A person has a 72 V battery along with 6, 9, and 18 ohm resistors. They are first wired in series, then is parallel. First, sketch each circuit. Then, find the current in each resistor as well as the voltage across each resistor for each resistor,..
|
|
What is the traffic intensity in the returns system
: A large clothing store offers a ‘no quibble’ return policy under which shoppers can return unwanted goods to the store and receive their money back. They have to take their unwanted goods to a returns desk where there is one server. What is the traff..
|
|
Solve the relative velocity equations using a vector polygon
: Point A of the link BA has a downward velocity of Va = 2 m/s during an interval of it's motion. For the position where Φ = 30 degrees determine the angular velocity W of AB and determine the velocity (Vg) of the midpoint G of the link. Solve the ..
|