Question

1. What are some examples of using worksheets instead of a database that you have used? How would a relational database simplify the work you need to complete?

Answer 1

Below are the some of the example of using worksheets instead of database.

• Spreadsheets in small scale industries to record the information and maintain the ledger instead of database.
• Worksheets are used for calculation purpose instead of database.
• Worksheets used where there is less access to internet such as small stationary shops, grocery shops.
• Some companies use spreadsheets due to less skilled employees in the organization, who are not capable of working with database.
• When less information need to be stored and send to other people through mail. Spreadsheets serves better compared to database.

Let us know how relational database simplify the work you need to complete.

• Relational database allows the user to categorize the information and and can be store the information for later use
• Relational database allows the user to extract specific information from the database.
• Data can be accessed and reassembled easily through relational database.
• Multiple user can access same data which will save lot of time while working
• Relational database eliminate data duplication which will save user time and simplify the work
• Data can be inserted without alternating the other data in the database.