Improve company productivity with a Business Account.Sign Up

x
?
Solved

ER-Diagram for auto industry

Posted on 2009-04-06
5
Medium Priority
?
2,168 Views
Last Modified: 2013-11-16
Dear experts:

I would like to get your always professional tips for drawing ER-Diagram for
auto industry.

Thanks a lot!
0
Comment
Question by:duta
  • 3
  • 2
5 Comments
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24083772
Do you have requirements from a domain expert, such as a customer in the auto industry. Is it a specific part of the industry? (Sales, repair, parts)

Without more info I can only recommend using a tool like Embarcadero ER/Studio or ERwin. I prefer the former.
0
 

Author Comment

by:duta
ID: 24083785
The SW provides a kind of a template?

Thanks a lot, Master!
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24083820
Well, it is a visual modelling tool. You create tables visually and draw the relationships, etc. It stores the "model" just like a Visio diagram, but you can use it to generate databases or SQL scripts, or to validate models, or even to reverse engineer an existing database into a visual model.

http://en.wikipedia.org/wiki/Entity-relationship_model

http://www.databaseanswers.com/modelling_tools.htm

A free one:

http://www.fabforce.net/dbdesigner4/index.php
0
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 2000 total points
ID: 24083825
As for templates, some do have "universal" model templates available, but I don't see one specifically for auto industry.

http://www.embarcadero.com/products/universal_data_models/index.php
0
 

Author Comment

by:duta
ID: 24083840
Thanks a lot, Master.

I will check the resource you kindly directed me at.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
During the weekend, I was asked to investigate into a deadlock in SQL Server 2014. SQL being something I don’t really fancy myself being an expert at, I had to do some refreshing. This article is a collection of my notes.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question