Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Q1: Consider you are tasked with implementing a new payroll system that will all

ID: 3710303 • Letter: Q

Question

Q1:

Consider you are tasked with implementing a new payroll system that will allow employees to record time card information electronically and generate pay checks based on the number of hours worked and total amount of sales. it possess a window- based desktop interface to allow employees to enter timecard information, change employee preferences ( such as payment method), enter purchase orders, and create various reports. Every employee can access and edit their own time cards and purchase order from any browser running on organizations intranet.

- which architecture would best suit to implement the above system and why?

-Highlight the advantages of the suggested architecture when compared to other architecture designs.

___________

Q2:

An online shop about to give free vouchers to its customers with the following specifications:

A customer will deserve a 10 S.R. voucher for each 100 S.R. of their spent once the order reaches 500 S.R. or more.

These vouchers have ID and valid for one full year.

Only one voucher can be used at the time.

You are asked to help this shop in writing two pseudocodes: one for giving vouchers and one for using a voucher.

________________

Q3:

You have been introduced to different data storage format such as legacy, relational, object, and multidimensional .

Using your own words, based on what data storge format is chosen.

Support your answer with examples of what each type/ format can provide or support.

_____________

Q4:

In order to ensure that the requirements and the specifications of the system meet the expectations of the signed contract; we can use a software testing.

Which type of testing can we use and what are the steps of this type.

*Please don't copy past, and don't write hand..

Explanation / Answer

Q-1

I think for this type of application the architecture pattern to be used is ‘3-Tier’ Architecture. In addition at UI level we can use MVC (model, View, controller) pattern. The main benefits of using this type of architecture are as follows:

Q-2

Pseudo code for issue of Voucher:

Pseudo code for using Voucher:

Q-3

The main area where each of databases used are as follows:

Relational:

This type of DB stores data in Tables in the form of rows and columns. It stores structured data. This type of Databases is used in system where transactions are happening very frequently like banking system. As the data is being updated we need to keep data integrity among various operations.

Multi-dimensional:

This type of data has more than one dimension. This type of databases is used in system where we need faster retrieval of data and data update happens infrequently or data just added not updated. E.g. data warehouse applications, Analytics applications and Datamarts.

Object:

This type of database is used to store unstructured data. Each object item contains data and actions are used to process data.  Faster retrieval or search of data in this. Object Queries are used to access data.

Legacy:

Used to store unstructured data in the form of various types of files. Difficult to comprehend data and searching of data is very slow. Very different data format like csv, asn.1 , xml etc.

Q-4

In order to ensure that the requirements and the specifications of the system meet the expectations of the signed contract; we can use a software testing.

Which type of testing can we use and what are the steps of this type.

Ans: This type of testing is called system testing. In some cases if this done by users or in front of user it is called user acceptance testing. This is normally  black box testing with test cases corresponding to each of requirements in contract.

Steps: