Preview

Unit 18 Database Design Oliver Taylor Resubmission

Better Essays
Open Document
Open Document
3057 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Unit 18 Database Design Oliver Taylor Resubmission
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

  • Better Essays

    Microsoft Access Tutorial. (2005). Reports I: Show off your data. Retrieved on July 16, 2005 from http://office.microsoft.com/training/training.aspx?AssetID=RC010780631033.…

    • 2384 Words
    • 10 Pages
    Better Essays
  • Powerful Essays

    Dbm 380 Week 1

    • 1191 Words
    • 5 Pages

    Database environments are very important in today’s industries. In selecting an organization that will need a database, I choose Smith Consulting. Smith Consulting will need a database to track their consulting staff, each staff member’s skill sets, and what projects they will be working on. This document will provide information on the following area’s listed below:…

    • 1191 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Nt1310 Unit 1 Assignment

    • 533 Words
    • 3 Pages

    Database management tool is important to financial management students especially when it comes to financial statements. We are using different database to perform our job as a financial analyst or financial manager. It is easy for us to organize the data needed in our company that helps us be efficient.…

    • 533 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
  • Powerful Essays

    a guide to mysql ch 7

    • 1287 Words
    • 9 Pages

    Security of data, simplicity for removing extra information and the ability to better examine data.…

    • 1287 Words
    • 9 Pages
    Powerful 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

    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

    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
  • Good Essays

    These are basic steps towards securing the central database from attacks such as denial of service that is mainly caused by unauthorised access. The strategy is simple and less costly thus cannot cause strain on the budget.…

    • 349 Words
    • 2 Pages
    Good 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
  • Good Essays

    Dbm 381 Week 1paper

    • 885 Words
    • 4 Pages

    Database systems are the spinal cord of any health care organization. It can be define as the collection of health data. The use of such systems has improve the health care system for decades helping set standards and even regulations to help the system be more efficiently productive. There are different database architectures available to meet the needs of each organization individually. There is a need for the continuum of database across the health care system.…

    • 885 Words
    • 4 Pages
    Good 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

    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
  • Better Essays

    Healthcare database systems are critical in health care. Databases are used frequently in healthcare. There are different types of databases. This paper will define health care database systems and describe how databases are used across the health care industry. It will also explain the different database architectures including the relational architecture and describe the needs of database users across the health care continuum. A database is any collection of data organized for storage, accessibility, and retrieval. A healthcare database serves to replace the paper documents, file folders, and filing cabinets of old. This makes data more convenient and immediate.…

    • 754 Words
    • 4 Pages
    Better 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