CA PRACTICE 1 (SYS FUNDAMENTALS+DATABASES(A1+A2.1-2.14) by HARMEET KAUR | Assessment

In contrast to a full system backup, outline the purpose of a failover system.

Contrast alpha and beta testing

A busy cafe has decided to streamline their business by implementing a software assisted ordering system. The new system will record customer orders at the front counter whereupon they are automatically added to a queue of orders accessed by a barista working at the back of the cafe to fulfill orders uninterrupted.

(a).

State one reason why a queue would be better suited to holding coffee orders than a stack.

[1]

(b).

The new systems holds the price for each type of coffee in an array called ITEMS as follows:

[6]

+--------------+--------------+ | Espresso | 1.20 | | Latte | 2.50 | | Cappuccino | 3.70 | +--------------+--------------+

Coffee orders are held in a queue called ORDERS where each order is a single integer indicating the type of coffee to be made by their respective row index in ITEMS array.

Additionally, a 3x3 2D array called SALES is initially defined as follows:

+--------------+--------------+--------------+ | Espresso | 0 | 0 | | Latte | 0 | 0 | | Cappuccino | 0 | 0 | +--------------+--------------+--------------+

Given ITEMS, ORDERS and SALES, write pseudocode such that column one and column two contain the total number of orders and total income for each coffee type respectively.

For example, the following ORDERS queue:

+-------+-------+-------+-------+-------+ 1 0 1 2 0 +-------+-------+-------+-------+-------+

would result in the following SALES array:

+--------------+--------------+--------------+ | Espresso | 2 | 2.40 | | Latte | 2 | 5.00 | | Cappuccino | 1 | 3.70 | +--------------+--------------+--------------+

(c).

The method rowswap(ARR, ROWA, ROWB) acts on the array ARR provided to swap the row at index ROWA with the row at index ROWB.

[3]

Without using loops, write pseudocode to sort the rows of SALES from lowest to highest total income. The row for the coffee with the highest total income should be at row index 2.

Question 4[1 Mark]

Choose the one option which best describes the World Wide Web (WWW).

(a).

A globally interconnected network of networks

(b).

A way of sharing resources via hypertext and hyperlinks

(c).

A way for data to travel via network protocols

(d).

The internet

Question 5[5 Marks]

Explain how the use of a distributed network, such as the World Wide Web (WWW), may lead to issues around copyright and intellectual property.

Question 6[2 Marks]

Identify one technical factor and one non-technical factor that should be taken into account when planning a new information system for an organisation.

Question 7[6 Marks]

Discuss the social impacts and ethical considerations associated with the use of an embedded citywide surveillance system which constantly monitors public spaces from video cameras installed on street lights and other public infrastructure.

Question 8[1 Mark]

Choose which of the following is not a form of system installation process.

(a).

Legacy changeover

(b).

Pilot running

(c).

Direct changeover

(d).

Parallel Running

Question 9[4 Marks]

Explain the importance of iteration during the design lifecycle process.

Question 10[2 Marks]

Identify two reasons for releasing software updates.

Question 11[1 Mark]

Define the term foreign key.

Question 12[17 Marks]

In diving competitions, divers receive scores out of ten from seven judges for each dive. Each dive is also attributed a degree of difficulty which is a number ranging from 1.2 to 3.8 (inclusive) in one-tenth increments. For example, upon completion of a 2.5 degree difficulty dive, a diver may achieve the following scores: 5.5, 7.5, 5.5, 7.5, 6.5, 5.0, 7.0 These scores are then used to calculate a single final score as follows: - Bubble Sort is applied to the unordered scores to arrange the sequence from lowest to highest: 5.0, 5.5, 5.5, 6.5, 7.0, 7.5, 7.5 - The two lowest / highest scores are disregarded, leaving exactly three scores: 5.5, 6.5, 7.0 (Note: at most two values from each extremity are disregarded, meaning that some equally low/high values may be retained) - The remaining three scores are added together: 5.5 + 6.5 + 7.0 = 19 - Finally, the total is multiplied by the degree of difficulty of the dive to arrive at the final dive score: 19 × 2.5 = 47.5

(a).

Show the result of only the first and second iterations of Bubble sort on the unordered sequence of scores: 5.5, 7.5, 5.5, 7.5, 6.5, 5.0, 7.0

[2]

(b).

Given an array called SCORES containing 7 scores already sorted from lowest to highest as well as a corresponding diving difficulty score called DD, write pseudocode to output the final score.

[3]

An association of professional diving clubs has decided to move their historic diving competition records from a simple spreadsheet into a more sophisticated electronic database solution. Future diving competition results will be entered directly into the new database. The association wishes the new database to accomodate data from affiliated non-diving groups such as swimming clubs. Furthermore, in an effort to more readily share their data with a variety of external organisations worldwide, the association plans to expose their database to the web via a secure API. Consultants hired to implement an appropriate solution for the diving association have differing views - while some suggest a relational database solution, others recommend an object-oriented one.

(c).

Evaluate the use of an object-oriented database as opposed to a relational database for handling the association's data management requirements.

[6]

(d).

With respect to populating the dive association's new database from the old spreadsheets, explain the need for both data validation as well as data verification in an effort to preserve data integrity.

[6]

Question 13[6 Marks]

An association of professional diving clubs has decided to move their historic diving competition records from a simple spreadsheet into a more sophisticated electronic database solution. Future diving competition results will be entered directly into the new database. The association also wishes the new database to accomodate data from affiliated non-diving groups such as swimming clubs.

With respect to populating the dive association's new database from the old spreadsheets, explain the need for both data validation as well as data verification in an effort to preserve data integrity.

Question 14[7 Marks]

An association of professional diving clubs has decided to move their historic diving competition records from a simple spreadsheet into a more sophisticated electronic database solution. Future diving competition results will be entered directly into the new database. The association wishes the new database to accomodate data from affiliated non-diving groups such as swimming clubs. Furthermore, in an effort to more readily share their data with a variety of external organisations worldwide, the association plans to expose their database to the web via a secure API. Consultants hired to implement an appropriate solution for the diving association have differing views - while some suggest a relational database solution, others recommend an object-oriented one.

Evaluate the use of an object-oriented database as opposed to a relational database for handling the association's data management requirements.

Question 15[4 Marks]

DriEv, an Electric Vehicle (EV) rental company, is building an electronic database to manage its EV fleet of electric cars and bikes. DriEv’s electronic database design includes the following schema:

tbl_vehicles(vehicle_id, year, brand, model, type) tbl_rentals(vehicle_id, start_date, days_rented, daily_rate, customer_id) tbl_customers(customer_id, last_name, first_name, email)

Write an SQL insert statement to add a new Tesla Model S vehicle to the database where the vehicle id, brand, model and type are 172737, “Tesla”, “Model S” and “Liftback” respectively (year is not provided).