Could someone describe for me the differences between top down normalisation and bottom up normalisation with regards to databases, namely relational databases.
Top Down Vs Bottom Up - Normalisation
11.7k Views Asked by user559142 At
1
There are 1 best solutions below
Related Questions in DATABASE-DESIGN
- SQL schema for a fill-in-the-blank exercise
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- steps to create a web app with backend and database and web
- Use data type uuid or varchar(36) for my UUID column?
- Containing Object Design
- Many-to-many relationship between objects of the same type
- When hashing an API key, should I hash the suffix / prefix as well?
- Database design, authentication and authorization in a microservices ticketing system
- Unique index on 3 columns where NULL conflicts with all other values in one column
- Can i create a table with 2 foreign keys? These 2 foreign keys are 2 primary keys of 2 different tables
- I have a basic ms access question about a relationship between 3 tables
- how can i calculate mutual friends/followers efficiently?
- Access Table ,setting in design ,column 'Catagory' as Combobox in lookup with list "Action";"War";"Drama". in vb.net DGV and Detail how to multiselct
- Table Design for Calculating Median Over User-Defined Period from Pre-Processed Data
- Use conditional constraint or normalize table?
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 BOTTOM-UP
- Eliminating Recursion stack space
- bottom up register allocation, reserving register for loads/stores
- Cant initialize a 2d array/matrix to 0
- Recursive query sum leaf values and pass sum to parents. Values stored in another table
- How do you implement the bottom-up and top-down approach in this problem?
- How can I add limited coins to the coin change problem? (Bottom-up - Dynamic programming)
- Count the sum of subsets of size k when the sum is (Greater than or equal to R) or (Lesser than or equal to L)
- Runtime Error when Trying Bottom Up Approach to Implement Fibonacci function in Swift?
- when adding new text it appears on bottom and rest of text goes up
- How to convert the recursive solution to "Moons and Umbrellas" to DP?
- LR-Parsing-Table: What determines next state in reduce-actions?
- Output produced for the given input using the bottom up parsing
- L-attributed grammar and bottom-up parsing
- Parsing table size (bottom-up)
- Find k out of n subset with maximal area
Related Questions in TOPDOWN
- Making Smooth, Top Down Swords and Attacks in Godot 4.1?
- Why is unity not modifying my player's position?
- Function to play animation based on mouse position not working in Godot
- I am trying to make a tile layer be disabled in code Godot
- 2D layering/URP issue when using fence tiles
- Unity2D Movement - velocity not working correctly
- ScreenToWorldPoint no longer works in latest Unity version?
- onmousedown return wrong result after tilemap refresh
- In 2D animation, the character goes into idle mode when a key is pressed in unity
- 0/1 Knapsack - return maximum value + list of included items - Top Down Approach - Time Complexity cubic or quadratic?
- pygame shooting script causing lines
- how to make an enemy only attack the player when the player is in a state that can be attacked?
- Generating bird eye view of image in OpenCV(Python) without knowing exact positions of reference points and camera properties
- How to add 3D shadows on a 2D sprite that looks directly into the camera?
- Make an object follow A* path smoothly
Related Questions in TOP-DOWN
- IsTouching and OverlapCollider contradicting each other?
- Unity - Make player point toward mouse
- c++ player-wall collision with SFML
- 2D Depth System Method XNA C#
- Dynamic programming Topdown approach - minimum cost in a matrix (in python)
- Smallest n-bit integer c that has k 1-bits and is the sum of two n-bit integers that have g, h bits set to 1(dynamic programming)
- AntlrGrammar.g4::: The following sets of rules are mutually left-recursive [subquery]
- How to extend the background in LibGdx for top down game?
- Approach handling data that are introduced “Bottom-up” and refined “Top-down”
- Top-down tree search & replace
- ACODE - spoj: Suggest what might be wrong with my approach
- How to implement an algorithm to merge two heaps with n=2^k number of elements in O (k) time?
- Java: Iteration to find a coordinate point that hasn't been used?
- Identify data warehouse design methodologies in the following diagram
- With only rudimentary prior programming experience, exactly how would I begin creating a 3d top-down game using unity3D?
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 # Hahtags
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?
I expect you mean top-down design vs bottom-up design - normalization being just one aspect of the methods and principles you would use to complete a database design.
Top-down means you start with a set of requirements. Usually you begin by identifying the types of things that you need to represent data about and then identify the attributes of those things, which will become attributes in tables.
Bottom-up design means you are given some kind of data structures to start with, e.g. a list of attributes or tables and attributes which you need to incorporate into a design. Typically this might happen where you have an existing database or data source, as is common in business intelligence or data integration projects.