please create a Flask application that connects to a MySQL

database to add, view, update, and delete data :$)$

Database Context: Network Device Managment

Database Name: network management db

Tables and Descriptions:

Table: devices

Description: Contains details about network devices managed

by the system.

Fields:

device id $($Primary Key, Integer, Auto Increment$)$

device name $($Varchar$)$

ip address $($Varchar$,$ Unique$)$

device type $($Varchar$)-$ e$.$g$.,$ Router, Switch, Firewall

location $($Varchar$)$

status $($Varchar$)-$ e$.$g$.,$ Active, Inactive, Under

Maintenance

Table: network logs

Description: Stores logs of network events or changes.

Fields:

$log$ id $($Primary Key, Integer, Auto Increment$)$

device id $($Integer$,$ Foreign Key to devices device id$)$

timestamp $($DateTime$)$

$log$ description $($Text$)$

Table: maintenance records

Description: Records maintenance activities for each device.

Fields:

record id $($Primary Key, Integer, Auto Increment$)$

device id $($Integer$,$ Foreign Key to devices device id$)$

maintenance date $($Date$)$

details $($Text$)$

technician name $($Varchar$)$

Table: users

Description: Contains user accounts who can access or modify the

network device data.

Fields:

user id $($Primary Key, Integer, Auto Increment$)$

username $($Varchar$,$ Unique$)$

password hash $($Varchar$)$

role $($Varchar$)-$ e$.$g$.,$ Admin, Technician, Viewer

email $($Varchar$,$ Unique$)$

Relationships:

devices to network$\_$logs: One$-$to$-$Many $($One device can have

multiple logs$)$

devices to maintenance records: One$-$to$-$Many $($One device can

have multiple maintenance records$)$

CRUD Operations Examples:

Create: Add new network devices, log entries, maintenance records,

or users.

Read: View device details, logs$,$ maintenance history, or user profiles.

Update: Modify device information, update maintenance records, or

change user roles.

Delete: Remove devices, logs$,$ maintenance records, or user account