applications of rdbms in real world

5 pts.
Tags:
Microsoft Access
MSSQL
Oracle
i need to know how rdbms is used in our real life with good example

Software/Hardware used:
software

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Meandyou
    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.
    5,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following