CASE ONE Pequa Gallery (PG) is an art management company that manages and tracks antique and valuable art collectibles across the globe. Generally they track and manage paintings and photographs that are purchased by art collectors directly from the artists or from art auctions and in turn lent/rent these paintings out on behalf of their owners/collectors, to museums and arts exhibitors for a fee. For each painting, PG keeps information on the artist, the art and the owner/collector. For each artist, information kept usually will include the Name, age, gender, address, phone number, etc. For each art, the information stored include the name, the type (oil painting, water painting, photo etc.), Commissioning date, etc. and for the collector, Name, location, phone number, etc., are stored. Due to the large volumes of arts currently in their possession, they are looking for ways to aid the effective management of these arts. At the last management meeting, management took a firm decision to acquire a database system to improve their record keeping processes. Also, PG over the years has invested into Microsoft technologies and as such would like this system developed using Visual Basic.Net, with a Microsoft DBMS such as Access OR MS SQL server to be used. Finally, it was decided that the connection string as well as other connection object must be coded manually (Hard coded). Thus, a Connection Wizard should NOT be used to create the connection to the database since it may restrict control over the program. The structure of the database is shown on figure 1. Use this case to answer the following questions. Page 2 of 5 Search... Q Tables APPOINTMENT_TB CLIENT_TB COUNSELOR_TB COUNSELOR_TB 7 D_ID FirstName LastName Date Of Birth Gender Contact Number Department Email Arrival Departure Speciality APPOINTMENT_TB * Appointment_ID P_ID D_ID DateOfAppointment Time Details CLIENT_TB PID FirstName LastName DateOfBirth Age Gender Address Email Nationality Enrolled Date Question Two [25 Marks] a. Using the Database structure in figure 1, create a database in Microsoft Access OR Microsoft SQL Server and populate each table with at least fifteen (15) appropriate records. Then, you are required to design an appropriate user interface, connect it to the database, retrieve and display all Artist records in a DataGridView control on the interface. [9 Marks/ b. Create functionalities for a user to be able to ADD new Records to the database, Delete and Update Existing Records (using appropriate user interfaces). [8 Marks c. Create a function in your program that will enable a user to search for a collector, and if the collector is found, the user can then select it to display details of the collector as well as the list of all the Arts/painting owned by that collector on a new window. 18 Marks] Page 3 of 5 Question Three [20 Marks] PG has decided to modify the software to make it possible for users to access the system online. Again it is decided that the ASP.NET should be the the web programming language: a. Using the Database created in 2 (a), you are required to create a website/web App, design an appropriate webpage, connect it to the database, retrieve and display all Collector records in a Grid View control on the Webpage. [10 Marks/ b. Create a functionality in your web App that will enable a user to search for an Artist, and if the Artist is found, the user can then select it to display details of the Artist as well as the list of all the Arts/painting created by that artist on a new webpage. [10 Marks) CASE ONE Pequa Gallery (PG) is an art management company that manages and tracks antique and valuable art collectibles across the globe. Generally they track and manage paintings and photographs that are purchased by art collectors directly from the artists or from art auctions and in turn lent/rent these paintings out on behalf of their owners/collectors, to museums and arts exhibitors for a fee. For each painting, PG keeps information on the artist, the art and the owner/collector. For each artist, information kept usually will include the Name, age, gender, address, phone number, etc. For each art, the information stored include the name, the type (oil painting, water painting, photo etc.), Commissioning date, etc. and for the collector, Name, location, phone number, etc., are stored. Due to the large volumes of arts currently in their possession, they are looking for ways to aid the effective management of these arts. At the last management meeting, management took a firm decision to acquire a database system to improve their record keeping processes. Also, PG over the years has invested into Microsoft technologies and as such would like this system developed using Visual Basic.Net, with a Microsoft DBMS such as Access OR MS SQL server to be used. Finally, it was decided that the connection string as well as other connection object must be coded manually (Hard coded). Thus, a Connection Wizard should NOT be used to create the connection to the database since it may restrict control over the program. The structure of the database is shown on figure 1. Use this case to answer the following questions. Page 2 of 5 Search... Q Tables APPOINTMENT_TB CLIENT_TB COUNSELOR_TB COUNSELOR_TB 7 D_ID FirstName LastName Date Of Birth Gender Contact Number Department Email Arrival Departure Speciality APPOINTMENT_TB * Appointment_ID P_ID D_ID DateOfAppointment Time Details CLIENT_TB PID FirstName LastName DateOfBirth Age Gender Address Email Nationality Enrolled Date Question Two [25 Marks] a. Using the Database structure in figure 1, create a database in Microsoft Access OR Microsoft SQL Server and populate each table with at least fifteen (15) appropriate records. Then, you are required to design an appropriate user interface, connect it to the database, retrieve and display all Artist records in a DataGridView control on the interface. [9 Marks/ b. Create functionalities for a user to be able to ADD new Records to the database, Delete and Update Existing Records (using appropriate user interfaces). [8 Marks c. Create a function in your program that will enable a user to search for a collector, and if the collector is found, the user can then select it to display details of the collector as well as the list of all the Arts/painting owned by that collector on a new window. 18 Marks] Page 3 of 5 Question Three [20 Marks] PG has decided to modify the software to make it possible for users to access the system online. Again it is decided that the ASP.NET should be the the web programming language: a. Using the Database created in 2 (a), you are required to create a website/web App, design an appropriate webpage, connect it to the database, retrieve and display all Collector records in a Grid View control on the Webpage. [10 Marks/ b. Create a functionality in your web App that will enable a user to search for an Artist, and if the Artist is found, the user can then select it to display details of the Artist as well as the list of all the Arts/painting created by that artist on a new webpage. [10 Marks)