Question 2>
(7 points)
You are given a database as following structure:
Sale Order
Column Name
Data Type
Allow Nulls
id
int
created by
date
varchar(150)
date
0000
Account
Column Name
username
Data Type
varchar(150)
Allow Nulls
password
varchar(150)
displayname
varchar(150)
0000
Product
Column Name
P
name
price
Data Type
Allow Nulls
varchar(150)
fost
0000
Sale OrderProduct
Column Name
Data Type
Allow Nulls
sid
pid
quantity
saleprice
float
foat
00000
Your task is to develop a web application that allows users toadd a new sale order. The needed web pages are described in the below table:
Page
Login page
Insert Page
Access URL
/login
/insert
Description
Allow users to authenticate to the system
Allow authenticated users to add new sale order.
Note: URL to access the pages are VERYIMPORTANT, wrong URLs lead the examiners cannot access your developed features. You will receive a ZERO for any wrong URLs.
The [Login page] requires:
The [Login page] should display as the following (0.5 point):
Username:
Password:
Login
