Database Structure & Integrity

More information regarding the database.

Database Integrity

Integrity constraints are a set of rules. they are used to maintain the quality of information.
integrity constraints ensure that data insertion, updating and other processes have to be performed that data integrity is affected.
Integrity constraints are used to guard against accidental damage to the database.

types of integrity constraints

1. Domain constraint

Data column constraints are listed below.

id's are auto created and generated upon insertion of new records

database name: fashionshop

table name: product

Description of product table

Name

Description

id of product

name

name of product

description

describe which category it belongs to

price

price of the product

sql create table script

# create table script for product
CREATE TABLE product (
id           INT           NOT NULL AUTO_INCREMENT,
name         CHAR(60)      NOT NULL DEFAULT '',
description  VARCHAR(200)  NOT NULL DEFAULT '',
price        DECIMAL(8,2)  NOT NULL DEFAULT 0.00,
PRIMARY KEY  (id));

2. entity integrity constraint

no null values are used in the table (all values are required to be inserted at the point of record creation)
no foreign keys are used in this project within the other table columns specified above

3. referential integrity constraint

To update referential integrity constraint when foreign key is used in the project.

Not Applicable

4. key constraint

all id's used in the product table are unique keys
it is not allowed to insert two id's of the same value in the column id to maintain database integrity
it is allowed that two or more products with the same name but referring to the same id due to to differentiate between two prices (one is on sales and one is isnt)

PreviousClass Diagrams NextInstall Node Version Manager

Last updated 3 years ago

Was this helpful?

# create table script for product CREATE TABLE product ( id INT NOT NULL AUTO_INCREMENT, name CHAR(60) NOT NULL DEFAULT '', description VARCHAR(200) NOT NULL DEFAULT '', price DECIMAL(8,2) NOT NULL DEFAULT 0.00, PRIMARY KEY (id));