Database Design for Customer Management System

This Database Design for Customer Management System or Customer Relationship Management System, is one of the DBMS Mini Project in which the customers of an enterprise are the most important asset of any business can have.

Depending on the kind of industry, a business enterprise may also sell to the same customers over and over.

A purchaser database is the collection of statistics that is gathered from each person.

The database may additionally encompass contact data, just like the person’s name, address, telephone number, and electronic mail address.

The database can also also include beyond purchases and destiny needs.

DATABASE DESIGN FOR HELLO KITTY CAFE CUSTOMER MANAGEMENT SYSTEM

The previous way of selling the items for foods in other café was not turned to be effective that much to the users and the buyer, it wasn’t that effective because they have nothing to do when it comes in storing data or recent buy items of the buyers/customer.

So, this Kitty Café Customers Service System has introduced and developed for the satisfaction of user and of the customer.

This system has made to lessen the hardship of the user/seller while using, editing and updating the existing data.

Since the Kitty Café was nothing to do with the system since they have none, this can be effective and much way better to use for them. Moreover, this system is designed for the particular need of the seller to carry out an update of information in a smooth and effective manner.

This system reduce as much as possible any errors while entering any data to this system.

Features:

Manage Products
Manage records
Easy in updating data
Organized Information
Effective at storing data

DATA DICTIONARIES

Table 1: Tblcustomer

FIELD NAME	DESCRIPTION	TYPE	LENGTH
CUSTOMER_ID	Customer ID number	int	11
FIRSTNAME	Name of customer	varchar	50
LAST_NAME	Sure name of customer	varchar	50
ADDRESS	Address of the Customer	varchar	50
EMAIL	Email of the Customer	varchar	50
CONTACT_NO	Contact of the customer	int	11
GENDER	Gender of customer	varchar	50

Table 2: TblEmployee

FIELD NAME	DESCRIPTION	TYPE	LENGTH
EMPLOYEE_ID	Employee ID number	int	11
FIRST_NAME	Name of employee	varchar	50
LAST_NAME	Sure name of employee	varchar	50
JOB_TITLE	Title of the Job	varchar	50
CONTACT_NO	Contact of Employee	varchar	50
HIRED_DATE	Hired date of employee	int	11
SALARY	Salary of employee	int	11

Table 3: TblIncome

FIELD NAME	DESCRIPTION	TYPE	LENGTH
CAPITAL	Capital	int	11
EMPLOYEE_ID	Employee ID number	int	11
PROD_ID	Product ID	int	11
PROFIT	Profit	int	11
INCOME	Income per month	int	11

Table 4: TblLocation

FIELD NAME	DESCRIPTION	TYPE	LENGTH
LOCATIONT_ID	Location number	int	11
PROVINCE	Location within the country	varchar	50
CITY	City of province	varchar	50
MUNICIPALITY	Municipality	varchar	50

Table 5: TblProduct

FIELD NAME	DESCRIPTION	TYPE	LENGTH
PRODUCT_ID	Number of product	int	11
NAME	Name of product	varchar	50
DESCRIPTION	Product description	varchar	50
PRICE	Price of product	int	11

Table 6: TblTransaction

FIELD NAME	DESCRIPTION	TYPE	LENGTH
TRANS_ID	Transaction ID number	int	11
CUSTOMER_ID	ID number of customer	varchar	50
PROD_ID	Product ID number	varchar	50
LOC_ID	Location ID number	int	11
DATE_TIME	Day of transaction	date	11

ENTITY RELATIONSHIP DIAGRAM

ERD of Management System for Customer Relationship

DATABASE DESIGN FOR HELLO KITTY CAFE MANAGEMENT SYSTEM — DATABASE DESIGN FOR HELLO KITTY CAFE CUSTOMER’S MANAGEMENT SYSTEM

For More Database Design Examples

Inquiries

If you have any questions or suggestions about Customer Management System Database Design, please let’s me know by dropping your comment below.

Database Design for Customer Management System

DATA DICTIONARIES

ENTITY RELATIONSHIP DIAGRAM

For More Database Design Examples

Inquiries

Leave a Comment Cancel reply