Create a database in sql server or in access or in any


Context of the Assignment:

The main goal of this assignment is to understand how to design and implement an object- oriented system by applying sound object-oriented design disciplines. The students will design, implement, test and document a Swing application that provides an interface to a database developed using any chosen database software. They will also do same to develop a client/server application using socket programming.

Assignment Purpose:

1. Understanding the scenarios and creating a Swing application and a client/server application using JAVA.

2. Use advanced features and techniques of object oriented programming appropriately, including Swing, Database connectivity and socket programming.

Scenario 1

You have been tasked in developing an interactive system to help small children to carry out simple calculations on circles such as area of the circle and perimeter of the circle given the radius. The system should have a good user interface for entering the radius with the options of selecting any of the three operations: area to calculate the area, perimeter to calculate the perimeter or clear to remove of contents from the text fields. The chosen operation will be carried out and the result will be displayed in a text field on the same interface. At the same time, a message will also be displayed on the interface informing the user which operation was selected. The design of interface is given below.

Use the following diagram to understand the Interface.

Task 2: Design the application described above using Java Swing

Scenario 2 You have asked develop an interactive system for a small money changer to provide on-line currency conversions from Omani Riyals to several other currencies to its customers. The system will provide a client service for entering an amount in OMR and the required currency name and forward the inputs to the server. The server will check the entered currency name and search for its exchange rate from a database storing the currency name and exchange rate. The exchange rate found will be used to do the conversion and then sent back to the client both the exchange rate and the conversion result or appropriate error message will be sent back if not found.

Develop a client/server application to implement this system with the following tasks:

Task 3: Create a database in SQL server or in Access or in any other RDBMS: Create a small database and create a table having two fields: Currency Name and Exchange Rate. Insert some data (at least five records).

Task# 4 Client side program:

The client program will accept from a user an amount in OMR and a currency name and send the request for the conversion to the server.

Task# 5 Server side program: Develop a server side program which will do the following:

(i) Make connection to the database
(ii) Retrieve the data from the table to match the currency name
(iii) If match is found, then send the exchange rate and conversion result to the client
(iv) If match is not found, then send an appropriate error message
(v) Close the connection with the database and client

Solution Preview :

Prepared by a verified Expert
Computer Networking: Create a database in sql server or in access or in any
Reference No:- TGS01205311

Now Priced at $140 (50% Discount)

Recommended (99%)

Rated (4.3/5)

A

Anonymous user

3/8/2016 2:55:30 AM

The main objective of the given assignment is to comprehend how to design and apply an object-oriented system. Via applying the concepts, perform the following tasks: Q1. Prepare a database in SQL server or in Access or in any other RDBMS: Prepare a small database and form a table having two fields: Currency Name and Exchange Rate. Insert some data at a minimum of five records). Q2. Server side program: Build up a server side program that will do the following: a) Create connection to the database b) Recover the data from the table to match the currency name c) If match is found, then send the exchange rate and conversion outcome to the client d) If match is not found, then send a suitable error message e) Close the connection by means of the database and client