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 2 hours ago

Next > < Previous

Related Solutions

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...

The Ministry of Education wants to know whether attending a private school has a positive causal...

The Ministry of Education wants to know whether attending a private school has a positive causal effect on student test scores. The Ministry provides you with data that covers all students in the province of Ontario. The data include each student's grade average and whether he or she attends a public or private school. Note that attending a private school is an active choice made by students and parents (all students are guaranteed a spot in a public school) and...

Subjects