applications of rdbms in real world
i need to know how rdbms is used in our real life with good example
Software/Hardware used:
software
Software/Hardware used:
software
ASKED:
December 14, 2009 1:44 PM
UPDATED:
December 15, 2009 1:58 PM
Answer Wiki:
Sales is always a good example.
Here are 6 files that would be used when creating a Purchase Order for a company. Depending on the level of DB normalization, files would contain different information. But, this should give you an idea.
FIle 1 - Customer file -- Contains a unique Customer Number and demographic information about the customer. - Single record per customer.
File 2 - Sales Rep file - Contains a unique identifier about sales personel. Singe record per sales staff.
File 3 - Sales History file -- Contains the unique Customer number. multiple records. Onve for each item purchased. Include date, quantity and PO number.
File 4 - PO file - Contains unique Purchase Order Number -- Conaints date / time of order, date / time shipped, Sales Rep ID#, Total amount, and other fields.Since record per PO.
File 5 - PO detail file - Contains multiple records per PO#. one record with Item #, quanity ordered, quantity shipped, etc.
File 6 - Item file - Contains item informatin - Unique Item number, description, size, cost, and other information that makes theitem unique.
To see all answers submitted to the Answer Wiki: View Answer History.
regarding the answer above, don’t forget that in the best practices your “sales rep file” might be a view of your employee table. What I am trying to point out is that, in the perfect world, data exists but once. No system is “stand alone” but is part of a larger system, which in turn is part of a larger … ad infinitum.