Closed

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

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 [url removed, login to view] 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 [url removed, login to view] 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.

Skills: Database Administration, HTML, MySQL, PHP, SQL

See more: My logo is attached I just want to look at making some small changes too it and designing a business card with the following. Jo, i just want to write about my first day at a new school introduction, i just want a sodding drink translation, php mysql multiple queries in one string, mysqli_query multiple statements, php mysqli multi query, mysqli_multi_query not working, mysqli_real_escape_string, mysql multi query in php, php mysql multiple queries one connection, mysqli multi query update, i just want a consulation with a designer to give me some ideas, i just want to join twitter, php create sql table csv, create option table php, sql php create table, create sql table php, installation create table sql php script, create sql table, sql table php

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #15733304

16 freelancers are bidding on average £129 for this job

fattahaabdul

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 in 3 days
(101 Reviews)
7.9
liangjongai

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 More

£150 GBP in 3 days
(129 Reviews)
6.4
ownmyserver

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 a More

£83 GBP in 2 days
(162 Reviews)
6.2
enriquethumar

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 , shopi More

£127 GBP in 3 days
(33 Reviews)
5.6
jiitendra

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, Pl More

£150 GBP in 3 days
(26 Reviews)
4.6
£150 GBP in 3 days
(8 Reviews)
3.5
jomingeorge94

Hi, I am web developer experienced in designing and developing websites for my own projects as well as for clients. I have just graduated from Newcastle University studying Bsc Computer Science. I have seen your pos More

£50 GBP in 1 day
(9 Reviews)
3.4
mayankinnovative

A proposal has not yet been provided

£20 GBP in 1 day
(25 Reviews)
2.7
WhatTechnologies

A proposal has not yet been provided

£133 GBP in 2 days
(6 Reviews)
3.3
truss712

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 More

£111 GBP in 3 days
(2 Reviews)
1.5
UsamaIshfaq

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, lo More

£250 GBP in 5 days
(1 Review)
1.1
£150 GBP in 3 days
(1 Review)
0.8
kirandadra91

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 More

£111 GBP in 1 day
(1 Review)
0.9
shaya1

Hello, I have reviewed your requirement and we have skilled team for sql database table. Look forward to hearing you. Thanks

£222 GBP in 12 days
(0 Reviews)
0.0
shivambhateja

Dear Sir, I have been in this industry for 3 years and have developed many projects in angular. This is my first time on this site and hence you can see that I do not have any ratings/testimonials to show you. I can as More

£55 GBP in 2 days
(0 Reviews)
0.0
yassen155

A proposal has not yet been provided

£55 GBP in 1 day
(0 Reviews)
0.0