Exercises based on ER Model Concepts Part 1

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=l9BRmq7pgZ8

DBMS: Exercises based on ER Model Concepts • Topics discussed: • A solved problem based on ER Model Concepts: • Consider the ER diagram shown in the figure for part of a BANK database. Each bank can have multiple branches, and each branch can have multiple accounts and loans. • 1. List the strong (nonweak) entity types in the ER diagram. • 2. Is there a weak entity type? If so, give its name, partial key, and identifying relationship. • 3. What constraints do the partial key and the identifying relationship of the weak entity type specify in this diagram? • 4. List the names of all relationship types, and specify the (min, max) constraint on each participation of an entity type in a relationship type. • 5. List concisely the user requirements that led to this ER schema design. • 6. Suppose that every customer must have at least one account but is restricted to at most two loans at a time and that a bank branch cannot have more than 1,000 loans. How does this show up on the (min, max) constraints? • Follow Neso Academy on Instagram: @nesoacademy(https://bit.ly/2XP63OE) • Contribute: http://www.nesoacademy.org/donate • Memberships: https://bit.ly/2U7YSPI • Books: http://www.nesoacademy.org/recommende... • Website ► http://www.nesoacademy.org/ • Forum ► http://forum.nesoacademy.org/ • Facebook ► https://goo.gl/Nt0PmB • Twitter ► / nesoacademy • Music: • Axol x Alex Skrindo - You [NCS Release] • #DBMSByNeso #DBMS #ERDiagram

#############################

New on site