Management Information Systems - Assignment 9

Management Information Systems - Assignment 9 - databases...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 5: Data Resource Management Discussion Questions: Pg. 202, #8 Q8. What are the benefits and limitations of the relational database model for business applications today? Within a relational database model, all data elements within the database are viewed as being stored in the form of simple two – dimensional tables, sometimes referred to as relations (O’brien & Marakas, 2009). The tables in a relational database are flat files that have rows and columns; each row represents a single record, and each column represents a field. A relational database can specify data attributes for multiple files simultaneously and can relate the various data elements in one file to those in one or more other files. The relational database model is the most widely used of all database structures and is used by most minicomputer, midrange and mainframe DBMS packages, for example Microsoft SQL and Oracle 10g. There are several benefits business applications gain from relational
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: databases. First, users are able to create ad hoc queries to create useful reports that help business decisions. Second, the data structures are logical, easily retrievable and modifiable. Third, relational database have excellent security; it supports access permissions based on users and user rights. This security allows database administrators to provide access to data on a need to know basis. Finally, relational databases perform well are easily scalable to meet the needs of the end user. One of the major limitations of relational databases is that it does not support several data types; for example pictures, sound, and video. Unlike object databases, relational databases only hold tables as unordered lists and can retrieve an ordered list only if a specially built index is added. Relational databases are not able to process large amounts of transactions quickly, thus posing a challenge to organizations that require quick, real time processing....
View Full Document

This note was uploaded on 07/16/2011 for the course IS 620 taught by Professor Dr.a during the Winter '11 term at Nova Southeastern University.

Page1 / 2

Management Information Systems - Assignment 9 - databases...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online