JustAnswer > Homework
Ask A Question|Register|Login|Help
JustAnswer

Homework

Ask a Homework Question, Get an Answer ASAP!

Have your own Homework question?

22 Tutors and Teachers are Online Now
characters left:
Not a Homework Question?

Question

Joshua has a logical proposal for our new Inventory table and its relationships with the other tables. He has even included a reorder point, so we know when to reorder specific parts :-) Are these calculated fields? What did you say about calculated fields in a table?
Would we also need to account for things like the dog's 4 legs, its tail, ears, tongue and so on? (These parts are not the same as the other
models, as they all resemble humans.)

INVENTORY
ItemNum     Description     ProdNum     ON_HAND     ON_ORDR     REORDRPNT
1234     Voice Box     8844     4     1     5
5678     Casing     8844     8     0     7
9010     Flash Drive     8844     5     0     3
9110     Sound Recorder     8844     4     0     3
                         
For the additional table, inventory, the primary key will be the ItemNum field. It will also have a Foreign Key the ProdNum field, which is the primary key of the Products table.   This table will have a relationship with the Products table as it is linked to the Product models for inventory tracking, and it will also have a relationship with the orders table and rules created to automatically reduce on_hand quantities as the order for ProdNum 8844 is placed.

Submitted: 689 days and 13 hours ago.
Category: Homework
Value: $10
Status: AWAITING CUSTOMER ACTION
+
Read More
Posted by Dolly 689 days and 12 hours ago.

Answer

THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.

689 days and 11 hours ago.

Reply

Can you give a little more on your answer?

Accepted Answer

THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.

Picture
Expert: the prof
Pos. Feedback: 100.0 %
Accepts: 144
Answered: 12/20/2007

Teacher

Tutoring, classroom and online instruction for over 17 years, high school through graduate school

+
Read More

Related Homework Questions

  • M/B and share pdrice. Your are given the following inforfmat...
  • Businesses that adjust their prices upward in response to hi...
  • Which false assumption is often made by professionals such
  • what are the most outstanding differences between the psycho...
  • Q: Assignment: Developing Good Business Sense · Resources:
  • I will try to be brief and clarify it by the steps done: 1)...
  • what makes knowledge workers unique in trms of their compe
  • The Sharpe Corporation's sales for the first eight months of



Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.
Question List | Become an Expert | Terms of Service | Security & Privacy | About Us
© 2003-2009 JustAnswer Corp.