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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!