Notesale: Turn your study into money

Document Preview

Extracts from the notes are below, to see the PDF you'll receive please use the links above

---

12/9/2017

11e

Database Systems
Design, Implementation, and Management

Coronel | Morris

Chapter 1
Database Systems
©2015 Cengage Learning
...
May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part
...
Get your smartphone / laptop
2
...
socrative
...
Click “Student Login”

4
...
Write your name and you are all set! Answer all questions
individually
...
Information
Data

Information

• Raw facts

 Produced by processing data

• Raw data - Not yet been
processed to reveal the
meaning
• Building blocks of information
• Data management

 Reveals the meaning of data
 Enables knowledge creation
 Should be accurate, relevant, and
timely to enable good decision
making

• Generation, storage, and
retrieval of data

http://www
...
info/difference-between-data-and-information
4

2

12/9/2017

Data vs
...
)

Refer to Fig 1
...
6
...
Information (cont
...
linkedin
...
bbc
...
uk/education/guides/zb2hgk7/revision

8

4

12/9/2017

Introducing the Database (cont…)
Role of the DBMS
• Intermediary between the user and the database
• Enables data to be shared
• Presents the end user with an integrated view of the
data
• Receives and translates application requests into
operations required to fulfil the requests
• Hides database’s internal complexity from the
application programs and users
9

Introducing the Database (cont…)
Role of the DBMS

Figure 1
...
g: CompuStat, GIS, medical

15

Types of Databases (cont…)

Data
usage

• Operational database: Designed to
support a company’s day-to-day
operations
• Analytical database: Stores historical data
and business metrics used exclusively for
tactical or strategic decision making
• Data warehouse: Stores data in a
format optimized for decision support
• Online analytical processing (OLAP) :
Enable retrieving, processing, and
modeling data from the data warehouse

Business
intelligence :
Captures and
processes business
data to generate
information that
support decision
making
16

8

12/9/2017

Types of Databases (cont…)

Structured
data
degree

• Unstructured data: It exists in
their original state
• Structured data: It results from
formatting
• Structure is applied based on type of
processing to be performed

Extensible Markup
Language (XML)
Represents data
elements in textual
format

• Semi-structured data: Processed
to some extent

17

Types of Databases (cont…)
• Social media – web and mobile technologies that
enable “anywhere, anytime, always on” human
interaction
...
6 - A Simple File System
24

12

12/9/2017

Evolution of File System Data Processing (cont…)
Computerized File Systems

Table 1
...
20):
• Update anomalies- eg: Update Leah HP no
• Insertion anomalies - how to add new agent without customer?
• Deletion anomalies - eg: to delete customer, also delete agent
...
8 - Contrasting Database and File Systems
34

17

12/9/2017

Database Systems (cont…)
The database system is composed of five major parts : hardware,
software, people, procedures and data

Figure 1
...
3 - Database Career Opportunities
40

20



---