Website development , Data modelling , small forms Programming
Budget: €8 – €30 EUR
A basic program with the functionality of recording an incident, view all the incidents ,and total amount , View incidents requiring follow up, and the total number of required follow ups.View Stats:
Total Incidents
Total Incidents requiring follow up
Percentage of Public incidents
Persist: A list of all incidents should be saved on application close, and should load when the application first opens.
a relational database for this information. Normalisation is an important part of database design, for reduced duplication,
Part 1: Draw an Entity Relationship Model
a. Identify the main entities from the table and create a relational model
this is very simple and for year 1 of college, just been sick with corona and didn't attend classes for 2 weeks so I'm very behind
b. Identify 3 sensible attributes to each entity (some of these can be identified from the table)
Part 2: Normalize the data to 3NF using the format bellow
Total Incidents
Total Incidents requiring follow up
Percentage of Public incidents
Persist: A list of all incidents should be saved on application close, and should load when the application first opens.
a relational database for this information. Normalisation is an important part of database design, for reduced duplication,
Part 1: Draw an Entity Relationship Model
a. Identify the main entities from the table and create a relational model
this is very simple and for year 1 of college, just been sick with corona and didn't attend classes for 2 weeks so I'm very behind
b. Identify 3 sensible attributes to each entity (some of these can be identified from the table)
Part 2: Normalize the data to 3NF using the format bellow