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

Закрито
Опублікований over 6 years ago

£20-250 GBP

Оплачується при отриманні
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.
ID проекту: 15733304

Про проект

14 пропозицій(-ї)
Дистанційний проект
Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
14 фрілансерів(-и) готові виконати цю роботу у середньому за £133 GBP
Аватарка користувача
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 за 3 дні(-в)
4,7 (224 відгуки(-ів))
8,5
8,5
Аватарка користувача
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 за 3 дні(-в)
4,9 (291 відгуки(-ів))
8,0
8,0
Аватарка користувача
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 за 3 дні(-в)
5,0 (43 відгуки(-ів))
6,1
6,1
Аватарка користувача
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 за 2 дні(-в)
4,9 (176 відгуки(-ів))
6,4
6,4
Аватарка користувача
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 за 3 дні(-в)
4,6 (40 відгуки(-ів))
6,0
6,0
Аватарка користувача
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 за 3 дні(-в)
5,0 (18 відгуки(-ів))
5,5
5,5
Аватарка користувача
A proposal has not yet been provided
£20 GBP за 1 день
4,4 (151 відгуки(-ів))
4,7
4,7
Аватарка користувача
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 за 1 день
4,5 (13 відгуки(-ів))
3,7
3,7
Аватарка користувача
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 за 5 дні(-в)
4,4 (2 відгуки(-ів))
3,4
3,4
Аватарка користувача
A proposal has not yet been provided
£133 GBP за 2 дні(-в)
3,3 (8 відгуки(-ів))
3,6
3,6
Аватарка користувача
Hello, I have reviewed your requirement and we have skilled team for sql database table. Look forward to hearing you. Thanks
£222 GBP за 12 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
A proposal has not yet been provided
£55 GBP за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED KINGDOM
United Kingdom
0,0
0
На сайті з лист. 26, 2017

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.