If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Database Design

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-05-09, 14:52
triathlon_20 triathlon_20 is offline
Registered User
 
Join Date: May 2009
Posts: 4
Question Database Design

I have designed a database for transport insurance company that will later be used as my back end for my proposed system.It's in Access however I want to know more about MySql but I don't have time to do it. Hopefully you can send me links or tutorial perhaps about this matter. Please see the attach document for you reference. I'm open for any comments,suggestion,and interrogation. This is my final requirement to pass my Software Engineering subject.
Attached Files
File Type: doc database deign.doc (141.5 KB, 70 views)
Reply With Quote
  #2 (permalink)  
Old 05-05-09, 16:54
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
If it is in Access, you would have an easier time upgrading it to SQL Server Express than MySQL.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #3 (permalink)  
Old 05-08-09, 03:33
triathlon_20 triathlon_20 is offline
Registered User
 
Join Date: May 2009
Posts: 4
Smile

Tnx,Is my design correct and normalize?Is it a good back end for my system?
Reply With Quote
  #4 (permalink)  
Old 05-08-09, 09:13
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
If the design suits your needs, that ought to be good enough. Without knowing more, we can't answer your questions. What exactly do you need the design to do?

-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Reply With Quote
  #5 (permalink)  
Old 05-10-09, 00:54
triathlon_20 triathlon_20 is offline
Registered User
 
Join Date: May 2009
Posts: 4
Post

Thanks, it is actually an information system for UNITRANS- an auto insurance company. Wherein a client can be an individual or business firm. The client will pay a premium for ECPTL and PPAI, these are 2 type of insurance that the client has to apply for. ECPTL covers the third party while the PPAI covers the on board. It has to be renewed every year. IS for me can be best applied to this firm especially that they dont have an existing system. They are still in manual.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On