Reference no: EM131232570
Consider the following ER-Diagram
Consider the ER diagram in previous slide:
a) List the (non-weak) entity types in the ER diagram
b) Is there a weak entity type? If so, give its name, partial key and identifying relationship
c) What constraints do the partial key and the identifying relationship of the weak entity type specify in the diagram?
d) List the names of all relationship types and specify the (min,max) constraint on each participation of an entity type in a relation type. Justify your choices.
e) List concisely the user requirements that led to this ER schema design.
f) Suppose that every customer must hae at least one account but is restricted to at most two loans at a timem and that a bank branch cannot have more than 1000 loans. How does this show up on the (min,max) constraints?
Attachment:- Data_Modeling.pdf
|
Develop an app which allows users to keep records of trips
: ICT311 - Mobile App Development - develop an app which allows users to keep records of their personal trips and
|
|
What could the company have done to minimize exposure
: Pugh worked for See's Candies, Inc. for 32 years. He had started out as a dishwasher, worked his way up to vice president of production, and was also on the Board of Directors. When he was hired, he was told by the president and general manager, "If ..
|
|
Required manual dexterity and physical strength test
: DePeters, Co. is sued for sex discrimination on the grounds that too few women are hired because fewer women than men achieve passing scores on a required manual dexterity and physical strength test. DePeters, Co. offers in its defense that even thou..
|
|
Identify the averages of the numbers below
: The firm has a creative set of product developers who are experts on assessing new consumer needs. Construct a BCG matrix for assessing the portfolio strategy for the firm*. Based on the matrix, what are your recommendations?
|
|
List the non-weak entity types in the er diagram
: List the (non-weak) entity types in the ER diagram. Is there a weak entity type? If so, give its name, partial key and identifying relationship. What constraints do the partial key and the identifying relationship of the weak entity type specify in t..
|
|
New running shoes and designer jeans
: Sarah makes $500 a week at her summer job and spends her entire weekly income on new running shoes and designer jeans. Because these are the only 2 items that provide utility to her. Furthermore, sarah insists that for every pair of jeans she buys..
|
|
Find the final pressure and the heat transfer in the process
: The partition wall is removed, and because of heat transfer the water comes to a uniform state with a temperature of 200?C. Find the final pressure and the heat transfer in the process.
|
|
What is the problem when defining industry
: What is the problem when defining industry as "collection of firms producing products that are substitutes in consumption"? (4 lines)
|
|
Check the grammar and sentence structure of given document
: Proofread the given document. - The document is a "Protest Letter". - Check the grammar and sentence structure at college level.
|