ZuoTi.Pro
Question

Let us use the conceptual schema diagram below to answer the question parts. It is about a database for banks and their branches. BANK HAS BANK BRANCH Code Name Addr Addr Branch_no Acct_no Loan_no ISSUES ACCTS ISSUES LOANS Balance Type Type Amount 0: n 0: n Name Phone CUSTOMER Addr Ssn

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

Homework Answers

Answer #1

The branch values which can be used according to the above given schema are as follows.The only thing to be kept in mind is that the value hsould be unique.

Bank X

Branch_no of Branch 1=567891234

Branch_no of Branch 2=4567123498

Bank Y

Branch_no of Branch 1=325679841

Branch_no of Branch 2=875643291

Branch_no of Branch 3=673429831

0 0
Add a comment
Know the answer?
Add Answer to:
Let us use the conceptual schema diagram below to answer the question parts. It is about...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

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

  • This is how i mapped the relational schema diagram. would this be correct? i feel like...

    This is how i mapped the relational schema diagram. would this be correct? i feel like i am missing something. ud bundle at the start of the class on the due date. ment. 1. (10 pts) Use the ER-to-relational mapping algorithm to map the BANK ER diagram to a relational schema diagram. Prepare the diagram using ERDPlus and make sure to specify all primary keys and foreign keys. (Position the relations so that the arcs from the foreign keys to...

  • Consider the schema below that models a bank’s branches, customers and their accounts and loans. Provide...

    Consider the schema below that models a bank’s branches, customers and their accounts and loans. Provide SQL queries to answer the questions that follow. Branch (bank_name, addr, city, assets) // Primary Key=bank_name Customer (cust_name, addr, city) // Primary Key=cust_name Account (acc_num, cust_name, bank_name, type, balance) // Primary Key=acc_num Loan (loan_num, cust_name, bank_name, type, amount)  // Primary Key=loan_num -- 2. Find the names of all the customers who live in a city with no bank branches. -- a) Use a nested subquery....

  • Consider the schema below that models a bank’s branches, customers and their accounts and loans. Provide...

    Consider the schema below that models a bank’s branches, customers and their accounts and loans. Provide SQL queries to answer the questions that follow. Branch (bank_name, addr, city, assets) // Primary Key=bank_name Customer (cust_name, addr, city) // Primary Key=cust_name Account (acc_num, cust_name, bank_name, type, balance) // Primary Key=acc_num Loan (loan_num, cust_name, bank_name, type, amount)  // Primary Key=loan_num *****Use a nested subquery if possible***** -- 3.   Find the bank with the largest total account balance, i.e., the bank --    that has the most funds...

  • Having trouble writing two mysql queries for this schema The low level conceptual model of the...

    Having trouble writing two mysql queries for this schema The low level conceptual model of the restaurant database is provided below: DATABASE: RESTAURANT (res_name[pk], City, Phone, Owner_SSN[pk,fk]) FOOD (food_name[pk], Type, Country, Proof) CUSTOMER (SSN[pk], Name, Birth_year, Fav_food[fk], Gender) LIKES (SSN[pk,fk], food[pk,fk]) SERVES (res[fk], foods[fk]) OWNER (SSN[pk], Name, City, Address, Phone) QUERIES 14) Find the total number of foods that are liked by customers. Note that if a food is repeatedly liked by several people, it is just counted as once....

  • Design the entity relationship conceptual schema. Depict the ER diagram you have designed, outlining the entity...

    Design the entity relationship conceptual schema. Depict the ER diagram you have designed, outlining the entity types, relationship types, their respectives attributes, keys, structual constraints, and role names. In designing the entity relationship schema, make the initial conceptual design and the neccessary refinements after that. This will be a hospital database hospital, include patients, each patient will be either inpatient or outpatient and have a unique ID, first name, last name, address, city, zip code, phone number, and room number....

  • 1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create...

    1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create the SQL script that will generate the data model Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their...

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

  • Conceptual data diagram The ABC university keeps track of each student&#39;s name, student number, social security...

    Conceptual data diagram The ABC university keeps track of each student&#39;s name, student number, social security number (I C number), current address and phone, permanent address and phone, birthdate, sex, class (alpha, Beta, Gamma ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student&#39;s permanent address, and to the student&#39;s last name. Both social security number and student number have...

  • Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The...

    Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The ER diagram should include entities, attributes (if there are less than three specified in the business statements, please add some extra attributes), identifiers and corresponding data types, the relationships among entities with cardinality and associative entities. .b) Extend Q1.a) to apply generalization/specialization technique to construct an Enhanced-ER (EER) diagram. The EER diagram should specify the complete (total) and disjoint (mutuallyexclusive) constraints on the generalization/specialization....

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