For Inventory DB (very common application) identify the types of
inventory transactions to accurately reflect status of inventory of
both serialized and commodities.
Identify business rules and write SQL commands (DDL &DML) for one part
of the problem
1.  Create physical tables
2.  Create views to simplify programming
3.  Identify indexes, FK, constraints
4.  Any additional attributes not identified that are useful / needed

Problem:
Prepare inquiry (report) to report on PC's out for repair.
Consider Joining:  VENDOR, REPAIR, ITEM tables
------------------------------------------------------------
Here is what I have come up with thus far:
CREATE TABLE VENDOR (
     V-CODE INTEGER NOT NULL UNIQUE,
     V_NAME VARCHAR(35) NOT NULL,
     V_CONTACT VARCHAR(15) NOT NULL,
     V_AREACODE CHAR(3) NOT NULL,
     V_PHONE CHAR(8) NOT NULL,
     V_STATE CHAR(2) NOT NULL,
     V_ORDER CHAR(1) NOT NULL,
     PRIMARY KEY(V_CODE);

CREATE TABLE REPAIR(





CRATE TABLE ITEM(







Please complete this for me!

---

Request for Question Clarification by answerguru-ga on 27 Nov 2002 14:37 PST

Hi bildy-ga,

I'd be happy to help you with this, but I feel that is not worth the
time to complete that many queries for less than $50. If you don't get
a response from another researcher, you can take me up on my offer :)

Thanks,
answerguru-ga

---

Clarification of Question by bildy-ga on 29 Nov 2002 14:28 PST

Would you be willing to answer the question for $35?

---

Request for Question Clarification by answerguru-ga on 29 Nov 2002 15:32 PST

Hi again,

No, I don't think anything under $50 would be sufficient renumeration
for the effort required to answer your question. Again, let me know if
you are interested :)

answerguru-ga