PROBLEM STATEMENT

LAB NUMBER: 04

Consider the project database designed and implemented during previous semester i.e. Fall 2024. Its implementation was done using structured query language during previous semester. Try to recall major relations in your project database. You already have its report in printed form.
(i) Create a database of appropriate size using SSMS.
(ii) Create a user and set its authorizations to access the newly created database.
(iii) Using query analyzer run the SQL script to recreate your project tables and populate with data.
Alternate option: Otherwise restore your project database.
(iv) Create a website project using a blank folder as demonstrated in class.
a. Add a web form with separate code to the project.
b. Test the web form by running it in browser.
c. Write code to retrieve data from any of your project table. Display at least first five records of any relation in browser.