Question: Please provide sql command for the database with following requirements. 1.Part table with - partNo (PK) - partName - partDescription - currentPrice - qty quantity
Please provide sql command for the database with following requirements.
1.Part table with
-partNo (PK) -partName -partDescription
-currentPrice -qty quantity of a part in stock (also referred to as Quantity On Hand (QOH))
2. Client table with
-clientComId (PK) -clientCompName
-clientCity -clientComPassword
-moneyOwed
3. Purchased Orders (PO)
- poNum -clientCompId
-date -status
With the following relationship
Each Purchase Order (PO) has a number of lines, each one denoting an order for a number of units of one part. Thus, for each part, the part number and its price need to be stored together with the quantity on order. Lines are assigned unique numbers starting at one for the first line, 2 for the second and so on. As prices for parts are subject to change, the purchase price for each part on an order line must be stored in the DB also.
Will upvote if answered in 1 day! Thanks!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
