1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 28-Mar-2023 12:14 GMT
View Project
View this project in detail (Note: you will be redirected to external marketplace)
Project title: data driven web application makes use of external API's & local data storage to interest in twinning
Posted by: External project from Upwork
Started: 01-Feb-2023 17:44 GMT
Description: To build a data driven web application that makes use of external API's and local data storage to encourage interest in twinning.

The two twin cities I want are LONDON AND BEIJING

1. Database Design and Implementation

i) Conceptual ER model: There is a host of data items associated with each city. Design a conceptual ER model to hold data about individual cities (name, country, population, geo-location, woeid, currency etc.) as well as places of interest in those towns/cities like stadiums, cinemas, concert halls, universities, cathedrals, railway & bus stations, airports etc. (name, type, capacity, geo-location, photos etc.).

Assignment:  Deliverable: Conceptual ER model (Entities, Attributes, Relationships) with at least 4 entities & sufficient attributes. At least 8 attributes for a city/town and 8 for places of interest in those cities/towns).

ii) Logical ER model: Transform the above model resolving any many-to-many relationships into a low-level (relational) model showing all Primary and Foreign Keys as well as all attribute types with their ranges/lengths.

assignment: Deliverable: Logical (low-level) ER Model.

iii) Database Implementation: Implement & populate the database on your MySQL server.

Assignment: Deliverable: Database Schema (create table + constraints statements) + Data (select * from all tables).


2. Use and integration of external API's (18 marks):

i) Mapping: Use a mapping API to display (at least two) maps showing the cities you have selected.

Note that 6(+) places of interest should be shown on each map using appropriate icons. MouseOver on the icons should show (some) data drawn from your dataset. MouseClick on icons should load another page showing details (photos, description etc.) of a specific point of interest drawn from Wikipedia or other external resource or your own database.

Assignment:  Deliverable: Maps of cities with icons showing places of interest and their details.


ii) Weather: Use a weather API to generate a display of the current and forecast weather for the your selected city and its twins.

assignment  Deliverable: Display current and forecast weather data.


3.Configuration file

i) Design, construct and make use of a configuration file holding application-wide data such as API's used, API keys (if used), database and other configuration data.  

Assignment: Deliverable: A configuration file.


4. RSS feed

Generate a RSS feed of the dataset held in your MySQL DB. The data should show all current data regarding your cities and places of interest currently held in the database.

Assignment:  Deliverable: A working & demonstrated RSS feed.


5. Design and Code Review/Walkthrough (10 marks):

A 15-20 minute walkthrough of the design and coding of the application. Marks are allocated as part of the assessment process.

Assignment:  Deliverable: A walkthrough of the work undertaken with all group members present.


Budget: $185

Posted On: February 01, 2023 17:44 UTC
Category: Full Stack Development
Skills:API Integration, Database Development, Web Application, PHP, API, MySQL, Web Development, Python, JavaScript

Skills: API Integration, Database Development, Web Application, PHP, API, MySQL, Web Development, Python, JavaScript
Country: United Kingdom

click to apply
Project ID: 3308281
Project category: API Integration, Database Development, Web Application, PHP, API, MySQL, Web Development, Python, JavaScript
Project budget: $185
View this project in detail (Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
Extracting audio path and subtitles from DVD (Python)
Category: Audio Processing, Python, Software Architecture, Video Processing
Budget: £10 - £20 GBP
28-Mar-2023
10:04 GMT
Abaqus flange model
Category: 3D Modelling, Abaqus, Engineering, Finite Element Analysis, Mechanical Engineering
Budget: £10 - £20 GBP
28-Mar-2023
10:02 GMT
Publish themeforest wordpress site template
Category: HTML, Web Design, WordPress
Budget: $15 - $25 USD
28-Mar-2023
10:00 GMT
PDF to MS Excel with Charts
Category: Data Entry, Data Processing, Excel
Budget: $30 - $250 USD
28-Mar-2023
09:59 GMT
Operating Systems Project
Category: C, Programming, C++
Budget: $30 - $250 USD
28-Mar-2023
09:58 GMT
Website content writing
Category: Article Writing, Content Writing, Copywriting, Ghostwriting, SEO
Budget: $2 - $8 USD
28-Mar-2023
09:58 GMT
connect security onion on VM and ping to Kali Linux
Category: Computer Security, Internet Security, Linux, System Admin
Budget: $10 - $30 AUD
28-Mar-2023
09:58 GMT
Build me a website like dream 11
Category: Graphic Design, HTML, PHP, Web Design, WordPress
Budget: ₹500000 - ₹1000000 INR
28-Mar-2023
09:58 GMT
Mailroom PO BOX web service
Category: HTML, PHP, Software Architecture, Web Security, Web Design
Budget: $250 - $750 CAD
28-Mar-2023
09:57 GMT
Quick dnd character art
Category: Digital Art, Digital Design, Drawing Artist
Budget: $10 - $30 USD
28-Mar-2023
09:56 GMT
Make pictures with product
Category: English (US) Translator, Excel, Graphic Design, Photography, Virtual Assistant
Budget: €6 - €12 EUR
28-Mar-2023
09:55 GMT
Build wordpress with woocommerce site from Figma design
Category: Figma, WooCommerce, WordPress
Budget: $30 - $250 USD
28-Mar-2023
09:54 GMT
Corrección literaria
Category: Article Writing, Content Writing, Copywriting, Research Writing
Budget: €30 - €250 EUR
28-Mar-2023
09:54 GMT
ver contenido -- 3
Category: Android, IPhone
Budget: €8 - €30 EUR
28-Mar-2023
09:54 GMT
Online Travel Booking Engine Project
Category: Flutter, HTML, Laravel, MySQL, PHP
Budget: $250 - $750 USD
28-Mar-2023
09:54 GMT
Browse All Projects
Projects by Skills ...
Projects for 'android'
Projects for 'ajax'
Projects for 'asp'
Projects for 'aspnet'
Projects for 'cms'
Projects for 'cpp'
Projects for 'csharp'
Projects for 'css'
Projects for 'delphi'
Projects for 'design'
Projects for 'drupal'
Projects for 'excel'
Projects for 'facebook'
Projects for 'flash'
Projects for 'html'
Projects for 'java'
Projects for 'javascript'
Projects for 'joomla'
Projects for 'iphone'
Projects for 'mysql'
Projects for 'photoshop'
Projects for 'php'
Projects for 'python'
Projects for 'ruby'
Projects for 'seo'
Projects for 'sql'
Projects for 'sysadm'
Projects for 'translate'
Projects for 'typing'
Projects for 'twitter'
Projects for 'vbnet'
Projects for 'xml'
Projects for 'wordpress'
Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android'
RSS feed for 'ajax'
RSS feed for 'asp'
RSS feed for 'aspnet'
RSS feed for 'cms'
RSS feed for 'cpp'
RSS feed for 'csharp'
RSS feed for 'css'
RSS feed for 'delphi'
RSS feed for 'design'
RSS feed for 'drupal'
RSS feed for 'excel'
RSS feed for 'facebook'
RSS feed for 'flash'
RSS feed for 'html'
RSS feed for 'java'
RSS feed for 'javascript'
RSS feed for 'joomla'
RSS feed for 'iphone'
RSS feed for 'mysql'
RSS feed for 'photoshop'
RSS feed for 'php'
RSS feed for 'python'
RSS feed for 'ruby'
RSS feed for 'seo'
RSS feed for 'sql'
RSS feed for 'sysadm'
RSS feed for 'translate'
RSS feed for 'typing'
RSS feed for 'twitter'
RSS feed for 'vbnet'
RSS feed for 'xml'
RSS feed for 'wordpress'
RSS feed for 'writing'
New!
Проекты на русском
(Projects in Russian)

Long URL:
www.1001freelanceprojects.com
Mobile version:
m.1001fp.com
Copyright © 2005-2022 1001 Freelance Projects