Create an inventory table that stores the number of items

Reference no: EM132823600

Assignment: Start with the solution schema for Assignment 1 (see solution files under Assignment 1).

1. Create an 'inventory' table that stores the number of items available for each seller. How would you modify the 'item' and 'seller' tables to store this information?

2. Pre-populate 'seller', 'item', 'item_category', and 'inventory' with data.

3. Write a SQL script to create a new order. This script should do the following:

• Create the customer if they don't exist

• Place an order for an item or items

• Store the shipping address

• Reduce the count of the number of items left in the inventory based on this order, e.g. if there are 10 Levi's Jeans from seller Levi's, and an order is placed for 2 of them, the inventory count goes down to 8

• The order should have 'Open' status

4. Write a SQL script that cancels an open order. This script should do the following:

• Uses an input order_id representing an order that is 'Open'

• Sets the order status to 'Canceled'.

• Update the inventory of reset the number of items to its original amount prior to making the order

Make up your own data for this assignment, or use the existing data from Assignment 1 as a start.

Reference no: EM132823600

Questions Cloud

How much must mrs manilow include in gross income : How much must Mrs. Manilow include in gross income from these payments in Year 2? Mrs. Manilow's husband died in November Year 1.

Describe potential disadvantages of paas : Describe potential disadvantages of PaaS. Describe how a cloud-based database management system differs from an on-site database.

Record the issuance of the bonds on January : Record: (a) the issuance of the bonds on January 31, (b) the semi-annual interest payment and discount amortization on June 30

How much would the value of the company increase : The company's cost of capital is 8%. By how much would the value of the company increase if it accepted the better project (plane)?

Create an inventory table that stores the number of items : Create an 'inventory' table that stores the number of items available for each seller. How would you modify the 'item' and 'seller' tables to store.

Compute the firm NPV : A firm plans to operate for the next 8 years, The interest rate (discounting rate) is 3%. Compute the firm's NPV (net present value)

How the accounts should appear in the opening balance sheet : The fair value of the equipment is $20,350. Indicate how the accounts should appear in the opening balance sheet of the partnership.

Explain the benefits of good data visualization : The objective of this assignment is demonstrate the benefits of good data visualization as it relates to Big Data within a particular context.

Provide the entries to update the bond accounts : Provide the entries to update the bond accounts in 20X8 (entries have been completed through 1 May 20X8) for this portion of the bond and to retire the bonds.

User Account

All Pages