ZuoTi.Pro
Question

DATABASE Draw an ER diagram according to the following requirements.   The bank application keeps track of...

DATABASE

Draw an ER diagram according to the following requirements.  

The bank application keeps track of the following information. As a customer of the bank, he/she must either own an account or borrow a loan. The banking application does not require a customer to both own account and borrow a loan. Customer information includes a SSN (unique), a name, and an address. A customer can borrow at most one loan. A loan has a loan number (unique) and an amount. A loan must be borrowed by at least one customer. An account has an account No (unique) and an amount. A customer may own many accounts. An account can be owned by many customers, at least one. The date that a customer starts to own an account also needs to be recorded.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)

All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
DATABASE Draw an ER diagram according to the following requirements.   The bank application keeps track of...
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

Similar Homework Help Questions

  • Draw an ER diagram according to the following requirements.   The bank application keeps track of the...

    Draw an ER diagram according to the following requirements.   The bank application keeps track of the following information. As a customer of the bank, he/she must either own an account or borrow a loan. The banking application does not require a customer to both own account and borrow a loan. Customer information includes a SSN (unique), a name, and an address. A customer can borrow at most one loan. A loan has a loan number (unique) and an amount. A...

  • First, draw an EER that models the given requirements. You will play with the Bank Database...

    First, draw an EER that models the given requirements. You will play with the Bank Database in this homework. Please download and execute the bank.sql from Canvas to create this database in your MySQL system. Please submit the results as a zip file with a name <yourname>-bank.zip. Consider modeling a bank: . The bank keeps personal information of each customer including name, sex, address, phone number, social security number, and date of birth. . Each customer owns one or more...

  • 1. Explain total participation and partial participation in ER diagram. 2. Explain disjointness constraints and co...

    1. Explain total participation and partial participation in ER diagram. 2. Explain disjointness constraints and completeness constraints in EER modeling. 3. Map the following conceptual schema in ER to logical database schema 1 1Page 11 BANK-BRANCH BANK BRANCHES> Branch no Addr CodeNameAddr LOANS ACCTS Loan no Amount Acct no Balance Type LOAN Type ACCOUNT L_C AC Name Ssn CUSTOMER Phone 1. Explain total participation and partial participation in ER diagram. 2. Explain disjointness constraints and completeness constraints in EER modeling....

  • House of Rock is a rental business that rents musical instruments to bands. Create an ER...

    House of Rock is a rental business that rents musical instruments to bands. Create an ER diagram using erdplus.com for the House of Rock Operations Database, based on the following requirements. Use the Export Image command under the Diagram pull-down to generate a .png file. Upload the .png file to submit this assignment in Blackboard. The House of Rock Operations Database will keep track of instruments, bands, repair technicians, and shows. For each instrument, House of Rock will keep track...

  • Database Analysis and Design (ER diagram) After the requirement collection and analysis phase the software project...

    Database Analysis and Design (ER diagram) After the requirement collection and analysis phase the software project of a database application about a company is described as follows: 1. The company is organized into departments. Each department has a name, an unique number, and a particular employee who manages the department. We keep track of the start date when the employee began managing the dept. A dept may have several locations. 2. A dept controls several projects, each of which has...

  • Snooty Fashions is an exclusive custom fashion designer business. Below are the Requirements of Snooty Fashions....

    Snooty Fashions is an exclusive custom fashion designer business. Below are the Requirements of Snooty Fashions. The Snooty Fashions Operations Database will keep track of the following: • For each designer: a unique designer identifier and unique SSN as well as the name (composed of first and last name) • For each customer: a unique customer’s identifier as well as his or her name and multiple phone numbers • For each tailoring technician: a unique SSN as well as his...

  • Consider the following set of requirements for a university database that is used to keep track...

    Consider the following set of requirements for a university database that is used to keep track of students' transcripts The university keeps track of each student's name, student number, social security number, address and phone, birthdate, gender, `, and degree program (bachelor, Masters, PhD.). Both social security number and student number have unique values for each student. Each department is described by a name, department code, office number, office phone. Both name and code have unique values for each department....

  • question One: Design an ER diagram for the following Dental Clinic database. Your diagram should have...

    question One: Design an ER diagram for the following Dental Clinic database. Your diagram should have all the needed details. You may make any reasonable assumptions but you have to state them clearly. ------ The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary, birth-date and home-address (Box, City, Zip). Each client (patient) has a unique Code, name, home-phone, work-phone, address, and birth-date. Each client is assigned to one dentist. All future visits will...

  • DRAW AN ER DIAGRAM TO MAP IT OUT: The Problem: The database you design should be...

    DRAW AN ER DIAGRAM TO MAP IT OUT: The Problem: The database you design should be for the following scenario: OHIP wants to keep track of it's doctors and patients and hospitals. For the doctors, you must keep track of the doctor's license number. The license number is 4 character alphanumeric, for example 4RG2. Also, you must keep track of the doctor's first name (up to 20 letters), last name(up to 20 letters), specialty (up to 30 letters) and the...

  • Help with database creation - create a visio ER diagram of the scenerio below.. thanks The...

    Help with database creation - create a visio ER diagram of the scenerio below.. thanks The registrar's office at Weber State University wants you to create a new database to support an future application that will help their department better keep track of the scheduled classes offered each semester, including the specific course sections and lecturers appearing in the schedule, and the students registering for courses according to the published schedule. Courses (think course catalog) may or may not be...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT