• 0

Data normalization many-to-many relationship


 Share

Question

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.

Link to comment
Share on other sites

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

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By News Staff
      Get this Complete 2021 SQL Master Class Bundle for only $19.99
      by Steven Parker



      Today's highlighted deal comes via our Online Courses section of the Neowin Deals store, where for only a limited time, you can save 98% off this Complete 2021 SQL Master Class Bundle. Start your data science journey with 7 courses and 23.5 hours of content on SQL — retrieve, analyze, manipulate data and more!

      This deal consists of the following courses:

      Introduction to Microsoft SQL Server & T-SQL
      This Novice Course Will Help You Handle, Securely Store & Quickly Access Databases SQL Server Training Course
      Facilitate a Robust Solution in Handling Higher Volume of Data & Understand Databases Better SQL 101: Writing Queries in the SQL Language
      Learn the Essential Fundamentals of Writing Meaningful SQL Queries to Process Raw Data Into Meaningful Information Learn SQL for Data Analysis
      Define Data with SQL, Connect Excel with GUI, Create Tables, & Load Data Learn the Fundamentals of MySQL Database Development
      MySQL Basics Plus Database Development Techniques with MySQL Server & MySQL Workbench Local SQLite Database with Node for Beginners
      Learn About NodeJS, From the Basics to Combining Fundamentals & Writing Code Master SQL Database Queries in Ninety Minutes
      Get Valuable Data Insights & Answers Anytime You Want from Your Raw Data Here's the deal:
      This Complete 2021 SQL Master Class Bundle normally costs* $1,393, but you can pick it up for just $19.99 for a limited time - that represents a saving of $1,373.01 (98%) off. For a full description, specs, and instructor info click the link below.

      Get the Complete 2021 SQL Master Class Bundle for $19.99
      97% off a lifetime of Encrypt Office Business Plan
      Supercharge Business Security & Compliance with Encrypted Email, Large File Transfer, AND 3-Factor Authenticated Vaults for File Storage & Upload

      Get Encrypt Office Business Plan (lifetime) for $59.99 (list price $2,158) 97% off

      Not for you?
      That's OK, there are other deals on offer you can check out here.

      Ivacy VPN - 5 years at 87% off NordVPN - 2 years at up to 68% off Private Internet Access VPN - subscriptions at up to 79% off Unlocator VPN or SmartDNS - unblock Geoblock with 7-day free trial Subscribe to Neowin - for $14 a year, or $28 a year for Ad-Free experience Giveaways: Apple Giveaway | Gaming Giveaway | Amazon Giveaway Neowin Deals · Free eBooks · Neowin Store

      Disclosure: This is a StackCommerce deal or giveaway in partnership with Neowin; an account at StackCommerce is required to participate in any deals or giveaways. For a full description of StackCommerce's privacy guidelines, go here. Neowin benefits from shared revenue of each sale made through our branded deals site, and it all goes toward the running costs.


    • By News Staff
      Save 98% off this 27 Course Premium Learn to Code Certification Bundle
      by Steven Parker



      Today's highlighted deal comes via our Online Courses section of the Neowin Deals store, where for only a limited time, you can save 98% off this Premium Learn to Code 2021 Certification Bundle. Amp up your programming skill set with 270+ hours of content on the leading coding languages — taught by top-rated instructors Ft. Rob Percival, Nick Walter, and more!

      This deal consists of the following courses:

      JavaScript Beginner Bootcamp
      Understand the JavaScript Language & Learn to Create and Launch Interactive Webpages SwiftUI Apps for All Apple Platforms
      Learn the True Magic of SwiftUI & Make Apps and Widgets for iPhone, Mac, iPad, Apple Watch, and AppleTV The Complete C# Programming Course
      Master C# & .NET Framework with Code Challenges, Exercises, & Real-Life Examples The Complete Web Developer Course 2.0
      Learn By Doing: Build 25 Websites & Mobile Apps Alongside Top-Rated Online Coding Instructor, Rob Percival! SwiftUI: The Complete Developer Course
      Learn Everything You Need to Know About the SwiftUI Framework & Leverage All of Its Great New Technologies 2020 Complete Ruby on Rails 6 Bootcamp
      Start From the Basics of Ruby on Rails & Go All the Way to Creating Your Own Applications Learn Python for Data Analysis & Visualization
      Gear Yourself with Necessary Skills for Expert-Proven Data Science Techniques Raspberry Pi Essentials & Extras
      Broaden Your Raspberry Pi's Horizons with This 1-Hour Crash Course PHP & MySQL: Certification Course for Beginners
      Learn to Build Database-Driven Web Applications Using PHP & MySQL Bootstrap & jQuery: Certification Course for Beginners
      Create Fully Animated, Interactive, Mobile Responsive Web Pages Using Bootstrap & jQuery Library HTML, CSS, & JavaScript: Certification Course for Beginners
      A Comprehensive Guide for Beginners Interested in Learning HTML, CSS, & JavaScript to Build Interactive Web Pages Java Foundations
      Master the General Purpose & Object-Oriented Language of Java to Enhance Your Skills for Mobile Development Making APIs with Django & Python
      Use the REST Framework to Quickly Make APIs for Your Django Projects Making Websites with Python & Django 3: The Ultimate Beginner's Guide
      Boot Up the Django 3 Web Framework Written In Python & Develop Websites Fast JavaScript Master Class
      A Comprehensive Course Just About Every Fact on JavaScript You Could Ever Hope to Know Python for Everyone
      Learn the Basic Syntax of How Python Language Works How to Get a Job as a Web Developer
      Tips, Tricks & Industry Secrets to Help You Land That Web Development Job The Python Mega Course: Build 10 Real World Applications
      A Complete Practical Python Course for Beginners & Intermediates! Master Python 3 by Building Actual Python Apps ROS2 For Beginners
      Master the Key ROS Concepts to Create Powerful & Scalable Robot Applications The Complete Web Developer Course: Build 20 Websites
      Learn the Fundamentals of HTML, CSS & JavaScript by Building 20 Real-World Websites Machine Learning for Absolute Beginners
      Learn to Build Machine Learning Models Using Spreadsheet Data Java Interview Questions: Data Structures & Algorithms
      The Best Java Interview Guide with the Most Common Beginner Questions Asked by FANG Companies

      The Ultimate Amazon Honeycode Guide: Build 7 Apps
      Build Apps to Automate Data Entry: Make Inventory Management Apps & More Easy Business Projects

      Learn Flutter & Dart: Complete App Development Projects
      Build Apps in Flutter, Google's Cross-Platform Framework & Code with Its Dart Programming Language

      Complete Data Science Training with Python for Data Analysis
      Learn Statistics, Visualization, Machine Learning & More

      C++ Programming for Beginners
      Master C++, An In-Demand, High-End Language Used for Programs, Games, Development Libraries, & More

      The Complete Front-End Web Development Course
      Take a Hands-on Approach to Learning Real Programming Skills

      Here's the deal:
      This Premium Learn to Code 2021 Certification Bundle normally costs* $4,056, but you can pick it up for just $59.99 for a limited time - that represents a saving of $3,996.01 (98%) off. For a full description, specs, and instructor info click the link below.

      Get the Premium Learn to Code 2021 Certification Bundle
      Not for you?
      That's OK, there are other deals on offer you can check out here.

      Ivacy VPN - 5 years at 87% off NordVPN - 2 years at up to 68% off Private Internet Access VPN - subscriptions at up to 79% off Unlocator VPN or SmartDNS - unblock Geoblock with 7-day free trial Neowin Store for our preferred partners. Subscribe to Neowin - for $14 a year, or $28 a year for Ad-Free experience Giveaways: Polycade Home Arcade | $5K in cash | $10K in Crypto | Gaming Bundle Neowin Deals · Free eBooks · Neowin Store

      Disclosure: This is a StackCommerce deal or giveaway in partnership with Neowin; an account at StackCommerce is required to participate in any deals or giveaways. For a full description of StackCommerce's privacy guidelines, go here. Neowin benefits from shared revenue of each sale made through our branded deals site, and it all goes toward the running costs.

    • By News Staff
      Save 97% off this Complete C Suite Programming Bundle
      by Steven Parker

      Today's highlighted deal comes via our Online Courses section of the Neowin Deals store, where you can save 97% off this Complete C Suite Programming Bundle. Master this foundational, general-purpose programming language with 80 hours of specially curated instructions on C++, C#, SQL, and more.



      This deal consists of the following courses:

      Complete Modern C++
      The Most Comprehensive C++ Tutorial with C++11/14/17 Features Master C# And SQL by Building Applications
      Become a Better Software Developer by Learning How to Build Applications Using C# & SQL Learn C# by Building Applications
      Understand the Concepts of C#6 & C#7 and Use Them to Build Real World .NET Console Apps The Complete Introduction to C++ Programming
      Learn All the Basics of C++ by Practice & Create Various Basic C++ Applications Structural Design Patterns in Modern C++
      Learn Structural Design Patterns in Depth & Their Implementation in Modern C++ Creational Design Patterns in Modern C++
      Learn Creational Design Patterns in Depth & Their Implementation in Modern C++ Object Oriented Analysis, Design & Programming with UML
      Learn Object-Oriented Analysis, Design & Programming Using UML in C++, Java and C# Detecting Memory Leaks in C/C++ Applications
      Apply Techniques to Detect & Isolate Memory-Related Errors in Visual Studio C/C++ Pointers & Applications
      Learn the Application of Pointers Such As Usage in Dynamic Arrays, Linked Lists, & More Beginner Object Oriented Programming In C# and .NET Core
      Learn Object-Oriented Programming Fundamentals & Climb Up the Developer Hierarchy Good to know
      Length of time users can access this course: lifetime Certificate of completion included Updates included Redemption deadline: redeem your code within 30 days of purchase For a full description, specs, and instructor info, click here.

      Here's the deal:
      This Complete C Suite Programming Bundle normally costs* $1,990, but you can pick it up for just $49.99 for a limited time - that represents a saving of $1,940.01 (97%) off.

      Get this deal, or learn more about it
      See all discounted Online Courses. This is a time-limited offer.
      Get $1 credit for every $25 spent · Give $10, Get $10 · 10% off for first-time buyers.

      Not for you?
      That's OK, there are other deals on offer you can check out here.



      Enter giveaways: Polycade Home Arcade | $5K in cash | $10K in Crypto Ivacy VPN - 5 year subscription for just $1 per month NordVPN - 2 year subscription at up to 68% off Private Internet Access VPN - subscriptions at up to 71% off Unlocator VPN or SmartDNS - unblock Geoblock with 7-day free trial Neowin Store for our preferred partners. Subscribe to Neowin - for $14 a year, or $28 a year for Ad-Free experience Disable Sponsored posts · Neowin Deals · Free eBooks · Neowin Store

      Disclosure: This is a StackCommerce deal or giveaway in partnership with Neowin; an account at StackCommerce is required to participate in any deals or giveaways. For a full description of StackCommerce's privacy guidelines, go here. Neowin benefits from shared revenue of each sale made through our branded deals site, and it all goes toward the running costs.

    • By News Staff
      Get this Backend Developer Bootcamp Bundle for only $29.99
      by Steven Parker

      Today's highlighted deal comes via our Online Courses section of the Neowin Deals store, where for only a limited time, you can save 96% off this Backend Developer Bootcamp Bundle. This 31-hour course bundle takes you behind the scenes of web development: C#, SQL, .NET Core, and more.



      This bundle includes the following courses:

      Learn C# By Building Applications
      Understand the Concepts of C#6 & C#7 and Use Them to Build Real World .NET Console Apps Master C# and SQL by Building Applications
      Learn How to Build Real-World Applications Using C# & SQL Beginner Object Oriented Programming in C# and .NET Core
      Learn Object-Oriented Programming Fundamentals & Climb Up the Developer Hierarchy Learn ASP.NET Core and SQL by Writing ToDo API
      Write an API with Step-by-Step Instructions Using ASP.NET Core, SQL Server, & T-SQL Microsoft SQL Server & T-SQL Course for Beginners
      Learn about the Benefits of SQL & How SQL Server Stores Data Good to know
      Length of time users can access this course: lifetime Certificate of completion included Redemption deadline: redeem your code within 30 days of purchase For a full description, specs, and instructor info, click here.

      Here's the deal:
      This Backend Developer Bootcamp Bundle normally costs $995, but you can pick it up for just $29.99 for a limited time - that represents a saving of $965.01 (96%) off.

      Get this deal, or learn more about it
      See all discounted Online Courses. This is a time-limited offer.
      Get $1 credit for every $25 spent · Give $10, Get $10 · 10% off for first-time buyers.

      Not for you?
      That's OK, there are other free eBooks on offer you can check out here.



      Home Gym Giveaway | Bitcoin (BTC) Investment Giveaway Ivacy VPN - 5 year subscription for just $1 per month NordVPN - 2 year subscription at up to 68% off Private Internet Access VPN - subscriptions at up to 71% off Unlocator VPN or SmartDNS - unblock Geoblock with 7-day free trial Neowin Store for our preferred partners. Subscribe to Neowin - for $14 a year, or $28 a year for Ad-Free experience Disable Sponsored posts · Neowin Deals · Free eBooks · Neowin Store

      Disclosure: A valid email address is required to fulfill your request. Complete and verifiable information is required in order to receive this offer. By submitting a request, your information is subject to TradePub.com's Privacy Policy.

    • By News Staff
      Save 98% off this All-in-One Coding Skills Bundle
      by Steven Parker

      Today's highlighted deal comes via our Online Courses section of the Neowin Deals store, where you can save 98% off the All-in-One Coding Skills Bundle. Boost your IT skill set and master coding with 25 hours on Scratch, Kodu, Python, SQL, Flutter, C++, and ITIL.



      This bundle consists of the following courses:

      Scratch 3.0 Programming Masterclass: Learn by Creating 12 Funny Games
      Build Games in Scratch 3.0 Including Snake, Pac-Man, Racing Game, & Elsa from Frozen Learn Coding by Creating 3D Games with Kodu Game Lab
      Be an Expert Coder in the Exciting, Funny Kodu Game Lab Python MTA 98-381 Complete Preparation Course
      Your Complete Python Resource to Succeed in the Python Certification MTA 98-381 Exams! MTA 98-361: Software Development Fundamentals Preparation Course
      Everything You Need to Pass the Microsoft MTA 98-361 Exam with Step-by-Step Examples SQL: Mastering MySQL & MariaDB with Examples for Beginners
      Understand SQL Using the MySQL Database, How to Install MySQL Service & Design Databases Master Flutter & Dart with a Complete Showcase Mobile App
      Build iOS & Android Apps with a Showcase Example Based on Dart and Flutter Framework C++: Master C++ with Step-by-Step Examples for Beginners
      Start from the Basics & Go All the Way to Creating Your Own Applications ITIL 4 Certification Exam: A Complete Preparation Masterclass to Master ITIL
      A 3-Step Process to Master ITIL & Pass the Exam Good to know
      Length of time users can access this course: lifetime This plan is only available to new users Redemption deadline: redeem your code within 30 days of purchase For a full description, specs, and instructor info, click here.

      Here's the deal:
      This All-in-One Coding Skills Bundle normally costs $1,592, but you can pick it up for just $29.99 for a limited time - that represents a saving of $1,562.01 (98%) off.

      Get this deal, or learn more about it
      See all discounted Online Courses. This is a time-limited offer.
      Get $1 credit for every $25 spent · Give $10, Get $10 · 10% off for first-time buyers.

      Not for you?
      That's OK, there are other free eBooks on offer you can check out here.



      Home Gym Giveaway | Bitcoin (BTC) Investment Giveaway Ivacy VPN - 5 year subscription for just $1 per month NordVPN - 2 year subscription at up to 68% off Private Internet Access VPN - subscriptions at up to 71% off Unlocator VPN or SmartDNS - unblock Geoblock with 7-day free trial Neowin Store for our preferred partners. Subscribe to Neowin - for $14 a year, or $28 a year for Ad-Free experience Disable Sponsored posts · Neowin Deals · Free eBooks · Neowin Store

      Disclosure: A valid email address is required to fulfill your request. Complete and verifiable information is required in order to receive this offer. By submitting a request, your information is subject to TradePub.com's Privacy Policy.