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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started