Innovative Database Design

for NOMO Auto Group

RiscanRiscanTyler Byrd, Carol Holt, Kevin Lachaud, Matt Mazurkivich, Ray Musto, and Karen Wise

ER-Diagram

An E-R Diagram is a representation of structured data.

We used an E-R diagram to map out the relationships that would exist in the database.

Database Tables

Our database design includes 6 tables.

5 Main tables and 1 Linking table. There is a table for employees,

automobiles, NOMO Dealerships, External Costs, and Sales.

Linking table that contains the primary key of the other tables as a foreign key.

Database Tables Cont’d

Employee Automobile NOMO External Sales Employee_Sales_Location

Employee ID

VIN Location ID Dealer/Supplier ID

Sale No. Employee ID

First Name Make Address Name Date Sold

Location ID

Middle Initial Model Fax Address Client Name

VIN

Last Name Year Telephone Number

Phone Number Client Address

Sale No.

Job Title Color Email Email Client Phone

Dealer/Supplier ID

Home Address

List Price Fax Sale Price

Home Telephone

Commision

Budget

One –Time Costs: Database and Server

$46,564

Monthly Costs: Internet $316

Annual Costs: Salary $60,000

Timeline

Nov 1 - 5

Nov 5 -9

Nov 12 - 16

Nov 19 - 23

Nov 26 - 30

Dec 3 - 7

Dec 10- 14

Dec 17-20

Acquire Componentsand Set-up

Connect Internet

Enter Data and Testing

Training

What is Data Migration

The process of translating data from one format to another.

The process of moving data from one storage device to another

How Data Migration is Performed

Analyze and define source structure Analyze and define target structure Perform field mapping Define the migration process

End-users at NOMO Auto Group

CEO Manger of Sales Senior Salesperson Salesperson Human Resources Director Administrative Assistant

Database Security

User Name Password Access Controls User Roles User Permissions

Future Area and Development

NOMO may want to expand their current system to meet future business needs.

Limited Online Customer’s Database Contain images of vehicles The employees’ database is linked with

the customer’s limited database on the website.

Future Area and Development

If acquire new dealerships, the system will be able to handle the additional business.

Nomo have to make some revision. Purchase additional software Increase the number of servers Train new employees Hire additional database administrator.

Legal and Ethnical Issues

Provide a safe and healthful workplace and ensure that personnel are properly trained and have appropriate safety and emergency equipment.

Meet or exceed all applicable government requirements.

Legal Disclaimer In no event shall NOMO Auto Group, Inc. and/or its respective

suppliers be liable for any special, indirect or consequential damages or any damages whatsoever resulting from loss of use, data or profits, whether in an action of contract, negligence or other tortuous action, arising out of or in connection with the use or performance of software, documents, provision of or failure to provide services, or information available from the services. NOMO Auto Group’s program uses Microsoft Access as a base software product and is bound by its legal disclaimers.