This is the given ER diagram.
This requires me to convert the ER diagram to Tables/Entities, and then Normalize them to at least 3NF, now almost all the entities except the Food Items entity is in 1NF. If I remove the columns vitamins and minerals from the Food Items table and make separate tables called Food Item Vitamin with attributes (id(primary key), fooditem_id(foreign key), vitamin) and Food Item Mineral with attributes (id(primary key), fooditem_id(foreign key), mineral), these tables would also become into the 1NF form. Now how do I proceed in converting them into 2Nf and then 3NF, for this entity and the rest.

How do i normalize the given entities in the database ER diagram. And also shouldn't normalization be done before making the ER diagram?
18 Views Asked by Veeraja Veeraesh At
0
There are 0 best solutions below
Related Questions in DATABASE
- How to add the dynamic new rows from my registration form in my database?
- How to store a date/time in sqlite (or something similar to a date)
- Problem with add new attribute in table with BOTO3 on python
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- Cannot connect to Postgres Database when running Quarkus Tests with Gitlab ci
- Local or remote database with react-native?
- I want to edit a specific row in database
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- Open Web Library
- database login.py and register.py error showing 404 file not found and doesn't work
- SQL71561: SqlComputedColumn: When column selected
- Liquibase as SaaS To Configure Multiple Database as Dynamic
- Updated max input vars but table still shows error
- Spring does not map set of roles
Related Questions in ENTITY-RELATIONSHIP
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- How do i normalize the given entities in the database ER diagram. And also shouldn't normalization be done before making the ER diagram?
- I need help in creating a ER model for my database
- NER grouping into objects
- Issue with Setting Relationships in Business Entity when Creating New Business with Associated Services and Workers
- How to model composite primary keys in the ER model?
- An associative Entity with optional participation on one side and mandatory participation on the other
- ER diagram: total participation and identifying relationship
- Were the entity sets and their associated relationships accurately and properly constructed?
- ER diagroms Composite Key representation in m;n relationship
- Kotlin [Hilt] java.lang.reflect.InvocationTargetException (no error message) Error
- Adding relationship to an Entity couses weird ORM mapping error
- Is this a correct foreign key relationship standard?
- Is combining a Junk Dimension with a Conformed Dimension in a single table advisable for efficient data management?
- Why is my slicer not filtering values correctly for me for 2 different matrix?
Related Questions in DATABASE-NORMALIZATION
- How do i normalize the given entities in the database ER diagram. And also shouldn't normalization be done before making the ER diagram?
- normalize table up to BCNF?
- attribute partially depends on a candidate key but the answer says the relation is in 3NF
- How can I move past this 2NF to achieve a proper normalization of the table up to 3NF
- Normalize a many-to-many table
- Is it possible to have a decomposed table to be the same as original one? BCNF Conversion
- Is it really better to respect the normal forms and create an additional table for one simple field?
- Normalize a table with a non-prime attribute and a multivalued dependency within the candidate key to 4NF
- Does it violate any normalization rules if I add a boolean column to a db table?
- Pros and Cons of Constraints across Many-To-Many relationship
- Making (3) composite primary key less redundant
- Dependency-Preserving Decomposition
- Database Normalization BCNF decomposition
- How does this relation produce candidate keys?
- Database normalization for 1 to many, many to many, many to 1
Related Questions in 3NF
- Third Normal Form in DBMS
- Understanding BCNF Functional Dependency
- Database Normalisation: 1-1 relationships and 3NF
- Converting a relation into 3NF
- Multivalued dependency confusion
- Can you have a composite key when in Third Normal Form (3NF)?
- Normalizing to BCNF and Removing Anomalies
- How can I normalize to 3NF these tables?
- 3NF vs BCNF: Example
- Normalization to 3NF
- is my table in 3nf
- Normalization of an 1:1 or 1:0 relationship
- Confused about third normal form: a table having more than one candidate key
- How do I put this data into third normal form?
- Have I normalized this database to a 3NF level the right way?
Related Questions in FIRST-NORMAL-FORM
- How do i normalize the given entities in the database ER diagram. And also shouldn't normalization be done before making the ER diagram?
- xplode data in google sheet
- How do you deal with multiple values in a single cell separated by comma?
- Database normalization for 1 to many, many to many, many to 1
- How to normalize table1 in postgres sql?
- PHP/MySQL: Multiple comma separated values per table field vs... WHAT?
- How to create new rows of data based on a single cell within an arrayforumla-wrapped-query call in google sheets?s?
- convert data to 1NF
- How to create a formula that will repeat a range by splitting one column and joining with the other column?
- Make Into First Normal Form
- Determining if a relation is 1NF with no data
- Multiple rows vs comma-separated column in design in MySQL
- Native JSON support in MYSQL 5.7 : what are the pros and cons of JSON data type in MYSQL?
- First normal form violation
- First Normal Form Database Normalization
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?