i) Conceptual ER model: There is a host of data items associated with each town or city. Design a conceptual ER model to hold data about individual towns and 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). (4 marks)
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. (4 marks)
iii) Database Implementation: Implement & populate the database on your MySQL server.
Assignment: Deliverable: Database Schema (create table + constraints statements) + Data (select * from all tables). (4 marks)
2. Use and integration of external API's (18 marks):
i) Mapping: Use a mapping API to display (at least two) maps showing the towns/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 towns/cities with icons showing places of interest and their details.(10 marks)
ii) Weather: Use a weather API to generate a display of the current and forecast weather for the your selected town/city and its twins.
assignment Deliverable: Display current and forecast weather data. (8 marks)
3.Configuration file (10 marks):
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. (10 marks)
Assignment: Deliverable: A configuration file. (10 marks)
4. RSS feed (10 marks):
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. (10 marks)
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. (10 marks)
Hourly Range: $25.00-$45.00
Project ID:
3303362
Project category:
JavaScript, PHP, Web Development, Web Application, HTML, Web Design, HTML5, API, MySQL, CSS
