Fundamentals Of Information Systems
Media A. Ibrahim
MSc: Software Engineering
ISE Department
[email protected]
2019-2020
1
Data Management and modeling.
-Key aspects of organizing data and
information
2
Outlines
• The Hierarchy of Data
• Database.
• Data Model.
• Database Management System.
3
The Hierarchy of Data
Database
A character can be an
A bit (a binary digit) A byte Bits can be uppercase letter (A, B, C…
Z), lowercase letter(a, b, c…
the smallest piece of organized into units
z), numeric digit (0, 1, 2… 9),
data A byte=8bits or special symbol (., !, +, -, /,
…)
A field is typically a name, A record a collection of data
number, or combination
A file(Table) is a
fields all related to one object, collection of related records.
of characters that describes an activity, or Individual. E.g.
aspect of a business object E.g.
employee record=employee’s
(such as an employee, a an employee file is a
name, another field contains the
location, or a truck) or activity address, and still others the collection of all company
(such as a sale) phone number. employee records
4
The Hierarchy of Data (Continued)
The Hierarchy 5
of Data
Database
Database: collection of interrelated information about
world being modeled.
6
Database Types
Flat File: A flat file is a simple database program whose records have no relationship to
one another. Flat file databases are often used to store and manipulate a single table or
file; they do not use any of the database models discussed previously, such as the
relational model. Many spreadsheet and word-processing programs have flat file
capabilities.
Single User: A database installed on a personal computer is typically meant for a single
user. Microsoft Office Access and FileMaker Pro are designed to support single-user
implementations.
Multiple Users: Small, midsize, and large businesses need multiuser DBMSs to share
information throughout the organization over a network. These more powerful,
expensive systems allow dozens or hundreds of people to access the same database
system at the same time. Popular vendors for multiuser database systems include Oracle,
Microsoft, Sybase, and IBM.
7
The Database Approach
Traditional
approach to data management. Database approach to data
At one time, information systems management (DBMS)
Whereby multiple information systems share a
referenced specific files pool of related data. A database offers the
containing relevant data. E.g. ability to share data and information resources.
a payroll system would use a Federal databases, for example, often include
payroll file. Each distinct the results of DNA tests as an attribute for
operational system used data convicted criminals. The information can be
shared with law enforcement officials around
files dedicated to that system. the country.
8
The Database Approach (Continued)
The Traditional Approach To Data Management
9
The Database Approach (Continued)
The Database Approach to Data Management
10
The Database Approach to Data Management Advantages
11
The Database Approach to Data Management Advantages
(Continued)
12
The Database Approach to Data Management Disadvantages
13
Data Modeling
A data model is a representation of reality.
It’s used to define the storage and manipulation of a data base.
Planned data redundancy
To have it available in more than one place
To improve system performance
Data model
A diagram of entities and their relationships
Entity-relationship diagrams
Use graphs to show how data is organized and how it is related
Goal: to create database tables that do not contain duplicate data values
that can become inconsistent
14
Database Models
Hierarchical (tree)
Data is organized top-down
Network
Owner-membership relationship
A member can have many owners
Relational
Uses tabular format with 2-dimensional tables (relations)
Relations resemble files
15
Hierarchical Database Model Example
Hierarchical Database
Model
16
Network Database Model Example
Network Database Model
17
Relational Models
Describe data using a standard tabular format with all data elements placed in two-
dimensional tables, called relations, that are the logical equivalent of files.
Rows represent data entity (Employee, Customer)
Columns represent attributes (Employee’s First Name or Last Name)
Popular Database Management Systems
IBM DB2, Oracle, Sybase, Microsoft
SQL Server, Microsoft Access, and MySQL
18
Relational Models (Continued)
Domain: Set of values an attribute can have
Age: Between 0-100
Gender: Male or female
Selecting
Pick rows based on certain criteria
Select those whose gender is female
Projecting
Create a new table with a subset of attributes
Joining
Combine two or more tables
19
Relational Database Model Example
Relational Database Model 20
Entity/Relationship Modelling
• Graphical representation of entities and their relationships
in a database structure.
• Entity= Object, Concept or event (subject)
• Table = Entity = Relation
• Table row = tuple = instance=Record
• Table column = attribute
21
E-R Diagram Notation
22
Entity/Relationship Modelling (cont.)
• E/R Models are often Lecturer ID
represented as E/R Name Course
diagrams that
– Give a conceptual view
Tutors Student
of the database
– Are independent of the
choice of DBMS
– Can identify some Module Studies
problems in a design
23
Entities
• Entities represent objects or things of interest
– Physical things like students, lecturers, employees,
products
– More abstract things like modules, orders, courses,
projects
– Entity types do not have key attribute of their own are
called weak entity types
24
Diagramming Entities
• In an E/R Diagram, an Lecturer ID
entity is usually drawn as Name Course
a box with rounded
corners
Tutors Student
• The box is labelled with
the name of the class of
objects represented by that
entity Module Studies
25
Attributes
• Attributes are facts, • Attributes have
aspects, properties, or – A name
details about an entity – An associated entity
– Students have IDs, – Domains of possible
names, courses, values
addresses, …
– Values from the
– Modules have codes, domain for each
titles, credit weights, instance of the entity
levels, … they are belong to
26
Diagramming Attributes
• In an E/R Diagram Lecturer ID
attributes may be drawn as Name Course
ovals
• Each attribute is linked to
Tutors Student
its entity by a line
• The name of the attribute
is written in the oval
Module Studies
27
Relationships
• Relationships are an • Relationships have
association between two – A name
or more entities – A set of entities that
– Each Student takes participate in them
several Modules – A degree - the number
– Each Module is taught of entities that
by a Lecturer participate (most have
– Each Employee works degree 2)
for a single Department – A cardinality ratio
28
Cardinality Ratios
• Each entity in a • One to one (1:1)
– Each lecturer has a unique
relationship can office
participate in zero, one, or
• One to many (1:M)
more than one instances of – A lecturer may tutor many
that relationship students, but each student
• This leads to 3 types of has just one tutor
relationship… • Many to many (M:M)
– Each student takes several
modules, and each module
is taken by several students
29
Diagramming Relationships
• Relationships are links Lecturer ID
between two entities Name Course
• The name is given in a
diamond box
Tutors Student
• The ends of the link show
cardinality
Module Studies
One Many
30
Making E/R Models
• To make an E/R model • General guidelines
you need to identify – Since entities are
– Entities things or objects they
– Attributes are often nouns in the
– Relationships description
– Cardinality ratios – Attributes are facts or
properties, and so are
• from a description often nouns also
– Verbs often describe
relationships between
entities
31
Database Keys
• A key of a relation is a subset of attributes with the
following attributes:
• Unique identification
• Non-redundancy
• Primary Key - Indicates uniqueness within records or rows
in a table.
• Foreign Key - the primary key from another table, this is
the only way join relationships can be established.
32
Database Keys Example
33
Example - E/R Diagram
An Entity-Relationship
(ER)Diagram for Department Database
Offers Department Employs
Course Includes Module Teaches Lecturer
Takes
Enrols In Student Tutors
Name
ID Course 34
Data Entities, Attributes, and Relationships Example
eBay assigns an “Item number” as a
primary key to keep track of each
item in its database
35
Database Management System
A database management system, or simply DBMS, is a
set of software tools that control access, organize, store,
manage, retrieve and maintain data in a database.
36
Creating and Modifying the Database (User View)
Schema: using a large database involves “telling” the DBMS the logical
and physical structure of the data and the relationships among the data for
each user. such as Oracle, typically use schemas to define the tables and
other database features associated with a person or user.
Data definition language (DDL): is a collection of instructions and
commands used to define and describe data and relationships in a specific
database. A DDL allows the database’s creator to describe the data and
relationships that are to be contained in the schema.
Data dictionary: a detailed description of all data used in the database.
37
Creating and Modifying the Database (User View)
Using a Data Definition Typical Data Dictionary Entry
Language to Define a Schema
38
Storing and Retrieving Data
One function of a DBMS is to be an
interface between an application
program and the database. When an
application program needs data, it
requests the data through the DBMS.
o For example, a user might give a
command, such as LIST ALL
OPTIONS FOR WHICH PRICE IS
GREATER THAN 200 DOLLARS.
This is the logical access path (LAP).
Then, the DBMS might go to the
options price section of a disk to get
the information for the user. This is
the physical access path (PAP). Logical and Physical Access Paths
39
Manipulating Data and Generating Reports
Query by Example (QBE): which is a visual approach to developing
database queries or requests. Like Windows and other GUI operating systems,
you can perform queries.
Programming language(C++ commands): can be used in simple programs
that will access or manipulate certain pieces of data in the database.
Structured Query Language (SQL): standardized data manipulation
language(query). SQL has many built-in functions, such as average (AVG),
the largest value (MAX), the smallest value (MIN),and others.
Examples of SQL Commands
40
Manipulating Data and Generating Reports (Continued)
Some of The Most Important SQL Commands:
•SELECT - extracts data from a database
•UPDATE - updates data in a database
•DELETE - deletes data from a database
•INSERT INTO - inserts new data into a database
•CREATE DATABASE - creates a new database
•ALTER DATABASE - modifies a database
•CREATE TABLE - creates a new table
•ALTER TABLE - modifies a table
•DROP TABLE - deletes a table
•CREATE INDEX - creates an index (search key)
•DROP INDEX - deletes an index
41
Manipulating Data and Generating Reports (Continued)
After a database has been
set up and loaded with data,
it can produce desired
reports, documents, and
other outputs.
Examples of SQL Output
42
Database Administration
Role of the database administrator (DBA) is to plan, design, create, operate,
secure, monitor and maintain databases
The DBA works with both users and programmers
A data administrator is responsible for defining and implementing consistent
principles for a variety of data issues, including setting data standards and
data definitions; a nontechnical position.
43
Conclusion
• A database is a computerized system that makes it easy to
search, select and store information.
44
