Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please identify the business rules in this database design: There are many types of loans that a beneficiary can avail of. The Association

Can someone please identify the business rules in this database design:

There are many types of loans that a beneficiary can avail of. The Association needs to keep track of the loan ID (identifier), loan name, and maximum amount that the beneficiary can avail of for a particular type of loan. The beneficiary can avail of a smaller amount, which is less than the maximum. The loan types (and their maximum amounts) that the beneficiary can avail of are the following: tuition fee (10,000.00), school supplies (2,000.00), and medical expenses (10,000.00). To ensure that the beneficiary can pay his/her loan, they are allowed to make a loan only if he/she had already fully paid the current loan.

For basis:

The company is organized into departments. Each department has the following attributes: DeptNo, DeptName. A particular employee manages each department. The company keeps track of the StartDate when that employee began managing the department, EndDate the date the employee stops managing the department and the reason why the employee is no longer managing the department. A department has several locations. It controls a number of projects, each of which has a ProjectNo, ProjectName, and a single ProjectLocation.

Business rules:

1. One employee manages one department. 2. One department is managed by one employee. 3. One department can be in one or more locations. 4. One location can have one or more departments. 5. One department controls one or more projects. 6. One project is controlled by one department.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing

Authors: David M. Kroenke, David Auer

11th Edition

B003Y7CIBU, 978-0132302678

More Books

Students also viewed these Databases questions