problem1. The following data are required to be stored by a family physician.

Family#, FamilyAddress, Patient#, PatientName, ServiceCode, ServiceFee, ServiceDate

A family can have numerous patients. A patient belongs to a single family. Each service has a code and a fee. A patient can acquire only one service on a given date.

Illustrate the database design in third normal form for the above data.

problem2. Consider a systems development project with the subsequent data

Activity              Duration (weeks)     Precedence Relationship

1. Software design          2                        -
2. Module 1 Coding        14                       1
3. Module 2 Coding        18                       1
4. Module 3 Coding        15                       1
5. Unit Test 1                2                         2
6. Unit Test 2                3                         3
7. Unit Test 3                1                         4
8. Integration Test         3                     5, 6, 7
9. Systems Test            1                          8
10. Acceptance Test1     2                          9
11. Acceptance Test2     1                          9
12. System Release        1                       10, 11


a) Draw project network.

b) Identify critical activities.

c) What is the least number of weeks needed to complete the project?

d) Among the activities which have a non-zero slack, which is the activity with the least slack?

e). Activities 2, 3, and 4 will have to be done in parallel at least for some duration if the project has to be completed in the least possible time.

A. True
B. False

problem3. Most computer systems authenticate users through asking them for the user name and password. But, the user names and passwords often can be guessed by the hackers. Recommend an automated, preventive control mechanism to deal with the authentication problem.

problem4. Consider a system which has the subsequent UML models:

Use Case for find outTotalProjectCost

Trigger: End of each month

Normal Flow of Events

For each project in the project data file, DO
Set TotalProjectCost = 0
For each employee who worked in project, DO
        TotalProjectCost = TotalProjectCost + HourlyRate*HoursWorked
Print Project#, TotalProjectCost

Data Dictionary

Project data = Project# + Name + BeginDate + EndDate + {Emp# + HoulrlyRate + HoursWorked}

In the above design the total cost of a project is broken down in employee costs. For best cost control, the management wants the total cost to be broken down in activity costs also. For illustration, if the project needs two activities, programming and design, then the costs for the design activity and the programming activity are also needed. Show the revised Use case description and data dictionary to create the new cost report. Make any additional assumptions required.

problem5. Develop (i) a context diagram, and (ii) a use case diagram to model the subsequent functionalities of an online brokerage house.

eBroker is a discount online broker. An account holder of this brokerage firm can verify the balance in his account; get stock quote, buy stocks or mutual funds, sell stocks or mutual funds, or research about a stock or a mutual fund. The account holder must log in the site using his username and password before he can do any of the above functions. For purchasing or selling stocks, the user gives the number of stocks to purchase or sell and the price. For mutual funds, the user provides only the total amount. Subsequent to a purchase or a sell transaction is done; the system sends a confirmation to account holder’s email address. At the end of every month, the system sends an account statement to every account holder by e-mail. The system sends a hard copy account statement to the account holder’s home address also, if the account holder had requested so.

problem6. Draw the sequence diagram for the subsequent situation of eBroker.

Sell Stock

1. The user enters the password and username
2. The system verifies that the user is an authentic user using information from user database.
3. The user enters the stock symbol.
4. The system displays current price information for the stock.
5. The user enters sale transaction data like number of stocks to sell and price
6. The system verifies whether the user has sufficient number of stocks in his account to sell.
7. The system creates a new sale transaction.
8. The system informs stock exchange regarding the sale transaction.
9. The stock exchange informs the system (eBroker) when the sale is performed.
10. The system updates user’s account.
11. The system terminates sale transaction created in step 7.

Suppose the following classes: stock, sale transaction, account.