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
- Big data with spatial queries/indexing
- Unique hash/index for time interval
- Best practices for creating a huge SQL table
- Database Design: How should I store user's news preferences in MySQL database?
- Is it recommended to use Node.js for an online room booking web application?
- Storing multiple item settings in database
- Which column type for storing the year field in a table with rows of yearly data
- Best way to setup a i8n in a database
- Database normalization for electricity monitoring system
- Database Design: Unique Billing Assocation
- Is it always a bad practice to have circular relationships in your database design
- One column maps to mutiple columns from different table
- Replicating tables within the database
- mysql one translates table vs multiple translate table
- Nosql database design for complex querying
Related Questions in DATABASE-NORMALIZATION
- Database normalization for electricity monitoring system
- convert query to use of joins
- Should I normalize or not? If yes how?
- Third Normal Form in DBMS
- Understanding BCNF Functional Dependency
- Which normal form does the ER Diagram guarantee?
- How to insert multiple values in a specific field in a table using mysqli?
- How to use cascade delete vs restrict for referential integrity with one-to-one record relationships?
- Can a 2NF database already be in 3NF?
- Normalized and immutable data model
- Is the decomposition reversible for relational databases
- Database Normalisation: 1-1 relationships and 3NF
- Converting a relation into 3NF
- SQL normalization query
- Should I normalize 20 millions row x 2 column MySQL table
Related Questions in BOTTOM-UP
- How to fix the footer to bottom of the page?
- Knapsack 0-1 path reconstruction (which items to take)
- Bottom-Up-Parser: When to apply which reduction rule?
- How to return arbitrary XML Document using an Eclipse/AXIS2 POJO Service
- LR-Parsing-Table: What determines next state in reduce-actions?
- Positioning AndroidSlidingUpPanel to a specific height
- Can some one please provide the practical examples of stubs and drivers?
- Output produced for the given input using the bottom up parsing
- Cant initialize a 2d array/matrix to 0
- How can I add limited coins to the coin change problem? (Bottom-up - Dynamic programming)
- Is the following approach dynamic programming
- Compiler Design First and follow
- What are the problems with bottom up approach
- Spacial partitionning bottom up tree
- Identify data warehouse design methodologies in the following diagram
Related Questions in TOPDOWN
- how to add Scoring to unity3D 2d top down car game?
- Monogame 2D top down enemy AI
- Function to play animation based on mouse position not working in Godot
- Why is unity not modifying my player's position?
- Making Smooth, Top Down Swords and Attacks in Godot 4.1?
- Local Variable NullPointerException
- How to programmatically switch tile palettes in Unity2D
- Issue in the top down approach to the Coin Change (Similar to the 0-1 backpack problem)
- C# generating lake-like shapes in a 2d top-down tile grid
- Why using chuncks with infinite world creation (unity C# 2d top down)
- XNA- MOBA Game Movement
- BDD Top-Down Approach
- Can some one please provide the practical examples of stubs and drivers?
- Is it possible to compute coordinates of an unkown point using cv2.findHomography?
- How to add 3D shadows on a 2D sprite that looks directly into the camera?
Related Questions in TOP-DOWN
- Top Down Parsing - Java
- XNA Waterphysics Top-Down Hex-based grid
- Combining lexer with many parsers
- Using ServletContextListener with top-down JAX-WS WebService in Websphere
- Making functions with Crafty.js
- LL(1) parser generator in OCaml
- How to configure SSL in WSDL First CXF Framework web service?
- Java: Iteration to find a coordinate point that hasn't been used?
- top-down rendering - how to solve state in pre-populated input fields
- Compiler Design First and follow
- Identify data warehouse design methodologies in the following diagram
- IsTouching and OverlapCollider contradicting each other?
- Is there a simple workflow to generate a database schema from classes with hibernate mappings?
- Top Down Vs Bottom Up - Normalisation
- Emacs Lisp: Byte-compiler warning for undefined functions in apply, mapcar
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?
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.