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
