Question

Problem 1) Banking Application

Consider the application domain of a banking application where you have customers who have one or more accounts of type Checking or Saving. Some of the customers may also have one or more loans that they have taken from the bank. Each loan has a borrowed amount and current balance amount. Loan may be either outstanding or paid off.

Questions

1. Create a Conceptual model (List Entities and note Relationships, 2- 3 Relationships only) (3 Pts)

2. Create a Logical model (Add attributes & relationship cardinalities, 3 – 4 Attributes only) (3 Pts)

3. Create a Physical model sufficient to implement the database schema correctly (Define table, columns, data types, nullability etc. No need to consider Triggers) (4 Pts)

Problem 2) Task Rabbit Application

This application allows consumers to find other people to perform various tasks for them.

USE CASES:

1. Users register with the application either as a consumer (person who needs tasks to be done) or as a tasker (person who is willing to perform tasks) or both

2. For consumers, the application stores their PayPal account id

3. For taskers, the application stores additional description about the type of tasks they are willing to perform

4. Consumers can create tasks (eg. collect grocery, stand in line at DMV office etc), specify their offer price and invite bids with task status = OPEN

5. Taskers can bid on one or more tasks and provide their bid price

6. Consumers can select one bid for a given task and mark the task with status = INPROGRESS

7. Once the task is done, tasker can update task with status = COMPLETED

8. Consumer can review the task and update task either with status = ACCEPTED or change it to REDO

9. Taskers get paid once the status is updated to ACCEPTED by consumer

Questions

1. Create a Conceptual model (List Entities and note Relationships, 2- 3 Relations only) (5 Pts)

2. Create a Logical model (Add attributes & relationship cardinalities, 3 – 4 Attributes only) (5 Pts)

3. Create a Physical model sufficient to implement the database schema correctly (Define table, columns, data types, nullability etc. No need to consider Triggers) (10 Pts)