Benefit Of Using A Relational Database

Good Essays
The benefit of using a relational database is that it can help the efficiency of data storage by avoiding data duplication. It is very easy to change data and the format of it which can be added or removed easily. The data can only be stored once so no more than one record change is needed. Relational databases are used to work together by primary key and foreign key as this creates a link between more than one table. By this it can use the attributes and entities within the database which makes it easier to access. As this creates a link between each table such as if a customer was to buy a product, a record is then made this will store their information such as their first name, surname and adds a unique Customer ID in the customer table. The product table will store information such as the title, price and Unique product ID. Now …show more content…
This will let users to lower search times instead of users having to find a lot of attributes with in the relational databases. Users will also be able to filter queries to find something in particular of what they are looking for.
Another benefits of relational database is that there are many databases that can be sorted so it looks more organised for example if it is about customer, then their details such as name, address, driving license will be in the customer table. Another example is that if it is about a product then it will have its own unique ID, Title, Quantity, price and many more.

Another benefit of database is that users can create reports that has a feature which allows the user to format the database into the report. Instead of users creating reports from scratch, they can add a new one from the database, this will save time and money. Users can design these reports to however they want and make it look more appealing when looking at different kinds of

Related Documents

  • Decent Essays

    However, when business customers log in they deserve a display based upon their historical preferences rather than your entire catalog. You can also have the custom web design and development team integrate portions of your infrastructure, such as your distribution and supply center. 2. Payment and Account Differences Your consumer based website can use a simple shopping cart that allows for easy placement and removal of desired products. A "save for later" or "wish list" allows them to mark items that they are considering for future purchase.…

    • 783 Words
    • 4 Pages
    Decent Essays
  • Decent Essays

    Be Well Case Study

    • 1183 Words
    • 5 Pages

    Another pro is the flexibility of being able to backup data without the hassle, the cloud system can back up data automatically so the business does not have to waste their time doing this task themselves. One con of data backup through AWS is that the business has less control over the process. While this can be convenient as it frees up time for more important tasks, it also means you are relying a 3rd party to successfully back up all of your data. Since Be Well is a new start up, utilizing AWS for data backup will be even more convenient as they do not have previous data stored in other locations. Be Well can devote more time to marketing and selling their product, knowing that AWS is responsible for making sure their data is not going…

    • 1183 Words
    • 5 Pages
    Decent Essays
  • Decent Essays

    Data redundancy is minimised, which saves disk space and reduces inconsistencies It is simpler to modify a small table with small amounts of data than to modify a large complex table. Security is also improved as the DBA can allow access to limited tables to certain users. Security is easier to control when normalisation has occurred. Data integrity means the users know they have consistent and accurate data within a database. Drawbacks of Normalisation Most databases have some level of normalisation.…

    • 1521 Words
    • 6 Pages
    Decent Essays
  • Decent Essays

    Quickbook Advantages

    • 909 Words
    • 4 Pages

    This helps keep track of your employee’s benefit program, their records, process either manual paychecks or direct deposit, pay taxes and calculate to the suitable tax authority. There are many Intuit payroll plans that you can choose from. QuickBooks makes everything easier and makes finding things and keeping track of them way more convenient for the…

    • 909 Words
    • 4 Pages
    Decent Essays
  • Decent Essays

    The most important aspect of data mining and data warehousing is the ability to communicate, directly and indirectly with the customer. A company can directly solicit the customer feedback on a product that they have already delivered. The customer feedback can be retained and reviewed for product change or product research. Indirectly, the business can make purchasing suggestions to a customer via email, advertising, or direct mailing based on information previously retained in the system. Following this…

    • 804 Words
    • 4 Pages
    Decent Essays
  • Decent Essays

    Online Advertising also can acts as an information service and educates the con-sumers. It allows them to know exactly what they want and where to get it. From there it allows customers enjoy the convenience and makes the life of the consumer easier, more comfortable and pleasant. Online advertising helps reduction the cost of hiring staffs to advertising product or maintaining which product is in demand. This reduction in the cost is generally passed on to the consumer and that is why price of goods are found in the internet are generally lower than goods in outlet retail.…

    • 1043 Words
    • 4 Pages
    Decent Essays
  • Decent Essays

    While this could simplify the work that is completed, there are actually many benefits to inventory forecasting that can actually help make your business better than it started. Keep these in mind as you are making your plans for managing the inventory…

    • 1303 Words
    • 6 Pages
    Decent Essays
  • Decent Essays

    Chevron Case Study

    • 789 Words
    • 4 Pages

    It is inexpensive and secure as users can access through SaaS application. The user don’t need to sign on repeatedly for accessing different enterprise applications. It facilitates biometric authentication. It consolidates user ids and passwords and it’s easy for the IT departments to audit how these being used in the system. It reduces cost and increases productivity.…

    • 789 Words
    • 4 Pages
    Decent Essays
  • Decent Essays

    The Dangers Of Computers

    • 1401 Words
    • 6 Pages

    These processers offer the application of different types of software that helps businesses keep track of documents, files, and schedules (Writing). Also, they permit businesses to organize all of their information in an accessible manner. Overall, the ability for this machine to organize a whole companies files effectively leads to superior time management and can possibly save money. For example, because computers allow work to be done quicker and more effectively, it’s possible for a company to hire less people, saving them money. The speed of a computer is also another beneficial detail.…

    • 1401 Words
    • 6 Pages
    Decent Essays
  • Decent Essays

    Otis Case Analysis Essay

    • 706 Words
    • 3 Pages

    Proper metrics should be applied to measure customer satisfaction like online survey tools. There should be a proper measuring instrument to monitor the level of outcome. Every component should align with the goal of the company and be applicable across all the geographies. The sales factory operations can be carried out through the web which will provide faster operations and reduce cycle time. The results of analytics should be aligned with the financial analysis to track cost and account billing.…

    • 706 Words
    • 3 Pages
    Decent Essays