Motel Information System

1
Motel Information System
2
JUGGERNAUT

• Ronda Russell Team Leader
• Kyle Davis Deputy Team Leader
• Werner Sauer - Designer
• Brad Dorman Programmer/Analyst
• Nick Muller - Intern

3
System Purpose

• To develop feasible accounting system to assist
  management in decision making
• Automation of daily tasks
• System will allow for minimization of costs
• System will reduce the number of inaccuracies in
  data records

4
Points of Interest

• Zachmans Framework
• Rows
• Scope/Planner
• Enterprise Model/Owner
• System Model/Designer
• Technology Model/Builder
• Components/Subcontractor
• Columns
• Data/What
• Function/How
• Network/Where

5
Data Needed for Planner

• What information does the planner need?
• Account classifications
• Requirements of system
• Current technology/capabilities
• Size of organization

6
Data Needed for Owner

• What information does the owner need?
• The Organizational Model of all business Entities
  and their business relationships
• What business entities are there and what are
  their relationships to each other?
• Maintenance
• Housekeeping
• Check In/Check Out

7
Data Needed for Designer

• What information does the designer need?
• Logical Data Model
• System Design Budget
• System requirements
• Normalized Entities
• Business Rules

8
System Design

• Motel Entities Examples

Make
Customer
Payments
Has
Employee
Sales
9
Data Needed for Builder

• What information does the builder need?
• Physical Data Model
• Storage space needed
• Number of users
• Implementation Budget
• Tables with PK and FK

10
ERD Sample
11
Data Needed for Subcontractor

• What information does the subcontractor need?
• Data Component Specifications
• Detailed description of the builders data design
• Time Constraints
• Available Resources
• Data Dictionary

12
System Design

• Data Definitions Examples
• Customer ? a person or company who buys goods or
  services
• CustomerID, LastName, FirstNameAddress, City, Stat
  e, PostalCode, Country, Phone
• Employee ? anyone that in the current motel
  payroll
• EmployeeID, LastName, FirstName, Title,
  DateOfBirth, DateOfHire, Address, City, State,
  RegionID, PostalCode, HomePhone, WorkPhone,
  ReportsTo

13
Data Dictionary Sample
14
Processes for the Planner

• List of all Business Processes that the motel
  will perform
• Examples
• Customer check-in
• Ordering inventory
• Staffing
• Scheduling
• Payroll

15
Processes for the Owner

• Standard procedures for processes performed at
  the motel
• Examples
• Housekeeping
• Check-in
• Room Service

16
Processes for the Designer

• Application Architecture
• HOW will the Application function?
• How does the application need to work for the
  front desk to check in a customer?
• How does the application record supplies being
  used?

17
Processes for the Builder

• How are the processes captured by the information
  system?
• Application Structure Chart
• Device formats
• Telephone
• Internet
• Credit Card Machine
• Paper documentation

18
Processes for the Subcontractor

• Physical programming of the system
• Program Components Specifications
• Which languages used and how they are connected
• Oracle backend
• AJAX website check in

19
Network Locations

• List of all business locations for the planner
• List of Locations of all motels
• List of Locations of all motel business offices
• List of Locations of suppliers

20
Network Locations

• Business Network Model
• Connections between each business entity
• Where are our suppliers located and which ones
  are closest to a given distribution point?

21
Distributed System Architecture

• System Network Model
• Logical model of the information system based on
  the logistics network
• Network backbone design
• T1? Phone lines? Cable?

22
Network Model
23
System Architecture

• Technology Network Model
• Hardware specifications
• Line specifications
• Software specifications
• Security Implementation
• Network protocols

24
Network Architecture

• Network Component Specifications
• Node addresses and documentation
• Specific protocols

25

• Questions?

26

• Thank You