Database and the web
Budget: $30 – $250 USD
Looking for assistant with the following project
You are a freelance full-stack developer responsible for implementing a database and a dynamic web application for the home insurance database. You are required to implement the dynamic web application called "Insure my home" with access to a database as described below.
Each line shows a table with its properties, TableName (column1, column2, …), and the primary and foreign keys are underlined. The first column in each table is a primary key and other underlined column names are foreign keys referring to the column with the same name in another table. ‘customer_id’ in the ‘Claim’ table is a foreign key referring to the primary key ‘customer_id’ in the ‘Customer’ table.
Customer (customer_id, name, address, property_id, property_price)
Claim (report_number, year, customer_id, damage_amount, damage_type)
The database is to be implemented using the MySQL Database Management System (DBMS) or MongoDB.
Your "Insure my home" dynamic web application should include features such as:
Register a user
Login a user
List all customers with specifications of their properties (only available to logged-in users)
Create a customer record (only available to logged-in users)
Report a customer's claim (only available to logged-in users)
Delete a reported claim (only available to admin user)
Update a reported claim (only available to the admin user, include admin username and password in your README file)
Logout a user
The back-end of the web application could be MongoDB or MySQL.
So you need your own model (backend data structure), your own operations on that model, and the ability to access those operations through the web.
Detailed criteria for your app (requirements list)
It is a Node.js app
There is a home page with links to all other pages
There is a register page
There is a user authentication page (i.e. logins)
There is a "add customer page" (available only to logged-in users) for each customer store customer_id, name, address, property_id, and property_price in the database.
There is a "report a claim" page (available only to logged-in users) for each claim store report_number, year as well as customer_id, damage_amount, and damage_type.
There is an 'update reported claim' page (available only to logged-in users, you can go beyond this requirement by making it available only to ADMIN users)
There is a delete reported claim page (available only to logged-in users, you can go beyond this requirement by making it available only to ADMIN users))
There is a "list page", listing all customers and the specification of their properties and any claim they have been involved in.
All forms have validations
There are useful feedback messages to the user
It has a database backend that implements CRUD operations (the database can be MySQL or MongoDB)
The create & update operations take input data from a form or forms (available only to logged-in users)
The login process uses sessions
There is a way to logout
There are links on all pages to the home page providing easy navigation for users
You are a freelance full-stack developer responsible for implementing a database and a dynamic web application for the home insurance database. You are required to implement the dynamic web application called "Insure my home" with access to a database as described below.
Each line shows a table with its properties, TableName (column1, column2, …), and the primary and foreign keys are underlined. The first column in each table is a primary key and other underlined column names are foreign keys referring to the column with the same name in another table. ‘customer_id’ in the ‘Claim’ table is a foreign key referring to the primary key ‘customer_id’ in the ‘Customer’ table.
Customer (customer_id, name, address, property_id, property_price)
Claim (report_number, year, customer_id, damage_amount, damage_type)
The database is to be implemented using the MySQL Database Management System (DBMS) or MongoDB.
Your "Insure my home" dynamic web application should include features such as:
Register a user
Login a user
List all customers with specifications of their properties (only available to logged-in users)
Create a customer record (only available to logged-in users)
Report a customer's claim (only available to logged-in users)
Delete a reported claim (only available to admin user)
Update a reported claim (only available to the admin user, include admin username and password in your README file)
Logout a user
The back-end of the web application could be MongoDB or MySQL.
So you need your own model (backend data structure), your own operations on that model, and the ability to access those operations through the web.
Detailed criteria for your app (requirements list)
It is a Node.js app
There is a home page with links to all other pages
There is a register page
There is a user authentication page (i.e. logins)
There is a "add customer page" (available only to logged-in users) for each customer store customer_id, name, address, property_id, and property_price in the database.
There is a "report a claim" page (available only to logged-in users) for each claim store report_number, year as well as customer_id, damage_amount, and damage_type.
There is an 'update reported claim' page (available only to logged-in users, you can go beyond this requirement by making it available only to ADMIN users)
There is a delete reported claim page (available only to logged-in users, you can go beyond this requirement by making it available only to ADMIN users))
There is a "list page", listing all customers and the specification of their properties and any claim they have been involved in.
All forms have validations
There are useful feedback messages to the user
It has a database backend that implements CRUD operations (the database can be MySQL or MongoDB)
The create & update operations take input data from a form or forms (available only to logged-in users)
The login process uses sessions
There is a way to logout
There are links on all pages to the home page providing easy navigation for users