Transcript NOMO Motors Database Design Proposal

NOMO Motors Database
Design Proposal
Initech Design
Jimmy Brown
Zonghan Cheng
Nick Johnson
Jeff Jones
Jamesha Robinson
Contents
Executive Summary
Project Overview
Scope of Work
Business Impact
Database Lifecycle
Database Design
Database Implementation
Executive Summary
Initech Design – 4th Quarter 2009
Marketing Plans/Strategy
Most user friendly system
Best customer satisfaction
Our target market
Operations and Structure
Current Business
This quarter we signed
a contract with NOMO
Auto Groups to design
an efficient database.
Project Overview
NOMO Motors
NOMO Auto Group
Problem
Unable to update on real-time.
Redundant Data Stored as Private Files not updated
to Company Data Base.
Data cannot be accessed at same time.
Use human eye to search single data on the spread
sheet.
Cannot track selling information and inventory
information.
Scope of Work
NOMO MOTORS is in
need to move to a
higher level Database
Management System
Can sometimes loss
data and give back
inaccurate sale details
to our dealers
Business Impact
Training new / old
employees
Teach them the new
database
Makes tracking easier
for employees
Database Lifecycle
NOMO Motors
Progress to Date
Initech Design – 4th Quarter 2009
Initial Study – Analyzed NOMO’s existing data
Database Design – Implemented in to MySQL on PHP MyAdmin
Implementation – Adobe Dreamweaver CS4
GUI - Samples developed and modified, implemented with CSS
Operation – hosted on PSU Webspace
Maintenance and evaluation – ongoing
Database Design
NOMO Motors
Conceptual Model
Entities
Inventory
Business Rules
Sales Force
Employees work at dealerships, many-to-many
Sales Report
Employees sell inventory, one-to-one
Dealerships
Inventory stored at dealerships, many-to-one
Customers
Inventory sales recorded in sales reports, one-to-one
Invoices
Managers run dealerships, many-to-one
E-R Diagram
Database Implementation
•
DBMS - PHP MyAdmin
•
Logical Database Design – simple once implemented
•
Coding – used Dreamweaver CS4
•
Testing and Validation – ongoing
•
URL: php.scripts.psu.edu/njj5014/NOMO/
Data Access and Security
Full Access
General Managers
Operations Managers
Restricted Access
Employees and Customers
Only able to access and edit pertinent information
Method
User ID and password required to access web site
Users have access level
Created through site