Learn to Create and Work with Relational Databases

By Werfel, Erik | Information Management, November-December 2015 | Go to article overview

Learn to Create and Work with Relational Databases


Werfel, Erik, Information Management


[ILLUSTRATION OMITTED]

Database Systems Design, Implementation and Management, 11th Ed. is an up-to-date, well-organized textbook that provides a comprehensive look at relational databases. It thoroughly covers entity relationship modeling, database modeling, normalization, and the development of useful database systems using structured query language (SQL), as well as relational database optimization, database administration, and security. From the basic to the complex, it is intended to get the reader to the point of creating and working with databases.

The book doesn't presuppose any familiarity with the material--it starts with the fundamentals--but some understanding of computer systems would be helpful to readers, particularly if they are reading it outside the context of a course. As a good reference for database concepts, it would be handy to keep it on the shelf for its practical glossary and as a refresher.

Contents

The book is divided into six parts:

1. Database Concepts provides an interesting history of data and database management systems.

2. Design Concepts covers data modeling and normalization.

3. Advanced Design and Implementation gets into detail about SQL.

4. Advanced Database Concepts focuses on performance tuning and optimization.

5. Databases and the Internet covers connectivity and web applications.

6. Database Administration focuses on administration and security.

Database Systems Design, Implementation and Management provides many practical SQL examples and is implementation agnostic. It covers SQL language variants specific to SQL Server, Oracle, MySQL, and even MS Access, providing SQL examples for each. The book also provides advice and cautions for specific database types.

The book also discusses business intelligence, data analytics, cloud-based systems and big data, and no-SQL systems, but these topics are not covered in the same detail as SQL and relational databases, which are at the core of this book. While it makes readers aware of these newer topics, they are a bit of an afterthought. Those who are not focused specifically on relational database management systems should look elsewhere.

Supplemental Materials

The publisher's website provides downloads of the sample databases discussed for several different systems, as well as free downloadable appendices. …

The rest of this article is only available to active members of Questia

Already a member? Log in now.

Notes for this article

Add a new note
If you are trying to select text to create highlights or citations, remember that you must now click or tap on the first word, and then click or tap on the last word.
One moment ...
Default project is now your active project.
Project items
Notes
Cite this article

Cited article

Style
Citations are available only to our active members.
Buy instant access to cite pages or passages in MLA 8, MLA 7, APA and Chicago citation styles.

(Einhorn, 1992, p. 25)

(Einhorn 25)

(Einhorn 25)

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Note: primary sources have slightly different requirements for citation. Please see these guidelines for more information.

Cited article

Learn to Create and Work with Relational Databases
Settings

Settings

Typeface
Text size Smaller Larger Reset View mode
Search within

Search within this article

Look up

Look up a word

  • Dictionary
  • Thesaurus
Please submit a word or phrase above.
Print this page

Print this page

Why can't I print more than one page at a time?

Help
Full screen
Items saved from this article
  • Highlights & Notes
  • Citations
Some of your highlights are legacy items.

Highlights saved before July 30, 2012 will not be displayed on their respective source pages.

You can easily re-create the highlights by opening the book page or article, selecting the text, and clicking “Highlight.”

matching results for page

    Questia reader help

    How to highlight and cite specific passages

    1. Click or tap the first word you want to select.
    2. Click or tap the last word you want to select, and you’ll see everything in between get selected.
    3. You’ll then get a menu of options like creating a highlight or a citation from that passage of text.

    OK, got it!

    Cited passage

    Style
    Citations are available only to our active members.
    Buy instant access to cite pages or passages in MLA 8, MLA 7, APA and Chicago citation styles.

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn, 1992, p. 25).

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn 25)

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn 25)

    "Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences."1

    1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

    Cited passage

    Thanks for trying Questia!

    Please continue trying out our research tools, but please note, full functionality is available only to our active members.

    Your work will be lost once you leave this Web page.

    Buy instant access to save your work.

    Already a member? Log in now.

    Search by... Author
    Show... All Results Primary Sources Peer-reviewed

    Oops!

    An unknown error has occurred. Please click the button below to reload the page. If the problem persists, please try again in a little while.