Question
In: Computer Science
A loan company wants to design a database to track student loans. Each student attending school...
A loan company wants to design a database to track student loans. Each student attending school is eligible for a loan. A student may have more than one loan. A student may be registered, possibly at different times, in more than one school. Each loan should belong to only one bank. Each bank can approve as many loans as it desires. For each loan, the loan company will track: the student’s SSN, name, address, amount of loan, date of the loan, interest rate ( which may be different for each loan as determined by the bank), duration of the loan, monthly payment, remaining balance, school ID, school name and address, number of years the student has been at the school, bank name, bank branch, and bank ID. Draw an ER diagram. State any assumptions you make in the diagram
Solutions
Expert Solution
E-R Diagram-
This Er model has 4 main entities-
student
Student loan
loan
school
bank
This Er model has has been converted into 3NF
Here each entity and its attributes are in tabular form
Data types of each attribute has been mentioned with it
The primary key as PK and foriegn key as FK has been mentioned
there.
THANK YOU!!! PLEASE VOTE
venereology answered 1 month agoRelated Solutions
A loan company wants to design a database to track student loans. Each student attending school...
A loan company wants to design a database to track student
loans. Each student attending school is eligible for a loan. A
student may have more than one loan. A student may be registered,
possibly at different times, in more than one school. Each loan
should belong to only one bank. Each bank can approve as many loans
as it desires. For each loan, the loan company will track: the
student’s SSN, name, address, amount of loan, date of the...
Design a simple database to track people and who they voted for. The database should have...
Design a simple database to track people and who they voted
for. The database should have 3 tables:
A table of candidates
A table of registered voters
A table of votes
The candidate table should provide a listing of all candidates
and information about the candidates.
The registered voter table should hold all registered voters
and any pertinent information about them
The vote table should hold vote records for each candidate
made by the voters
Requirements:
The system should not...
Design a database through the EER diagram to keep track of the teams and games of...
Design a database through the EER diagram to
keep track of the teams and games of a sport league. Assume that
the following requirements are collected (the
English description of cardinal ration and
partial/complete participate is NOT required, but you still need to
provide the total/partial and cardino ration in your EER diagram)
:
The database has a collection of TEAM. Each Team has a unique
name, players, and owner.
The database also keeps the records of PLAYERS. Each player...
You currently have two loans outstanding: a car loan and a student loan. The car loan...
You currently have two loans outstanding: a car loan and a
student loan. The car loan requires that you pay $329 per month,
starting next month for 28 more months. Your student loan is
requires that you pay $145 per month, starting next month for the
next 119 months.
A debt consolidation company gives you the following offer: It
will pay off the balances of
your two loans today and then charge you $487 per month for the
next 41...
You currently have two loans outstanding: a car loan and a student loan. The car loan...
You currently have two loans outstanding: a car loan and a
student loan. The car loan requires that you pay $325 per month,
starting next month for 26 more months. Your student loan is
requires that you pay $87 per month, starting next month for the
next 38 months.
A debt consolidation company gives you the following offer: It
will pay off the balances of
your two loans today and then charge you $501 per month for the
next 45...
You currently have two loans outstanding: a car loan and a student loan. The car loan...
You currently have two loans outstanding: a car loan and a
student loan. The car loan requires that you pay $413 per month,
starting next month for 28 more months. Your student loan is
requires that you pay $89 per month, starting next month for the
next 75 months. A debt consolidation company gives you the
following offer: It will pay off the balances of your two loans
today and then charge you $508 per month for the next 37...
You currently have two loans outstanding: a car loan and a student loan. The car loan...
You currently have two loans outstanding: a car loan and a
student loan. The car loan requires that you pay $313 per month,
starting next month for 35 more months. Your student loan is
requires that you pay $133 per month, starting next month for the
next 115 months.
A debt consolidation company gives you the following offer: It
will pay off the balances of
your two loans today and then charge you $451 per month for the
next 45...
A track coach wants to compare the 200m time of his high school track team. boy:...
A track coach wants to compare the 200m time of his high school
track team.
boy: 23, 22, 21, 24, 23, 25, 22, 23
girl: 25, 28, 22, 26, 29, 26, 27, 24
a. What test should he use to compare the means?
b. Is it significant at 0.5 level?
c. What conclusion can be made?
d. Calculate omega squared and interpret its meaning in this
study.
t = (M1-M2)/sqr rt
[{(N1-1)S12 +
(N2-1)S22/(N1+N2-2)]
* [(N1 +
N2)/N1*N2]}
Ω2 =...
Ava wants to use a database to keep track of the data recordsfor her insurance...
Ava wants to use a database to keep track of the data records
for her insurance company and to enforce the following business
policies/requirements: USE MS ACCESS TO CREATE A DATABASE &
RELATIONASHIP-Every customer must be uniquely identified.-A customer can have many insurance policies.-Every insurance policy must be uniquely identified.-An insurance policy must belong to a valid customer.-Every customer must be served by a valid insurance agent
(employee).-An insurance agent (employees) serves many customers.-Every insurance agent (employee) must be uniquely...
Paul wants to estimate the mean number of siblings for each student in his school. He...
Paul wants to estimate the mean number of siblings for each
student in his school. He records the number of siblings for each
of 100 randomly selected students in the school. What is the
parameter? Select the correct answer below: all the students in the
school the 100 randomly selected students the specific number of
siblings for each randomly selected student the mean number of
siblings for all students in the school the mean number of siblings
for the randomly...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Write a program that copies the contents of one file to a destination file. This program...
- how to conduct a marketing mix for 3d crest white strips
- Is big data analytics used for service innovation at Amazon? If so, please write a brief...
- A shrink-fit process has been used to enhance the pressure carrying capacity of a cylinder. During...
- Ten-year zero coupon bonds issued by the U.S. Treasury have a face value of $1,000 and...
- The Blossom Department of Transportation has issued 25-year bonds that make semiannual coupon payments at a...
- Please answer all 4 parts of this question John Johnson just received a cash gift from...
ADVERTISEMENT