Question 1:
Diddy Kong has titles as reported at URL https://en.wikipedia.org/wiki/Diddy_Kon g . A
company has approached you to make use of these titles using VB .Net
programming. Adopt samples from the Wikipedia as your dataset, and answer the
following questions.
a) Create a valid database script (for Microsoft SQL Server) to store the following
fields in a table object for all titles of Diddy Kong (as sample data).
i) Title Name
ii) Release Year
iii) Release Month
iv) Game Platforms
v) Designers
b) What is the SQL statement to select all fields except records in release year of
2012 and 2018?
c) What would be the SQL statement to update field of Game Platform as
'PlayStation' on those records after the release year of 2012?
d) How to remove all records using the SQL statement in your created table object?
e) Develop a Windows Form App / WPF application with VB .Net to display and
manipulate (able to add, edit/update and delete) all your records from the created
table object. Obtain the sample data (as your records) from the URL
https://en.wikipedia.org/wiki/Diddy_Kon g .
[60 marks]
Question 2:
Adopt the created database script as in Question 1 a), and develop a ASP .Net web
application using VB .Net to display and manipulate (able to add, edit/update and
delete) all your records.