Preview

Database Concepts

Powerful Essays
Open Document
Open Document
1636 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Database Concepts
Database Concepts, 4e (Kroenke)
Chapter 1 Getting Started

1) The purpose of a database is to help people keep track of things.
Answer: TRUE
Diff: 1 Page Ref: 4

2) A possible problem with keeping data in lists is that if you delete a row of data from a list you may also delete some data items that you want to keep.
Answer: TRUE
Diff: 1 Page Ref: 4

3) An advantage of keeping data in lists is that if you update a data value in one row of data in a list, other occurrences of the same data item in other rows will be automatically updated as well.
Answer: FALSE
Diff: 1 Page Ref: 4

4) An advantage of keeping data in lists is that if you add a new row of data to the list you will never have null values occurring for any data item in the row.
Answer: FALSE
Diff: 1 Page Ref: 5

5) One problem with storing duplicated data is the potential for inconsistent values.
Answer: TRUE
Diff: 2 Page Ref: 4

6) A relational database stores data in the form of lists.
Answer: FALSE
Diff: 1 Page Ref: 6

7) Usually, a database table containing both rows and columns is designed to store data for exactly two themes.
Answer: FALSE
Diff: 2 Page Ref: 6

8) By separating data into tables containing data on only one theme each, making changes to the data is simplified.
Answer: TRUE
Diff: 2 Page Ref: 7

9) SQL stands for Structural Question Language.
Answer: FALSE
Diff: 1 Page Ref: 12

10) Relational database tables are commonly combined, queried, and processed using Structured Query Language (SQL).
Answer: TRUE
Diff: 1 Page Ref: 12

11) Although users use database systems, they are not considered part of a database system.
Answer: FALSE
Diff: 1 Page Ref: 13

12) A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS).
Answer: FALSE
Diff: 2 Page Ref: 13

13) A relational

You May Also Find These Documents Helpful

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

    Bis221 Mel Johnson

    • 765 Words
    • 3 Pages

    A database stores information for any given reason and can be tracked back for any needed purpose.…

    • 765 Words
    • 3 Pages
    Powerful Essays
  • Satisfactory Essays

    • Define database architecture. For the database systems in your workplace, identify which architecture they fall under.…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Storing information is essential for many reasons; these include ease of access and readability, the level of detail you are able to store, the choice to have various copies of the information in case of loss and ease of transfer.…

    • 630 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Week 1 Quiz

    • 1042 Words
    • 5 Pages

    Preferred stock is excluded from stockholders equity because it does not have full voting rights.…

    • 1042 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    A database is a computer mechanism for storing and retrieving data. It gives one true command of their data, enabling one to retrieve it, sort it, analyze it, summarize it, and report results in changes.…

    • 598 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    week 4 Discussion 1

    • 447 Words
    • 2 Pages

    Redundant data wastes disk space and creates maintenance problems. If data that exists in more than one place must be changed, the data must be changed in exactly the same way in all locations. A customer address change is much easier to implement if that data is stored only in the Customers table and nowhere else in the database. Another example is do not use multiple fields in a single table to store similar data. For example, to track an inventory item that may come from two possible sources, an inventory record may contain fields for Vendor Code 1 and Vendor Code 2.…

    • 447 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    The purpose and benefits of organising data so that it can be analysed as you will be turning this data into information. Data is commonly known as information which is lacking meaning, therefore it cannot be analysed easily, however information is much more meaningful. We can filter the data and use it as needed which saves time scrolling through lots of unnecessary data. The benefits of organising data are that is can be easier to read and to understand. It also makes it quicker to find the information you need from it.…

    • 1043 Words
    • 4 Pages
    Good Essays
  • Good Essays

    The purposes and benefits are so that it is easy to read, data is easy to find, and can be analysed more efficiently and effectively. The data can then be manipulated to fit our purpose of any request; this is then quicker to action any requests regarding the data.…

    • 502 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Dbm 381 Week 1paper

    • 885 Words
    • 4 Pages

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

    Cu700

    • 274 Words
    • 2 Pages

    Storing information is essential for many reasons; these include ease of access and readability, the level of detail you are able to store, the choice to have various copies of the information in case of loss and ease of transfer.…

    • 274 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Q3. Which one of the following is not a reason for exemption under data protection legislation?…

    • 507 Words
    • 3 Pages
    Satisfactory 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
  • Powerful Essays

    The purpose and benefit of organising data is that it allows you to see clearing what the data is that you have collected and what it relates to. It also allows you to identify any common traits within the data.…

    • 1276 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    2. Information becomes more accessible when using a databse. This is because databases allows you to view your data from a variety of different standpoints.…

    • 832 Words
    • 4 Pages
    Satisfactory Essays