MySQL database building/maintenance of records/automated mail generation

Budget $100 - $500 USD
Bids 9
Average Bid $497

We are building a new company to help realestate agents sell houses. For this purpose we need a database with houses and realestate agents.

In this database realestate agents should be able to register in which houses home owners are interested in. THe system should be able to automatically mail agents and home owners

We are looking for a coder who can:7

- create a mysql database including recordstructure
- create php maintenance pages for the database
- programm a matching function
- implement users maintenance (login, create, forgot password etc)
- create automatic generated mails from the database

## Deliverables

**The Dutch housing market is in a bad shape. People who own a house put it to the market and wait for their house to sell before they buy a new house. In essence everyone is waiting for every one and hardly any sales are recorded. Purpose of the site is to get the market rolling again by finding out who is interested in which house.

In Holland when a house is put up for sale, ONE real estate agent gets the listing, and gets paid when the house is sold. So the agents are a key figure in the process which must not be overlooked.

We would like the sellers to start selecting the house they want and tell their estate agent about their preferred new home. The realestate agent should put this information in a database. This database and the management around it is to be built.

On a regularly basis the website should inform the agents which houses their clients are interested in and which houses they can sell tot other agents customers. If owner of house A is interested in house B and B is interested in C and C is interested in D we call this a train (with traincarts). Still nothing happens until A is sold

The website offers 3 types of solutions for this problem
1 We ask all owners if they are prepared to buy a cheaper house if they can sell their house. For example if the value of house D is 1 million and house A is worth only 100K it could be that D will buy A, not to live, in but as an investment. He will have sold his house and will have his hands free to buy a new house. We call this a "koekkoek"
2 We check if the train is very short and A proves to be interested in B and vice versa. We call this a "siamees" (siamese)
3 We check if D (the big expesive house) maybe is interested in house A (a small appartment) to really live in. We call this a "Slang" (snake)

When a realestate agent adds a traincart the agent has to fill a form with questions an example <[url removed, login to view]>

We devided the project in different fases to reduce the complexity.

[[url removed, login to view]][1] is online with explanation of the matching proces. It is in Dutch, but google translate should help to put it into english.
[[url removed, login to view]][2] is the main housing site
**
We added aditional files
- Database design ( to be used as a starting point for development)
- ODB (example with maintainance screens and database starting point)
- matching function (flowchart for matching function)

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • matifmunaf1 Profile Picture

    matifmunaf1

    Karachi,  Pakistan

    Development Services Web Promotion and Marketing Professional website C.M.S. Development E-Commerce Solutions Portal & Communities Web Applications P.O.S Solutions Accounts Management Enterprise Solutions H.R Solutions Offshore Outsourcing and Services Web Designing Technical Resource Outsourcing Financial Consultancy Software Development Call center Development Network Consultancy

    PHP, ASP, Visual Basic, and .NET

  • SunilVyas01 Profile Picture

    SunilVyas01

    Indore,  India

    Advance Technology & quot;AT" India is a gateway of outsourcing Software development, BPO, KPO, Customer Support and other IT & ITES services industry for the customers across the world. AT offers range of IT outsourcing services including Software Development, Website Designing, Data Entry Jobs, Tele Phone Call Answering Services and range of industry outsourcing services.

    PHP, ASP, JSP, and Visual Basic

  • newgroup4u Profile Picture

    newgroup4u

    Kolkata,  India

    Newgroup4u is one of the growing software consulting company with a huge diversity in service provision. Since its inception in the year 2010 it has been enriching not only in terms of experience but also in skill set and expertise. Carrying technology to next door is the motto of the team. Our goal is to create a seamless customer service integration where customers can reach us with their issues instantly.

    PHP, Javascript, Website Design, and Internet Marketing

  • shaikhaezaz80 Profile Picture

    shaikhaezaz80

    surat,  India

    Hi all, I am working in templatic.com as a wordpress developer and I have created so many themes with Woo Commerce and WPML. I am also working as Freelance Wordpress developer to get some more money and good reputation and help to someone to expand my expertise. I love to work with Wordpress. I am self learning guy and always try to learn and do something new.

    PHP, Javascript, Website Design, and Graphic Design

  • deepdevelopervw Profile Picture

    deepdevelopervw

    India

    ## BIO I m Avni Sanghvi. Living in Ahmedabad, India. I am experienced graduate in Computer Applications. I have team of Graduates in Computer Applications. We work as freelancer. ## Area of Expertise Main :  I specifically work for .Net (C#.net, VB.Net, ASP.Net). I work for SQL-Server, MS Access. Seceondary : I also can work for PHP, MySQL. Experience : I am working in Programming field since 6 years.

    PHP, Perl, ASP, and C Programming

  • alexwww Profile Picture

    alexwww

    xxxxxxx,  United States

    ---

    PHP, System Admin, Linux, and Web Security

  • Eliteprog Profile Picture

    Eliteprog

    CPH1,  Pakistan

    .net Windows Azure Php & MySql SqlServer DotnetNuke Content writing Graphics Designing

    PHP, ASP, Javascript, and .NET

  • shoaibphpmysql Profile Picture

    shoaibphpmysql

    Sargodha, 

    Degrees M Phil(Computer Science) My Expert Service I can help you in various programming languages, software development and web design software. Languages Visual Basic 6 Visual Basic.Net C/C++ Java C Sharp Python HTML, DHTML, XML JavaScript (ECMAScript 5, DOM, BOM) PHP dynamic page generation PERL Ajax Asp classic Asp.net Databases Oracle MS-SQL Server 2000,2005,2008 MS Access MySQl Platforms Microsoft .Net 1.0,2.0,3.5,4.0 Sun Java 2 IDE's Microsoft Visual Studio 2008 Microsoft Visual Studio 2010 NetBeans IDE JCreator Eclipse Netbeans Bluej Borland Turbo C++ IDE Experience & Qualifications I have done M Phil with computer science and 4 year experience in software house as a senior developer.

  • khersunil Profile Picture

    khersunil

    NAGPUR,  United States

    Sunil P. Kher Experience Summary • Over Fifteen years of experience in varying capacities including Technical Manager and Senior Technical Architect for Client-Server applications using C++, Java, Sybase and Unix along with Web applications using PHP, mySQL, CodeIgniter, JQuery and CSS. • Possesses a thorough knowledge of Object Oriented (Various) Methodologies, Analysis, Design and Programming for applications with 3-tier architecture. • Good experience in Business and System Requirement analysis and Software Engineering tools and methodologies. • Very Good RDBMS experience in Sybase (including Stored Procedures and some DBA experience, also implemented Business Rules using Rules & Triggers) • Varied hardware platform experience ranging from IBM PC Compatibles to Linux multiple blade servers from HP and also Sun-Solaris boxes with excellent RAID, NFS, CFS, Linux clustering experience • Personnel management experience ranging from resource planning, project management starting at the interview/selection process to conducting internal performance reviews within the team and also for peer groups Technical Skills Programming Languages: C, C++, Java, Pascal Relational Databases: Sybase, Oracle, MS Access Web development: PHP, mySQL, JQuery, ActiveWidgets, QCodo, CodeIgniter Database Connectivity: ODBC, JDBC, Tuxedo, Sybase Open Client Messaging, Queues: MQ, Tibco Operating Systems: Windows, Unix, Linux Hardware Platforms: IBM PC Compatibles, Sun, HP-UX, RAID, Linux clusters Netowrking: TCP/IP, Sockets programming Unix Shell Scripting: Shell script, Various shells, Perl and Nawk Others: Erwin, Turbo Analyst, Sybase IQ, RougeWave, STL, RiskScript, Rational Rose, Winrunner, Clearcase, PVCS Project planning tools: Microsoft Project, dotProject, Trac and Subversion Professional Experience Aug 07 – To date Technical Manager, Park City Group, USA (Based in Nagpur, India) Project: PCG ScoreTracker for retail operations (Currently ongoing) Description: ScoreTracker is a web based product to be used by various retail organizations. The product allows the setup of company, stores at district and sub-district levels, category wise distribution of products using mySQL hierarchical tree structure and thus provides reporting at various levels to different people in middle and upper level management. It also has an advanced level CMS to first install and then setup the entire program on the organization’s web server. The first stage of prototype development using PHP and mySQL is now complete and the second stage of converting this to a much bigger product involving PHP, Java and Oracle based solution is now underway. Role: • Active participation in Requirement analysis phase for the ScoreTracker project • Created a number of Use Cases from the requirements provided • Data modeling first for prototype using mySQL and then converting the same to Oracle • PHP model and controller classes development using codeIgniter for stores, products, etc. • Customization of PEAR tree, database, calendar and various other library classes • Data generator and aggregator controllers and related development for prototype Software/tools: PHP, mySQL, Zend studio, Eclipse, QCodo, CodeIgniter, JQuery, FusionCharts Jan 06 – Mar 07 Senior Technical Manager, Federal Express, Orlando, FL Project: Online transaction processing for Real invoicing Revenue Cycle Controls Server is an engine developed to track Revenue earned and billed by Federal Express. Currently the engine is showing signs of performance degradation due to extremely high number of transactions that are being processed. Looking at the further volume of transactions that is expected to flow through the system, an idea is being worked upon which involves storing the Controls data in some kind of data warehouse format. Sybase IQ was one of the solutions explored to do this. Role: • Active participation in Requirement analysis phase • Created a number of Use Cases from the requirements • Designed generic data capture API for various types of transactions coming from different engines in the transaction route • Involved in creating data model needed for generic data capture API • Coded and tested the generic capture API in C++ along with needed SQL stored procedures • Designed and coded a shell script wrapper and a test client for testing the data capture API • Involved in product testing for this project Software/tools: C++, Tuxedo, Sybase, Unix, Rational Rose, Unix Shell Scripting (nawk & Perl), Tibco, MQ Mar 04 – Jan 06 Technical Architect, Federal Express, Orlando, FL Project: Revenue Cycle Control Reporting Engine Revenue Cycle Controls reporting engine is used by Management to track various revenue activities for an invoicing cycle. The reporting engine generates some pre-defined daily, weekly and monthly reports and these can be viewed by various users depending upon their level of security. Also, the users have the flexibility of creating ad-hoc report queries and generating output as desired. The front end for the engine is developed in Java using PowerJ and it connects to the Sybase database on the backend using JDBC calls. Some Tuxedo servers written in C++ were also used for data extraction. Role: • Active participation in Requirement analysis phase along with Window layouts • Participated in development of logical and physical data model • Designed the object model and was also involved in creating various class diagrams, sequence diagrams and data flow diagrams • Coded different reporting classes and Window layouts • Coded some of the Tuxedo servers in C++ • Was involved in product testing using WinRunner Software/tools: C++, Unix, Tuxedo, Java, JDBC, Sybase, Rational Rose, WinRunner Jan 01 – Mar 04 Technical Design Lead, Federal Express, Orlando, FL Project: Revenue Cycle Controls Analysis Driver Revenue Cycle Controls Analysis Driver is used to analyse the transactional data stored in Sybase tables. The driver looks at past data and detect the trend of how the revenue flow is going to be affected for the future invoicing cycles by predicting the expected values using the historical data. It also calculates anomaly for current invoicing cycle revenue flow. The driver is written using C++ with STL and LAPack provided by RogueWave software. Role: • Active participation in Requirement analysis phase • Was involved in discussions and testing phase for choosing which tools and algorithm to use for prediction and anomaly calculation using Shell programming with nawk and Perl • Was involved in data warehousing data model design to store the historical data in Sybase tables to be used by the prediction algorithm • Designed the object model and was also involved in creating various class diagrams, sequence diagrams and data flow diagrams • Coded prediction algorithm

    Perl, C Programming, Javascript, and XML