Managing the Information
IS Projects are notorious for missing time deadlines
often by months or years.
IS Projects are also notorious for going over-budget
often by over 100%.
The Enhanced ER Model and
Enhanced E-R Model
E-R model that has been extended
to include supertype/subtype
relationships and business rules
Supertypes and Subtypes
Subtype: A subgrouping of the entities in an entity type
Logical Database Design &
the Relational Model
4 Steps in Logical Design Process
Model (E-R Diagram)
Normalize the Relation
Merge the Relation
Logical Data Model
4 Steps in Logical D
Modeling Data in the Organization
Entity Relationship (E-R) Model
logical representation o
General SELECT statement:
Specifies columns to retrieve
Specifies table to retrieve from
Specifies conditions for the quer
THE COMPANY EXAMPLE
We will describe an example database application, called COMPANY. It keeps track of
companys employees, departments and projects. We will first draw ER model for
COMPANY database. Then we will implement it on ACCESS and write some SQL
OPIM 302 Management Information Systems
Sample Midterm Exam
NOTE: The Midterm exam format will be similar to the sample exam. However, there will
be more questions in the midterm exam.
PART 1 (? Points, each question is ? poin
In Class Exercise 1
1. Explain the difference between data and information by giving an example.
2. What is the purpose(s) of using IS in business?
3. Give an example of an IS application, indicate the functionality and organizational
level of the system.
number of WS
Rental Car System
Design an information system, which will facilitate the functioning of a "typical"
Rental Car System.
Assume you carry cars of several "Types" such as economy,
mid-size, luxury, van, SUV, pickup etc.
Each type of car should have a differ
HR Hiring System
Starting with a context diagram, draw as many nested DFDs as you consider necessary
to represent all the details of the employee hiring system described in the following
narrative. You must draw at least a context and a level-0 diagram. I
El ganso de mis sueos
Cierto da, mientras paseaba a mi perro, fui golpeado en la cabeza por
una rama de considerable tamao. Esto no es realmente un hecho
misterioso o inslito, pero lo que aconteci a continuacin s.
Inconsciente, so como un dragn alado me e