Question $4$

EFG Software Ltd is a large software house which specialises in developing an enterprise system consisting of various software packages which are integrated for the academic environment. The enterprise system will cover many aspects of the institution of higher learning suitable for colleges and universities. The popular modules covered include: admission, bursary, students affairs, examination, library, academic faculties, real estate maintenance, landscaping and gardening, transportation, and etc.

a$)$ The two popular types of User Acceptance Tests are Alpha Test and Beta Test. Using the following presentation format, differentiate between Alpha and Beta Test.

$\backslash$table$[[$Differences$,$Alpha Test,Beta Test$],[$Test for whom,,$],[$Test carried out by$,,],[$Location of Test,,$]]$

$(6$ marks$)$

b$)$ EFG Software Ltd will be conducting a Load Test for the enterprise system before selling to the various Colleges and Universities. Describe TWO $(2)$ main benefits of conducting a Load Test with an automated testing tool.

$(6$ marks$)$

c$)$ The following represents part of the facts gathered during an interview about a University Library System.

A student may make zero, one or many borrowings. A borrowing belongs to a particular student.

Each borrowing contains one or many books. A particular book may be borrowed one or many times.

When a book is not found in the library, a student may make one or many reservations. Each reservation belongs to a student.

Using the standard notation, draw an entity$-$relationship diagram $($ERD$)$ for the above scenario. You are NOT required to resolve any many$-$to$-$many relationships between the entities.

$(7$ marks$)$

d$)$ By using the Database Design Language $($DBDL$)$ format, identify the relevant data attributes for STUDENT and BORROWING entities. Show clearly both the primary and foreign keys. Example of a DBDL format: PAYMENT $($Payment No$.,$ Date, Amount, Invoice No$.*).$

$(6$ marks$)$