1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 01-Apr-2023 14:38 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
Arabic female voice over artist required
Category: Arabic Translator, Voice Artist
Budget: $2 - $8 USD
01-Apr-2023
09:58 GMT
WordPress Website tweaks
Category: Graphic Design, HTML, PHP, Web Design, WordPress
Budget: $30 - $250 USD
01-Apr-2023
09:57 GMT
P2p okx bot for changing prices
Category: C++, Programming, JavaScript, PHP, Python, Software Architecture
Budget: $30 - $250 USD
01-Apr-2023
09:55 GMT
Content writing - - 3
Category: Article Rewriting, Article Writing, Content Writing, Copywriting, Ghostwriting
Budget: ₹400 - ₹750 INR
01-Apr-2023
09:55 GMT
Background Remove need
Category: Graphic Design, Illustration, Photo Editing, Photoshop, Photoshop Design
Budget: $2 - $8 USD
01-Apr-2023
09:55 GMT
I want a rummy game
Category: Android, Game Design, Game Development, Mobile App Development, PHP
Budget: ₹12500 - ₹37500 INR
01-Apr-2023
09:54 GMT
MinecraftYouTubeKids
Category: After Effects, Photoshop, Video Editing, Video Services
Budget: $8 - $15 USD
01-Apr-2023
09:54 GMT
احتاج الي مصمم مطابخ ومصنع
Category: 3D Design, 3D Modelling
Budget: $30 - $250 USD
01-Apr-2023
09:53 GMT
Yeni Leoni - 01/04/2023 05:40 EDT
Category: Article Writing, Copywriting
Budget: $15 - $25 USD
01-Apr-2023
09:52 GMT
Market Research & Business Plan
Category: Business Analysis, Business Plans, Business Writing, Financial Research, Market Research
Budget: $100 - $250 USD
01-Apr-2023
09:52 GMT
Stone tile 3D model
Category: 3D Modelling, 3D Rendering, 3ds Max, Rhino 3D
Budget: $30 - $250 USD
01-Apr-2023
09:52 GMT
Native Creative Content Writer for Website and Blog with Sales Pitch Expertise
Category: Article Writing, Content Writing, Copywriting, Creative Writing, Proofreading
Budget: $25 - $50 USD
01-Apr-2023
09:52 GMT
Creative design
Category: Graphic Design, Logo Design, Photoshop, Video Editing, Video Services
Budget: ₹1500 - ₹12500 INR
01-Apr-2023
09:52 GMT
Ghost Writer Fertility Book
Category: Book Writing, Copywriting, EBooks, Ghostwriting, Technical Writing
Budget: $1500 - $3000 USD
01-Apr-2023
09:51 GMT
Physical wooden model made to scale
Category: 3D Modelling, Arts & Crafts, Carpentry, Interior Design, Interiors
Budget: £20 - £250 GBP
01-Apr-2023
09:49 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)

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