Find Jobs
Hire Freelancers

Create an sql table with php, I just want the sql and php part done. not the erd

£20-250 GBP

Imefungwa
Imechapishwa over 6 years ago

£20-250 GBP

Kulipwa wakati wa kufikishwa
HeatingSupplies is a home services provider based in the United Kingdom. It is specialised in the on-going maintenance, regular servicing and repairing of boilers and central heating systems in houses all around the country. The initial services provided by HeatingSupplies include a preliminary inspection of the boiler and central heating system, the formulation of a quote for a maintenance contract and the suggestion of a maintenance package for this contract. If a maintenance contract is signed then HeatingSupplies guarantees the servicing of the boiler and central heating installation at regular intervals as well as unlimited cover for breakdowns. Part B Questions You have been hired by HeatingSupplies as a database architect to undertake a database project to support the data needs required by the business processes in the organisation. In this second part, you are given a conceptual data model for HeatingSupplies (figure 3) and your first goal is to map it onto a high-quality LOGICAL RELATIONAL DATA MODEL to logically represent how the key business data needs to be organised as a set of interrelated tables that can then be implemented. These relations need to be interconnected according to the strict rules of the relational model to be implementable. You also have to produce an executive report to justify your mapping. Subsequently, you have to create two of the tables in the MySQL RDBMS and create a simple PHP script to add data into it and retrieve data from it. 6) Produce a complete Logical Entity-Relationship Diagram for HeatingSupplies. This needs to include all the correct relations, relationships, multiplicity constraints, attributes, primary keys and foreign keys. This needs to fit on one page of the report. 7) Provide an executive summary of how you produced the HeatingSupplies logical ERD i.e. how you mapped the HeatingSupplies conceptual ERD into a full logical relational schema. In other words, you need to refer to the Logical Data Modelling Methodology and explain in a written narrative in the first person what you need to do to resolve each relationship and derive the relevant relations (i.e. tables) with all their attributes, primary keys and foreign keys. This needs to fit on no more than two pages of the report. 8) Write some SQL code (DDL) to create the Customer table (individual customer) and the Property table in the MySQL RDBMS. The table names should be preceded with your initial e.g. FR_Customer and FR_Property. No field should be left empty. Both tables should have primary keys and Property should have one foreign key. Both the code and screenshots of the structure of the tables should be included. The screenshots should show your student id number (right above the structure of the table). This needs to fit on no more than two pages of the report. 9) Create a simple PHP file called [login to view URL] to display a Web-based form to allow an administrator to enter the details of new customers onto the Customer table in the MySQL RDBMS. Both the code and a screenshot of the Web page should be included. The screenshot should show your student id number (in the URL bar). This needs to fit on one page of the report. Ideally, your form should look like the one on figure 1. 10) Create a simple PHP file called [login to view URL] to display a Web-based confirmation page displaying the added customer. Your page should ideally show the last added customer and also a customer added previously. Both the code and a screenshot of the Web page should be included. The screenshot should show your student id number (in the URL bar). This needs to fit on no more than two pages of the report. Ideally, your form should look like the one on figure 2.
Kitambulisho cha mradi: 15733304

Kuhusu mradi

14 mapendekezo
Mradi wa mbali
Inatumika 6 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
14 wafanyakazi huru wana zabuni kwa wastani £133 GBP kwa kazi hii
Picha ya Mtumiaji
I will do SQl and PHP part. I will convert it also Relevant Skills and Experience SQL and PHP Proposed Milestones £250 GBP - cost
£250 GBP ndani ya siku 3
4.7 (224 hakiki)
8.5
8.5
Picha ya Mtumiaji
I am a full time developer and have high skills in ERD and SQL so I can complete this project. My price and time is negotiable. Let's discuss details via chat. I'll provide best service. Relevant Skills and Experience ERD SQL MySQL/Oracle/MSSQL/PostrgreSQL Proposed Milestones £150 GBP - done
£150 GBP ndani ya siku 3
4.9 (291 hakiki)
8.0
8.0
Picha ya Mtumiaji
I have 8+ years experience in web / ios fields,and 3+ years of experience in private company having 500+ employee as a Technical Team leader . Relevant Skills and Experience php , wordpress , joomla , magento , shopify, prestashop, opencart ,woocommerce,zend , symphony , codeignator , drupal , html5, node js,jquery,mysql ,payment gateway ,ios Proposed Milestones £127 GBP - cost
£127 GBP ndani ya siku 3
5.0 (43 hakiki)
6.1
6.1
Picha ya Mtumiaji
Hi, I have reviewed your requirement and i find this quite interesting, Overall I feel myself fit for your requirement, we can discuss all things in detail once. I would like to work on this project. Relevant Skills and Experience We are team of 30+ team players. from those we have best MySQL, Codignator & PHP developers with 5+ years of experience in high level web application, Plugin Editing, Customization & Development. Proposed Milestones £83 GBP - Milestone 1 I can start work immediately, Once you awarded the project & provided login credentials
£83 GBP ndani ya siku 2
4.9 (176 hakiki)
6.4
6.4
Picha ya Mtumiaji
Hi, I have reviewed your requirement and I can do this job as per your requirement. We have huge expertise in WORDPRESS , Laravel, Node.Js , React.Js, CakePHP, Codeigniter, Angular.js, Bootstrap, API Integration, Plugins , MYSQL, JavaScript, HTML, Jquery, Magento, HTML 5 ,YII frame, PSD to HTML and CSS to name a few. We have built more than 200 website in Magento and WordPress including theme and customized theme as well. I am looking for long term work relationship from you. Looking forward for your positive response. For more reference please see portfolio herewith. Regards Jitendar
£150 GBP ndani ya siku 3
4.6 (40 hakiki)
6.0
6.0
Picha ya Mtumiaji
I am an experienced professional in this field for about 3 years. I have done so many large scaled and medium scaled PHP MySQL projects. I too have worked with ERP system for diamond industry. I can surely deliver you a quality work within your time frame.
£111 GBP ndani ya siku 3
5.0 (18 hakiki)
5.5
5.5
Picha ya Mtumiaji
A proposal has not yet been provided
£20 GBP ndani ya siku 1
4.4 (151 hakiki)
4.7
4.7
Picha ya Mtumiaji
Hi I am a hunter of php and mysql. I have read all requirements and ready to start this job ASAP. Please hire me I am ready to start this as well as sitting in the front of laptop for start this job and trust me I will complete this project within 4 hours only. Please give me chance. Thanks and Regards Kiran Relevant Skills and Experience My skills are : PHP, HTML, CSS3, JAVASCRIPT, JQUERY, MTSQL, BOOTSTRAP , AJAX and CMS (WordPress, magento, drupal) frameworks(codeiginiter, laravel and more.) Proposed Milestones £150 GBP - on completion
£111 GBP ndani ya siku 1
4.5 (13 hakiki)
3.7
3.7
Picha ya Mtumiaji
I did similar work for another client few weeks ago (I can show it in chat). Also being software engineering student my knowledge is fresh about database concepts along with web. Relevant Skills and Experience erd, logical mapping, normalization etc. I use MySQL workbench to make schema and PHPmyadmin to integrate PHP with MySQL. Proposed Milestones £250 GBP - Complete task Just chat me one so that I can show my demo work I did in past.
£250 GBP ndani ya siku 5
4.4 (2 hakiki)
3.4
3.4
Picha ya Mtumiaji
A proposal has not yet been provided
£133 GBP ndani ya siku 2
3.3 (8 hakiki)
3.6
3.6
Picha ya Mtumiaji
Hello, I have reviewed your requirement and we have skilled team for sql database table. Look forward to hearing you. Thanks
£222 GBP ndani ya siku 12
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
A proposal has not yet been provided
£55 GBP ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED KINGDOM
United Kingdom
0.0
0
Mwanachama tangu Nov 26, 2017

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.