Database Design for Customer Management System

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 DESCRIPTIONTYPELENGTH
CUSTOMER_IDCustomer ID numberint11
FIRSTNAMEName of customervarchar50
LAST_NAMESure name of customervarchar50
ADDRESSAddress of the Customervarchar50
EMAILEmail of the Customervarchar50
CONTACT_NOContact of the customerint11
GENDERGender of customervarchar50

Table 2: TblEmployee

FIELD NAME DESCRIPTIONTYPELENGTH
EMPLOYEE_IDEmployee ID numberint11
FIRST_NAMEName of employeevarchar50
LAST_NAMESure name of employeevarchar50
JOB_TITLETitle of the Jobvarchar50
CONTACT_NOContact of Employeevarchar50
HIRED_DATEHired date of employeeint11
SALARYSalary of employeeint11

Table 3: TblIncome

FIELD NAME DESCRIPTIONTYPELENGTH
CAPITALCapitalint11
EMPLOYEE_IDEmployee ID numberint11
PROD_IDProduct IDint11
PROFITProfitint11
INCOMEIncome per monthint11

Table 4: TblLocation

FIELD NAME DESCRIPTIONTYPELENGTH
LOCATIONT_IDLocation numberint11
PROVINCELocation within the countryvarchar50
CITYCity of provincevarchar50
MUNICIPALITYMunicipalityvarchar50

Table 5: TblProduct

FIELD NAME DESCRIPTIONTYPELENGTH
PRODUCT_IDNumber of productint11
NAMEName of productvarchar50
DESCRIPTIONProduct descriptionvarchar50
PRICEPrice of productint11

Table 6: TblTransaction

FIELD NAME DESCRIPTIONTYPELENGTH
TRANS_IDTransaction ID numberint11
CUSTOMER_IDID number of customervarchar50
PROD_IDProduct ID numbervarchar50
LOC_IDLocation ID numberint11
DATE_TIMEDay of transactiondate11

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.

Leave a Comment