Database and IS Development
CASE STUDY: SOFTWARE PROJECT MANAGER CLASS
Project Name : Web-based Information and Seat Reservation System called BREEZE
Stages
Database Planning
System Definition
Analysis
Requirement collection and
Analysis
Main Activities
enterprise modeling and early
conceptual data modeling
Mission(s)
Purpose(s)
Specifying the scope and
boundaries of the database
applications,
Users
Application area
Thorough and integrated
conceptual data modeling
Notes: Identify here propose
entities
Example:
Passenger
Train
Schedule
Seat
Output
Logical Design
Database Design
Application Design
Conceptual design of the
database
Logical design of the
database
Notes:
Here specify the details of
identified entities including the
attributes that will comprises
the entity / relationships /
degree of cardinality
Physical design of the
database
Notes:
Specify here the DBMS software
you intend to use and the
hardware specification including
the network connectivity you
intend to use
Designing the user interface
transactions
forms
Displays / Reports