Unit 18 Database Design Oliver Taylor Resubmission

Better Essays
Unit 18

Task 1 - What are the benefits of a relational database?
A benefit of a relational database would be that the data is only stored once. This means you don’t have to change multiple records and it doesn’t take up much storage space. For the veterinary practise this is ideal for them, as this is the main reason to why they’re changing from paper to Microsoft Access. Having everything on Access and not on paper means they can search for information quicker through the search bar and also it can all be stored on a hard drive. This will save money on buying filing cabinets, on storage space, time spent looking for information and on buying materials such as paper and ink.

Another benefit would be its more secure. This is because you can split the tables into two, making one of them confidential by adding a username and password. This will then limit the amount of people that can view/change the data, which is what you’d want if someone were to take/hack your system because the files wouldn’t be viewable unless they had the username and password. Another way this can be used if a receptionist needed to access your details, for example their address, they could do so. But they wouldn’t be able to access other parts of information, for example their card details.

With quickly accessing people’s information being very important as you don’t want to keep the customer working, being able to perform a complex query is critical. This can be done thanks to a language called TSL, which was developed to allow people to ‘Insert’, ’Update’, ‘Delete’, ‘Create’ and ‘Drop’ table records. You can narrow down these records even more if you use the ‘Where’ clause.

Reporting

Database reporting is the results of a formatted database query and will have useful data in it, this will allow you to make better decisions and also make it easier to analysis the data. You’ll be able to find reporting in most business programs, these will be built in tools that will be at the

You May Also Find These Documents Helpful

  • Good Essays

    Athabasca Assignment

    • 837 Words
    • 4 Pages

    Relational databases are not new technology. Commercially, they gained importance in the early 1980s with the introduction of Oracle’s relational database, and since then they have been an essential tool for most businesses. Databases are critical tools that help to support various business functions in an organization. These information systems help a business to build and maintain competitive advantage. Databases not only support the operational levels of business—they are also used to support the activities of managers.…

    • 837 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Week 1 BIS221

    • 536 Words
    • 3 Pages

    Databases allows companies to organize all their information on one place, making it easy for people to access and share information.…

    • 536 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    3. Another benefit of database is that it aids in the communication process. If information needs to be spread among a large group of users it would be easier to create a database where they all have access.…

    • 832 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The main advantage of a standardized medical records database would be the convenience. To be able to locate a file with the push of a button would make work for the staff a lot faster. With paper documents it could take hours for another physician or hospital to obtain the information they would need. Another advantage would be the time it would take for a person to travel to and from their physician office to obtain their records for another facility.…

    • 361 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Unit 18 - Database P1, M1

    • 995 Words
    • 4 Pages

    Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.…

    • 995 Words
    • 4 Pages
    Powerful Essays
  • Better Essays

    Realtors have found that listing their properties from the most expensive to the least expensive (or vice-versa) is helpful to buyers and sellers. It would be frustrating to find properties in the same price range if they were listed chronologically.…

    • 2343 Words
    • 10 Pages
    Better Essays
  • Powerful Essays

    Database Environment

    • 1121 Words
    • 5 Pages

    When building a system for information, you have to decide how much responsibility for data management your software will take. A database can be rather large or it can be small depending on the information that is being stored. Request for information from a database are made in the form of a query or a question asking the database for particular information. All database management systems are not the same from a technical standpoint. They differ mostly in the way they organize their information internally. The internal organization can then determine how quickly and supplely the information can be extracted (Jupitermedia, 2011) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Database for Scheduling

    • 528 Words
    • 3 Pages

    There are some advantages and disadvantages for creating a database within your company. First the advantages include:…

    • 528 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Dbm 381 Week 1 Individual

    • 971 Words
    • 4 Pages

    Examination of the types of database systems that are available and how health care facilities utilize these different types of databases is the topic of this report. Giving more detail on the different types of architecture of databases and data structure will follow.…

    • 971 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    There are several advantages in having a standardized medical database. The most important advantage is a standardized medical database will offer medical facilities access to the patient records more easily. If a patient decides to change health care providers or if an emergency situation arose the patient would be able to receive service immediately. The database will contain patient’s medical information, so that if a patient were to encounter a medical emergency their medical files would be easy to obtain in order to treat the patient for the particular injury or illness. For example, if I were taken to the emergency room, the doctor would able to see that I am allergic to the…

    • 253 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    I think that the benefits of having medical information electronically stored in an internet database can be many things. One of the major benefits would be if something happened to you or a loved one and the ambulance needs to pick them up, they can have access to your information. This can in turn help save your life. The information is already in the database in the event that you do not remember or cannot speak at the moment. In the event that you go to a hospital where your regular doctors are not around, they can access your information. This helps so you do not receive the wrong medication which can lead to serious injuries or even death. Having…

    • 285 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Another advantage of the relational database management system is the ability to reference data across fields. This allows the user to have one database that contains a variety of data all comprised in one system. It’s kind of like having you cake and eating it too. When the database is developed various data is input. As the tables form data is processed into information upon query from the user. This allows the organization to have their data in one place. This also creates a more efficient way to process data. Since the data lies in the database and is referenced based upon relational values, you are provided with more consistent information, in comparison to the flat file system. The flat file system has no relational value. A flat file database is a database that stores data in a plain text file. Each…

    • 864 Words
    • 4 Pages
    Better Essays
  • Powerful Essays

    Having this type of a software implemented into a health care organization also lets providers communicate better with other medical providers in other health care organization. I think one aspect that makes this type of a modality in regards to a patient’s confidentiality. By having this type of a software equipment any health care facility will lead to major health care savings, reduce medical errors, and improve health. A patients privacy been kept where no one can have or obtain any access makes it a very important part of any health care facility. Health care facilities or organization strives to keep all of their patients’ medical or health records more secure and confidentially; so that only those authorized to view or look at them at all times. To me, this makes having an electronic medical records system very much a valuable…

    • 1078 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    I could report data in many ways for example it can be shown in a spread sheet, bar chart, list etc. When delivering the data to other members of staff it can be done verbally or I could sit down with them and tell them in a meeting or it can be sent via email. I do this in my work when I send a mailing list to the director of the company of all the mail that has been received that day via email.…

    • 267 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Doctor

    • 2483 Words
    • 9 Pages

    Once you understand the benefits associated with a relational database you decide to build a small database to help you track and analyze…

    • 2483 Words
    • 9 Pages
    Satisfactory Essays