My user now wants to store (for a few months at least) QUOTATION data. I can add a table of course, with a unique ID for each quote, but it seems to me that all the other fields (bar the date) can be derived from the other tables...if i put the relevant fields in the Quote table they will be duplicates won't they? Won't this compromise my normalization efforts? Anyone got an idea of how best to crack this little item? Thanks,
Stonward
4 1440
A little more info on exactly what you're trying to accomplish, as well as your current data structure, might help! Is this a price quote for a job/service? If so, where is the data on this stored? Does it have a unique identifying number/code? Why do you feel the need for a separate quotation table? Every developer's situation is unique, but I can't imagine needing a table simply to hold this one piece of information plus a single date.
You're correct in thinking that you don't want to store redundant data any more than is absolutely necessary! You need some Primary/Foreign keys to join this information together. As I said, if we need a little more about your actual situation , we may be able to better advise you!
Welcome to TheScripts!
Linq ;0)>
My user now wants to store (for a few months at least) QUOTATION data. I can add a table of course, with a unique ID for each quote, but it seems to me that all the other fields (bar the date) can be derived from the other tables...if i put the relevant fields in the Quote table they will be duplicates won't they? Won't this compromise my normalization efforts? Anyone got an idea of how best to crack this little item? Thanks,
Stonward
Use FKs instead of data duplicates.
Does this make a sence? :)
Thanx for replying so quickly guys! I'm modernising a database system I built a couple of years ago. It's a basic stock system with sales and purchasing ability. Now we need to add a quotation facility...I'd already built the form when the (main) user came to me asking that the data be saved. This is costings, (cost per item, VAT, total), quantity, PRODUCT ID (and details) and customer ID (and details) if known. Obviously I can't use the Sales/Purchase tables, so I couldn't see any other way than to add a table.
With reference to the FK idea, I'm not sure how that would help?
My tables are linked of course, with Products linked to Orders and Order Details (to get over the many to many problem) and likewise with Purchases. Suppliers and Customers have a simple one to many with the Orders/Purchases tables.
Could I just use a report, via a query, using a table to save just the quote ID and date perhaps?
Thanx for replying so quickly guys! I'm modernising a database system I built a couple of years ago. It's a basic stock system with sales and purchasing ability. Now we need to add a quotation facility...I'd already built the form when the (main) user came to me asking that the data be saved. This is costings, (cost per item, VAT, total), quantity, PRODUCT ID (and details) and customer ID (and details) if known. Obviously I can't use the Sales/Purchase tables, so I couldn't see any other way than to add a table.
With reference to the FK idea, I'm not sure how that would help?
My tables are linked of course, with Products linked to Orders and Order Details (to get over the many to many problem) and likewise with Purchases. Suppliers and Customers have a simple one to many with the Orders/Purchases tables.
Could I just use a report, via a query, using a table to save just the quote ID and date perhaps?
Sorry, this doesn't make a sence.
Would you be so kind to post tables metadata. I think you should revise table relationships.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Marek Mänd |
last post by:
<style type="text/css">
q:after{content:',"'}
</style>
<q>This will be the shame of CSS</q> claimed Marek Mänd and added that
<q>consumers expect to create generated content via CSS where there...
|
by: Xah Lee |
last post by:
sometimes i wish to add white space in <p> as to achived effects
similar to tab.
what should i do?
using empty image seems the sure way but rather complicated. (and
dosen't change size with...
|
by: swethak |
last post by:
Hi,
I am desiging the calendar application for that purpose i used the below code. But it is for only displys calendar. And also i want to add the events to calendar. In that code displys the...
|
by: nomad |
last post by:
Hello everyone:
I new to PHP and I'm reading a book on PHP Bibles 2nd edition. It has to deal with a user-rating system. There are 4 scripts to it.
I'm getting an error
Unknown column...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |