Preview

Relational Database Analysis

Satisfactory Essays
Open Document
Open Document
557 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Relational Database Analysis
Lesson 1

What is a database: A database is a group of data that has been organised in a table or group. This makes it easy to find data, but also allows you to not have any duplicates in a group. A database is used in a school or college to store students date of births. This allows the school to be able to see how old the students are. The database can also be password protected to keep the data safe.

What is a flat file database: A flat database is where you have all your data in one table. This not good if you have two people with the same name as you can have a duplicate. Also, a flat database is long and tedious because say if you were a school and you were enrolling students, you have to write each person's name, date of birth, gender, and much more information. If two or more people have the same name then this is classed as a duplicate and can get very confusing. If you are enrolling 300 new students then a flat file is not the best option and you should use a relational database. …show more content…
This will allow you to different data so you do not have any duplicates so each piece of data is different. Schools, colleges, and theme parks could use a relational database so that they never have duplicates. Also, it makes inputting data a lot.

Overall a relational database is widely used in schools, organisations, companies, theme parks and the list never stops. I would recommend this type of database for anyone who has a lot of people attending or working at a place. This will stop duplicates. A flat file is not recommended as it takes a long time to enter the data and duplicates are most likely going to occur, which will lead to confusion and you will be unable to know who is who in the duplicate.

Lesson
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    Dbm 381 Week 1paper
    • 885 Words
    • 4 Pages

    Dbm 381 Week 1paper

    A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships between the entities (Pratt & Adamski, 2012, Chapter 1). How data is received, stored, processed, and made available to others has an effect on the success or failure of an organization. The use of different architecture is a most to fit the needs of the organization, however the value of the data still remains in been able to access and extract information from the database system, and the only way this can be reached is by organizing, storing, and analyzing it effectively. For many organizations these systems have become an essential part of their structural and operational success.…

    • 885 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    Assignment 1 Business Rules and Data Models
    • 906 Words
    • 3 Pages

    Assignment 1 Business Rules and Data Models

    A database is an integrated computer structure that stores end-user data and metadata (Coronel, Morris, & Rob, pg. 7). Data are the raw format of information, which when properly formatted can produce accurate, relevant, and timely information that is the key to making good decisions (Coronel, Morris, & Rob, pg. 5-6). The purpose of a database is to provide computer-based systems a way in which to store, manage, and retrieve data quickly (Coronel, Morris, & Rob, pg. 5). As for a local college database, the purpose of the database will be to house the data of enrolled students, the courses offered and times available, and the information of the faculty. The database can provide possible course matches for each student based off of previous courses taken and pre-requisites obtained, as well as keep track of the professors teaching each course. The database will provide the data a student needs to insure they are taking the correct courses and provide the college and the faculty general student information, such as contact information.…

    • 906 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    PT2520
    • 1600 Words
    • 14 Pages

    PT2520

    Chapter 1.2 Flat File Databases • The simplest electronic database structures are flat file structure. • Flat file means that the data is stored in a single file. • These files can be – Delimited – Fixed length –…

    • 1600 Words
    • 14 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Doctor
    • 2483 Words
    • 9 Pages

    Doctor

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

    Relational Databases
    • 750 Words
    • 3 Pages

    Relational Databases

    There are many ways to store and access data. One of these ways is using a data base. A database is an integrated collection of logically related data elements that are organized into a common pool of data elements (O 'Brien & Marakas, 2011). These elements are stored in such a way that they are not dependent on any one program or any piece of hardware. Thus allows data to be shared easily between programs.…

    • 750 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Relational Database
    • 632 Words
    • 3 Pages

    Relational Database

    Since the database will hold names and other information on family members attending the reunion, we need to decide on the model type of the database. Family reunion is rather straightforward event with not much complexity to the data, so it will be easier and much more efficient to use Relational Database Model.…

    • 632 Words
    • 3 Pages
    Good Essays
    Read More
  • Better Essays

    Benefits of a Database & Information Gathering Techniques
    • 1084 Words
    • 5 Pages

    Benefits of a Database & Information Gathering Techniques

    Databases are very important to every person in the world today. Whatever you do in you daily routine you are bound to come in contact with some form of database and our world has become so dependent on it that most people won’t even realize the importance of databases. A database is a bunch of files that are usually integrated electronically together to make up one big file. The database stores all of these files in one location and numerous people can access this information all at the same time if they have the proper access from the database administrator.…

    • 1084 Words
    • 5 Pages
    Better Essays
    Read More
  • Good Essays

    Describe methods of storing records and the benefits
    • 309 Words
    • 1 Page

    Describe methods of storing records and the benefits

    “Databases” are a very useful way of storing records, uses a database called Oracle ‘People System’. The database keeps individual records and what courses have run. It can be accessed by managers and the L&D team, we can produce quick reports. Once information have been entered into the system can always be found.…

    • 309 Words
    • 1 Page
    Good Essays
    Read More
  • Powerful Essays

    Basic Database Design Concepts
    • 2594 Words
    • 11 Pages

    Basic Database Design Concepts

    To end up with a good ‘relational database’ application, you need to ask: Do I actually need one? If so, how far do you want to take it? By this I mean, is this to be a simple database to store information about only one, or very few, related entities (i.e. a list of people who attended a certain event, and how they came to hear about the event) which are not likely to change; or a permanent and well used application with several different entities (i.e. Staff, Departments, Branches, SalesFigures for various periods/staff members/departments) which are constantly changing. If the forma is the case, a simple ‘Flat File’ database is all that is required. There are several basic database products on the market that will fully service this requirement but all that is needed is a table in MS Word for Windows or a basic Spreadsheet application, such as MS Excel. If the later is the case, then a Relational Database is needed. Although there are many products on the market, they have several common features and all use some form of SQL (Structured Query Language) to build, edit and query the database.…

    • 2594 Words
    • 11 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Database Administrators
    • 1626 Words
    • 7 Pages

    Database Administrators

    Database is any collection of data or information, that is specially organized for rapid search and retrieval by a computer. Databases are structured to facilitate the storage, retrieval, modification, and deletion of data in conjunction with various data-processing operations.…

    • 1626 Words
    • 7 Pages
    Powerful Essays
    Read More
  • Better Essays

    drama
    • 3922 Words
    • 12 Pages

    drama

    Although for the most part the spreadsheet serves its purpose, the information could be better stored in a database as databases have certain features that are valuable for storing this information that spreadsheets don’t have (e.g. An ID Key automatically assigned to each member which would be beneficial for sorting it).…

    • 3922 Words
    • 12 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    Nt1310 Unit 4 Student Information System
    • 590 Words
    • 3 Pages

    Nt1310 Unit 4 Student Information System

    Databases are used for record keeping and tracking of information institutions like colleges or organizations (Coronel & Morris, 2015). In this case, the database will be used to keep track of the students・attendance, performance and the courses they are supposed to be taking. This will help the college analyze how the students perform and which classes they least or most attend. The database will also help the college keep track of all the subjects which the student is taking or is expected to take in during the course. Instructors will also be part of the database. The database will track their performance in various subjects and their attendance in each class. The database will be upgraded at the beginning of every subject where each student will confirm their attendance for the particular subject and whether the instructor is in class as well. After an examination, all the students・performance will be…

    • 590 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Data and Communication
    • 1200 Words
    • 5 Pages

    Data and Communication

    Databases are great when you want to create a model of data such as numbers for figuring out how much you can spend on a new home when you are in the buying marketing, you can use excel to figure out how much you can spend and a monthly payment. You can also use a database to track of shipping components from a trade show that you are in charge of. You can use a database to organize the information about the components and equipment that will make a booth work and run properly at the trade show to.…

    • 1200 Words
    • 5 Pages
    Good Essays
    Read More
  • Good Essays

    programming basics
    • 2603 Words
    • 11 Pages

    programming basics

    keep track of students' transcripts. This is similar but not identical to the database shown in Figure 1.2:…

    • 2603 Words
    • 11 Pages
    Good Essays
    Read More
  • Powerful Essays

    Purpose Behind Pursuing Graduate Studies
    • 1468 Words
    • 6 Pages

    Purpose Behind Pursuing Graduate Studies

    I believe, though mature professional education can be obtained at undergraduate level, it can find its fullest expression only in the graduate years. I do not regard graduate study as a mere extension of undergraduate education or as an end in itself. I shall treat it as a stage to develop acumen under the careful guidance of an expert. By accoutering myself with knowledge of enduring value and by developing the ability to learn anew, I hope to carry out creative endeavor in future.…

    • 1468 Words
    • 6 Pages
    Powerful Essays
    Read More

Related Topics