1 / 17

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.

cecilia-silva
Download Presentation

NOMO Motors Database Design Proposal

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. NOMO Motors DatabaseDesign Proposal • Initech Design • Jimmy Brown • Zonghan Cheng • Nick Johnson • Jeff Jones • Jamesha Robinson

  2. Contents • Executive Summary • Project Overview • Scope of Work • Business Impact • Database Lifecycle • Database Design • Database Implementation

  3. Executive SummaryInitech Design – 4th Quarter 2009

  4. Marketing Plans/Strategy • Most user friendly system • Best customer satisfaction • Our target market

  5. Operations and Structure

  6. Current Business • This quarter we signed a contract with NOMO Auto Groups to design an efficient database.

  7. Project OverviewNOMO Motors

  8. 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.

  9. 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

  10. Business Impact • Training new / old employees • Teach them the new database • Makes tracking easier for employees

  11. Database LifecycleNOMO Motors

  12. Progress to DateInitech 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

  13. Database DesignNOMO Motors

  14. Conceptual Model • Entities • Inventory • Sales Force • Sales Report • Dealerships • Customers • Invoices • Business Rules • Employees work at dealerships, many-to-many • Employees sell inventory, one-to-one • Inventory stored at dealerships, many-to-one • Inventory sales recorded in sales reports, one-to-one • Managers run dealerships, many-to-one

  15. E-R Diagram

  16. 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/

  17. 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

More Related