V
V
Viktor2015-05-16 18:41:30
Database
Viktor, 2015-05-16 18:41:30

Is the database normalized?

Good day. Experts prompt the DB is how much normalized. What do you think could be changed?

CREATE TABLE `site_catalog_items` (
  `id` INT(30) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'уникальный номер ',
  `thumbnail` VARCHAR(255) NOT NULL DEFAULT '/content/images/default_thumb.png' COMMENT 'миниатюра',
  `image` VARCHAR(255) NOT NULL DEFAULT '/content/images/ .png' COMMENT 'фото',
  `category` VARCHAR(20) NOT NULL DEFAULT '' COMMENT 'категория',
  `material` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'материал',
  `region` VARCHAR(20) NOT NULL DEFAULT '' COMMENT 'район',
  `district` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'населенный пункт',
  `town` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'город',
  `digging` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'раскоп',
  `layer` VARCHAR(20) NOT NULL DEFAULT '' COMMENT 'слой',
  `square` VARCHAR(10) NOT NULL DEFAULT '' COMMENT 'квадрат',
  `fieldNumber` VARCHAR(30) NOT NULL DEFAULT '' COMMENT 'полевой номер',
  `area` VARCHAR(20) NOT NULL DEFAULT '' COMMENT 'участок',
  `homestead` VARCHAR(20) NULL DEFAULT '' COMMENT 'усадьба',
  `gps` VARCHAR(30) NULL DEFAULT '' COMMENT 'координаты позитирования',
  `year` YEAR NOT NULL DEFAULT '2013' COMMENT 'год',
  `title` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'наименование ',
  `description` MEDIUMTEXT NULL COMMENT 'описание ',
  `dating` VARCHAR(20) NULL DEFAULT '' COMMENT 'датировка',
  `storagePlace` VARCHAR(20) NOT NULL DEFAULT '' COMMENT 'место хранения',
  `notes` MEDIUMTEXT NULL COMMENT 'блокнот',
  PRIMARY KEY (`id`),
  INDEX `cost` (`title`),
  INDEX `category_realm` (`category`, `material`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
AUTO_INCREMENT=8;

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
sim3x, 2015-05-16
@Sideway

Is the database normalized?
no
To improve the situation, consider how best to store duplicate data for the following fields
category
material
region
district
town
digging

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question