Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2016
    Posts
    15

    Unhappy among these designs which design is best and why

    Hi Experts,
    Am sure this sounds easy for You and hope I get some help. Am new to SQL and learning concepts from basic ER diagrams and design of database.
    For my practice I considered, simple concept and thought of designing database for my own requirement.

    Example: Assume I have only three columns in one table like in excel.
    Click image for larger version. 

Name:	Table.JPG 
Views:	4 
Size:	20.1 KB 
ID:	16814

    a. Each LOB will have many issues
    b. Each issue will have many solutions

    FYI: also each LOB will have same Issues repeated but Solution varies

    Now I have designed 2 models:
    1. Click image for larger version. 

Name:	Design1.JPG 
Views:	6 
Size:	43.8 KB 
ID:	16815

    and
    2. Click image for larger version. 

Name:	Design2.JPG 
Views:	4 
Size:	34.2 KB 
ID:	16816

    I would like to know which design is better and also would like to know if there's any other approach to achieve this.

    Also any shortcuts on how to design database model?

    Thanks,
    Richa

  2. #2
    Join Date
    Feb 2016
    Posts
    15
    Hi Moderator,

    Can You pls move this topic to "database design & concepts".
    Last edited by Richavalues; 03-21-16 at 09:22.

  3. #3
    Join Date
    May 2016
    Posts
    89
    Hi Richavalues

    For modeling correctly a db (See example on this dbforums post
    here),


    1. build a conceptual data model (CDM). The Logical data model is very simple then to generate. With tools, the LDM is automatically built as well as the SQL script for creating the DB
    2. Use dedicated tools which build CDM not only LDM like :
      1. Power*AMC (excellent but expensive)
      2. JMERISE, excellent freeware here




    And of course apply at least the 3 first Normal forms (NF).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •