Innovative Database Design for NOMO Auto Group

1
Innovative Database Design for NOMO Auto Group

• Riscan
• Tyler Byrd, Carol Holt, Kevin Lachaud, Matt
  Mazurkivich, Ray Musto, and Karen Wise

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

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

4
Database Tables Contd
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
5
Budget
One Time Costs Database and Server 46,564
Monthly Costs Internet 316
Annual Costs Salary 60,000
6
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 Components and Set-up
Connect Internet
Enter Data and Testing
Training
7
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

8
How Data Migration is Performed

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

9
End-users at NOMO Auto Group

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

10
Database Security

• User Name
• Password
• Access Controls
• User Roles
• User Permissions

11
Future Area and Development

• NOMO may want to expand their current system to
  meet future business needs.
• Limited Online Customers Database
• Contain images of vehicles
• The employees database is linked with the
  customers limited database on the website.

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

13
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 Groups
  program uses Microsoft Access as a base software
  product and is bound by its legal disclaimers.