Q.1] Answer the following questions a) Explain total participation and partial p
ID: 3738793 • Letter: Q
Question
Q.1] Answer the following questions a) Explain total participation and partial participation in ER diagram (b) Explain disjointness constraints and completeness constraints in EER modeling. (c) Map the following conceptual schema in ER to logical database schema. BANK BRANCH BRANCHES) Branch 00 Addr LOANS ACCTS Loan no Acct no A.C Name CUSTOMER Addr (d) Map the conceptual schema shown in EER below to logical database schema. Note: use option 8(a): multiple relations-super class and sub classes Fname MinitLname Name SnBirth dateAdd ress EMPLOYEE grade ?SECRETARY!TECHNICANI ENGINEERExplanation / Answer
Q1
a) Total and partial participation
All Banks has Bank Branches ----- Total participation
Some Bank Branches create Accts --- Partial participation
Some Bank Branches give Loans --- Partial participation
A Customer can have Acct - Partial participation
A Customer can have taken loan - Partial participation
b)
A Bank Branch can provide Account creation or Loan ---- Disjointness constraint
A Customer can create Account or take Loan --- Disjointness constraint
c)
BANK(Code,Name,Addr)
BANKBRANCH(Code,BranchNo,Addr)
ACCOUNT(Acct_No,Balance,Type)
LOAN(Loan_No,Amount,Type)
Customer(SSN,Name,Addr,Phone)
underlined are primary keys
d)
EMPLOYEE(SSN,Fname,Minit,Lname,Birth_date,Address)
SECRETARY(SSN,Typing_speed)
TECHNICIAN(SSN,Tgrade)
ENGINEER(SSN,Eng_type)
underlined are primary keys and italicised are foreign keys. Some attributes are both.
Do ask if any doubt. Please upvote.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.