0
Why is it better to store data in multiple related table rather than one big table?
Wiki User
∙ 12y ago
Basically to minimize redundancy (unnecessary repetition) of data in the database. By storing only information (fields) that directly relate to each other in each table AND modeling how the tables should relate to each other you also get the maximum flexibility in ways to retrieve information. A simple example would be a table to store INVOICES and a table to store CUSTOMERS. The INVOICE table only has information about an invoice; Inv#, Amount, Date, etc. and The CUSTOMER table information about customers; Name, Address, Phone, etc. An Invoice has one customer but a customer can have many invoices. If we give the customer a unique ID then, in the INVOICE table we need only store that ID (called a foreign key) but with it the database can look up the rest. So you dont store customer name, address, etc over and over again every time a customer gets a new invoice. The process of splitting up data into separate structures is called normalization. Often times data is de-normalized and repeating data allowed for performance or snapshot reasons.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
Can you store tomato paste in the can in refrigerator?
you could, however, it has a tendency to dry out rather quickly, so you are better off to store it a covered bowl or a jar
Where to find modern baby furniture?
Here is a great online store that will better answer your question in related links.
What is a multiple store?
A multiple store, also known as a chain store, has a large number of branch shops throughout the country...... :-D
Do I get a better deal buying automotive tires from a car dealership, a tire store, or somewhere else?
You definitely will get a better deal on automotive tires if you shop around at a discount tire store rather than going to a dealership. Lots of times these tire store run very good sales too.
is a barcode scanner the most effienct way to run my store enventory?
A barcode scanner would greatly help your store inventory because it would better hold the information rather than keeping a regular book .
What types of clothing are better to buy in store rather than online?
It's really a personal preference kind of thing when buying clothes in store than online. Many would probably prefer buying underwear and such in a store so they have an idea of where it's been.
What is a multiple store and give an example?
francewholesalers.com is a typical example of a multiple store where one can find almost all products and shop in whichever way one wants.
Is android better than Samsung app store?
No apple's app store is better. Also the app store is better than the kindle's app store. If you were deciding between the Iphone, Ipod touch or Ipad and the kindle get the APPLE PRODUCTS. MUCH BETTER!
What is a multiple chain?
It is businesses that have more than one store.
Why might a manufacturer choose to sell products through a store department store rather than a discount store?
Cuz bro
Which is better app store or android market?
Probably the app store because it has more apps, and they are probably better.
Why is it better to store goods in a warehouse than outdoors?
It is better to store goods in a warehouse rather than outdoors because it protects the goods from the elements, contamination and becoming dirty. Most warehouses are also designed with shelving and loading docks so it is easier to move goods around, prepare goods for transport and also find what you require.
