You Can contact us by filling the form below:

Thank you, your message was sent successfully!

Please, wait our respond.

Sorry, the error has occured.


You Can contact us by filling the form below:

Thank you, your message was sent successfully!

Please, wait our respond.

Sorry, the error has occured.


Seller Database

About


The database is a part of a bigger project devoted to automating the process of selling prepaid phone cards.

 

It deals with information about all users of the system (staff, resellers, clients) including the data necessary for their authentication, etc.

 

 

PROPERTIES


Number of databases: 4
Total size: ~1 Gb
Number of tables: ~140
Number of views: 20
Number of stored procedures: ~100
Number of entries in tables ranges: 40 – several hundred million
Number of queries per transaction: 1-500

Features


Set of phone cards being sold (including their serial and authentication numbers)
Purchases made by users
Rights for every user
Set of SMS notifications to be sent to users
Limits for various types of users
Financial transactions for the user’s balance
Information about all operations performed within the system

 

EFFORT


 500 man-hours

 

Services


Stored procedures
Functions
Database Upgrade
Data Modelling
Data Merge

Tools and Technologies


Contact us
Feel free to contact us.
Our work hours:
Monday-Friday 8am - 8pm

Thank you, your message was sent successfully!

Please, wait our respond.


Sorry, the error has occured.


Our location:

Megapolis Office Center, Office 607,
Moskovskiy av. 179-B Kharkiv, 61068, Ukraine