HomeworkLib
Question

1. Explain total participation and partial participation in ER diagram. 2. Explain disjointness constraints and completeness
11 BANK-BRANCH BANK BRANCHES> Branch no Addr CodeNameAddr LOANS ACCTS Loan no Amount Acct no Balance Type LOAN Type ACCOUNT L
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
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

nsces- Given that, Total and Pastial Pas tidpotan All Ganks ha^ Lank sxanches - Totol Pasticipata) Sama Bank Bsanches 9ive (c

0 0
Add a comment
Know the answer?
Add Answer to:
1. Explain total participation and partial participation in ER diagram. 2. Explain disjointness constraints and co...
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

  • Let us use the conceptual schema diagram below to answer the question parts. It is about...

    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

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

  • 2. Design an ER-diagram for a bank that implements the following requirements. The database you design...

    2. Design an ER-diagram for a bank that implements the following requirements. The database you design should store information about customers, accounts, branches and employees • Customer: Customers are identified by their SSN. For each customer we store a name, multiple phone numbers (one or more), and an occupation. • Account: Accounts are identified by an account number and the branch they belong to. For each account we store a balance and the type of account (e.g., savings). – An...

  • c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I att...

    c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I attribute as a primary key for an entity to make t unique if necessary. Library has a number of branches in the city, each branch having a name, address and librarian. Books have title, authors and publisher. A book can have multiple authors but a single publisher. Note that same...

  • 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