We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. Databases
  3. Database Normalization
  4. Database Normalization #10
  5. Discussions

Database Normalization #10

Sort by

recency

|

11 Discussions

|

  • slev1n_kelevrak1
     + 0 comments

    In these kinds of discussions, I always miss some specifics with examples. I would advise you to look in detail at ways to optimize the process of creating database visualizations, which saves a tremendous amount of time. To give you an example, https://www.erdlab.io offers a wide range of tools, with the ability to work in multiple tabs simultaneously, which is really very handy.

  • skyler_pr_freem1
     + 0 comments

    Stolen straight from Wikipedia! (or wherever Wikipedia's approximate pizza example comes from)

  • magnus_kraft
     + 0 comments

    What kind of info should be extracted from the db? If it should be possible to recreate the orders, no normalization is possible.

  • juliocesar_rzg
     + 0 comments

    The tables after normalization would be:

    Restaurant | Crust

    X Pizza                       |Thick   
X Pizza                       |Stuffed 
Papa Pizza                |Thin    
Papa Pizza                |Stuffed 
F1 Pizza                     |Thick   
F1 Pizza                     |Thin

    Restaurant | Delivery Area

    X Pizza                         |Whitefield
X Pizza                         |Greenville
X Pizza                         |Capital
Papa Pizza                  |Capital
F1 Pizza                       |Whitefield
F1 Pizza                       |Greenville

    So the answer is 6

  • neda_z00
     + 0 comments

    I dont get it!