Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > Which paradigm does this database design violate?

Which paradigm does this database design violate?

WBOY
Release： 2016-10-23 23:59:57
Original
914 people have browsed it

For example, for a shopping cart data table, someone designed it like this, cert(id, uid, item1, item2, item3...), but the correct approach should be to divide it into two tables, cert(cert_id, item), cert( uid,cert_id).

So what paradigm does the incorrect table violate? Why?

Related labels：
mysql php sql database paradigm
source：php.cn
Previous article：How to generate mobile phone numbers in batches with PHP Next article：The background of the PNG image loaded by exif.js is black?
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
9
1588
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
How to trigger render (with filter and pagination) on sort method in React? Here is my Sort.js style component: <SortWrapper><SortText>SortBy</SortText...
From 2024-04-06 21:28:37
0
1
2257
Regular expression to match words I have a script where I am trying to match new job names with existing job names in a data...
From 2024-04-06 21:24:04
0
1
606
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template