I hope my question isn't too confusing. I have many tables belonging to 3
inventory categories (Computer, Hard Drive, and Monitor). While Comp & HD
categories share designations (Status, Brand), Comp & Monitor shares
others
(Recycler, Donated) Initially the inherited database design held 3
separate
relation****ps in one window. Realizing that I will need re****ts showing
results for one category/designations and at other times needing a re****t
showing 2 or 3 categories/designations at once, I joined all tables.
Before
committing to this, I'm wondering which design might be most efficient-
seperate categoried tables with their related designations or one large
relation****p including all categoried tables with related designations? I
have 14 tables.
tblComputers tblHardDrive
tblMonitor
|
