• 0

Data normalization many-to-many relationship

Asked by MyNick,

 Share

Question

Neowinian

MyNick

Posted
Posted

I have three tables:

 

Product(carrots, potatoes)

id name

 

Element(calcium, sodium)

id name content100(content in 100 grams of product)

0 calcium 20 milligrams

 

product_element

id product_id element_id

 

I cannot understand to which table the data on "Content in 100 grams of product" belongs
The product does not apply to the item either.

 

Any help please.

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing

  • Posts

    • No more catfishing? Tinder is now requiring facial recognition in this US state

      By Liberi_Fatali · Posted

      Well... that's one way to voice your insecurities I guess.
    • PROJECT HAIL MARY

      By LittleNeutrino · Posted

      Im not sure how I feel about most of the trailing being about earth stuff, when none of the book takes place there, but the Rocky bits look cool!, I've been excited for this, and honestly surprised that Artimes never got a movie.
    • Here are all the new features Microsoft added to Teams in June 2025

      By Usama Jawad96 · Posted

      Here are all the new features Microsoft added to Teams in June 2025 by Usama Jawad Microsoft Teams is one of the most used software when it comes to online communication and collaboration, especially in enterprise environments. Even though there are still many features that people want in Teams, Microsoft tries to appease as many as it can with regular updates to the tool. Now, the Redmond tech firm has published a roundup of all the capabilities it added to Teams during the month of June 2025. Starting off with chat and collaboration improvements, we have an enhanced spellchecker offering support in up to three languages, with users being given the ability to add corrections to their personal dictionary too. In addition, the new chat and channels experience is now rolling out to Government Community Cloud (GCC) customers. Next, we have improvements to the meetings, webinars, and town halls experience. Loop-powered meeting notes are now available for GCC-High and Department of Defense (DoD) customers, and non-Teams users have the ability to join town hall meetings through Cloud Video Interoperability (CVI) join codes. It is also possible for those invited to join town halls and and webinars using sign-in details, such as PSTN. In a similar vein, town hall organizers can select individuals to manage the screen that is being shown to attendees. Organizers have more control over the broadcast of notifications too, and can also pull in a participant into the call directly and have them present their screen seamlessly. Lastly, town hall usage reports are now available in Teams Admin Center for additional insights. For those more interested on the hardware side of things, the following devices are now Teams-certified: Yealink MeetingBoard Pro MTRA Series-65, 75, and 86 inch Logitech 4K Pro Webcam (for consumer) Logitech Brio Ultra HD Pro Business Webcam (for business) Yealink RoomPanel E2 (8-inch) and E2 Plus (10 inch) Logitech Rally Board 65 + Tap IP for Teams Rooms on Android (wireless) Crestron Videobar 70 EPOS ADAPT 660 USB-C PolyStudio V12 Logitech Zone 305 (with native Bluetooth) That's not all, though. There are several other enhancements present across frontline worker solutions, security, and Teams Phone and Rooms. Read about them in detail here.
    • Here are the top 5 features people still want in Microsoft Teams

      By Mrwhatever85 · Posted

      not if the other person can see the nickname you are setting ?
    • Everyone seems powerless against Oracle's ownership of the JavaScript trademark

      By leonsk29 · Posted

      Sure, buddy, sure... let's compare the contents of the article to the stupid thumbnail, it's clearly the same thing and it has the same importance, of course.

  • Recent Achievements

    • Week One Done
      dennis Nebeker earned a badge
      Week One Done
    • One Year In
      timothytoots earned a badge
      One Year In
    • One Month Later
      CHUNWEI earned a badge
      One Month Later
    • Week One Done
      TIGOSS earned a badge
      Week One Done
    • First Post
      henryj earned a badge
      First Post

  • Popular Contributors

    1. 1
      +primortal
      466
    2. 2
      +FloatingFatMan
      194
    3. 3
      ATLien_0
      163
    4. 4
      Xenon
      78
    5. 5
      Som
      73
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!