|
QUESTION:I am currently trying to design a Database tracking the
sales and disposals of our heeavy construction equipment
that my company sells. So far I have five table setup
which are as follows: Equipment table, Company Table,
Location Table, Disposal Table, Disposal_Category Table,
and Buyer Table. Now, The problem that I am having is
Establishing the relationships between the tables. The
primary purpose for designing this database is to keep
track of all the disposals, and second is to be able to
print out "Bills of sales" and "Invoices" for each of the
sales that I process. Can any one help me out?
ANSWER: Without more description, we can only guess what data elements you might be
storing in each of the tables you named. We probably need that info to help
you establish relationships.
|
|
|
|
