Question

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. Note: You must use one of the automated database design tools such as: ER STUDIO ER Assistant Vision Enterprise or draw.io website

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

E-R Diagram-

  • This Er model has 4 main entities-
  1. student
  2. Student loan
  3. loan
  4. school
  5. 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.
    If any doubt, please feel free to ask and comment, i would like to answer them.
    Thank you
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
a gymnastic school with hundreds of students. It needs a database to track all the different...
a gymnastic school with hundreds of students. It needs a database to track all the different classes that are being offered, who is assigned to teach each class, and which students attend each class. Also, it is important to track the progress of each student as they advance. Design a database for the following requirements: Students are given a student number when they join the school. This is stored along with their name, date of birth, and the date they...
A small company is expanding into new offices spread across three buildings. To keep track of...
A small company is expanding into new offices spread across three buildings. To keep track of office furniture, computers, and printers, the company would like an ER diagram to keep track of everything. Each piece of office furniture, computer, or printer is given an identification number. Each item (which is either a piece of furniture, a computer, or a printer) is placed in a room of one of three buildings. The building manager is responsible for the items in their...
The county animal shelter has hired you to design a database to track the animals at...
The county animal shelter has hired you to design a database to track the animals at the shelter along with the people who adopt them. You have worked with the staff at the shelter, analyzed how they perform the work now, performed user requirements gathering and you have to create an ERD. Below you will find the description of the entities and attributes defined during this process. Animal: animal_id, species, breed, age, gender, size, spay/neuter, intake_date, location, cost Adopter: name,...
SportTech Events puts on athletic events for local high school athletes. The company needs a database...
SportTech Events puts on athletic events for local high school athletes. The company needs a database designed to keep track of the sponsor for the event and where the event is located. Each event needs a description, date, and cost. Separate costs are negotiated for each event. The company would also like to have a list of potential sponsors that includes each sponsor’s contact information such as the name, phone number, and address. Each event will have a single sponsor,...
Design an E-R diagram to model a college described below: ● There are several departments in...
Design an E-R diagram to model a college described below: ● There are several departments in a college, and each of them has a unique name, one or more telephone numbers, and an address. ● Each department gives some number of courses. Each course has a course number which can be used to identify a course only inside of the same department. Each course has its schedule and a certain number of credits. Each course is held in some location...
Consider the following information to design a database for a catalogue of an online video service...
Consider the following information to design a database for a catalogue of an online video service that offers access to popular TV series. The following is the description of the application: Each series has a name and a description. Each series has many episodes. Each episode of a series has an episode number, the date it was first aired, and the length of the episode in minutes. The episode number uniquely identifies an episode with respect to the series, but...
Design ER diagram to capture the information below and explain fully your answer: The University has...
Design ER diagram to capture the information below and explain fully your answer: The University has to create a database. In design stage the committee formed the following description: “The research activity at the University is organized as series of projects: Each project has project number, budget, funding organization, staring date and completion date. Each project has a PI who is full time faculty at the university. Each project has only one PI, but can have one or more Co-PI...
The database is to handle the bookings in a company that arranges one-day guided group tours...
The database is to handle the bookings in a company that arranges one-day guided group tours from the different hotels in a resort town to various destinations. Specific details are: Every hotel is described by: A unique hotel name, address, and phone number. Every destination is described by: A unique destination name, and type. Every guide is described by: A unique guide id, name, and all the languages that he/she speaks. Every tour is described by: A date, number of...
You are asked to design a database to support a Instant Recruitment System of casual staff...
You are asked to design a database to support a Instant Recruitment System of casual staff for a school. The major business requirements are summarised below in the Mini Case: An Instant Recruitment System. You are asked to develop a detailed Entity-Relationship model for this mini case. Your ER model should consist of a detailed ER diagram integrated with itemised discussions on the features of the entities and relationships and all the assumptions you made where applicable. The ER diagram...
Complete and correct answer is required to give full credit,thank you Consider the following set of...
Complete and correct answer is required to give full credit,thank you Consider the following set of requirements for an airline database that is used to keep track of flights, passengers, employees etc. for an airline. You will be graded not only on the correctness and completeness of the design but also on its quality. 1)     It is important to keep track of each passenger's name, address, phone number and meal preference (values could be vegetarian, sea-food, italian, anything). At times, it...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT