Question

In: Computer Science

How to determine what type of attribute the following attributes are in an Entity-Relationship Model? I...

How to determine what type of attribute the following attributes are in an Entity-Relationship Model? I just want to know if each of these can be considered as a composite attribute, a multi-valued attribute or neither:

Suppose we have:

1. Name : A person's full name

2. Address : A residential address

3. Account Balance : A bank account balance

4. Monthly fees: Monthly fees associated with a chequing account, which are unique to each account holder

5. Minimum Balance: The minimum balance needed to maintain a chequing account, which is unique to each account holder

6. Interest Rate: Interest rate associated with a savings account that changes over time.

7. Loan Payment Amount: Amount paid towards a loan.

8. Date-Time: YYYY-MM-DD HH-MI-SS

9. Type of Transaction: Deposit or withdrawl from an account

10. Date of Birth: A person's date of birth

11. Date-Time: YYYY-MM-DD HH-MI-SS

12. Service Details: Details regarding the services a bank has provided for a customer

Solutions

Expert Solution

Solution:

Composite attributes are made up of more than one simple attribute. For example, if the attribute is Name, then it may have first name and last name.

Multi valued attributes are the attributes that may contain more than one values. For example, a person can have more than one phone no. or email id.

1. Name - Composite Attribute

2. Address - Composite Attribute, as it can have Block number, House number, City Name and Pin code

3. Account Balance - Multivalued as a person can have more than one account for which he might have different balances for each account.

4. Monthly fees - Multivalued, as it is unique to every chequing amount and a person can have more than one chequing account

5. Minimum Balance - Multivalued as a person can have more than one account for which he might have different minimum balances for each account.

6. Interest Rate - Multivalued as a person can have more tha one savings account and for each of the sangs account he will have different interest rates.

7. Loan Payment - Multivalued, as for different accounts a person might have taken different loans.

8. Date-Time - Composite Attribute, as it has different components such as Year, Month, Date, Hours, Minutes and Seconds

9. Type of Transaction - Composite attribute, as it can be either deposit or withdrawal.

10. Date of Birth - Composite Attribute, as it has different components Year, Month and Date.

11. Date-Time - Composite Attribute, as it has different components such as Year, Month, Date, Hours, Minutes and Seconds

12. Service Details - Multivalued attribute, as details regarding the sevices a bank has provided for a customer will be different.


Related Solutions

Model the following cases by ER diagrams. Identify the keys, attributes and relationship cardinalities, and convert...
Model the following cases by ER diagrams. Identify the keys, attributes and relationship cardinalities, and convert them into table schemas. Provide necessary assumptions to support your model. The following descriptions are about the inventory information. a) Each product item has ID, description, quantity in the inventory, unit price and a supplier. b) Suppliers have unique ID, addresses, phone numbers, and names. c) Each address is made up of a street address, a city, and a postcode. d) The purchase order...
In the following independent situations, discuss and determine whether a parent–subsidiary relationship exists, and which entity,...
In the following independent situations, discuss and determine whether a parent–subsidiary relationship exists, and which entity, if any, is a parent. You must fully explain and support your answer. This includes identifying and discussing each of the important facts or considerations in each case. (a). Tom Ltd is a company that was hurt by a major downturn in the economy. It previously obtained a significant loan from Jenson Bank, and when Tom Ltd was unable to make its loan repayments,...
In the following independent situations, discuss and determine whether a parent–subsidiary relationship exists, and which entity,...
In the following independent situations, discuss and determine whether a parent–subsidiary relationship exists, and which entity, if any, is a parent. You must fully explain and support your answer. This includes identifying and discussing each of the important facts or considerations in each case. Sawyer Ltd is a major financing company whose interest in investing is return on the investment. Sawyer Ltd does not get involved in the management of its investments. If an investee is not managed properly, Sawyer...
In the following independent situations, discuss and determine whether a parent–subsidiary relationship exists, and which entity,...
In the following independent situations, discuss and determine whether a parent–subsidiary relationship exists, and which entity, if any, is a parent. You must fully explain and support your answer. This includes identifying and discussing each of the important facts or considerations in each case. 1.Bernadette Ltd and Howard Ltd each hold 50% of the shares in Jerry Ltd, all companies being involved in the computer software industry. Bernadette Ltd agrees that Howard Ltd should provide the management of Jerry Ltd...
Entity-relationship data model (ERD)-Business rule, assumptions You are required to develop an ER model to represent...
Entity-relationship data model (ERD)-Business rule, assumptions You are required to develop an ER model to represent the information requirements of company you are working for. You also need to write business rules and assumptions. Task 2: Create the Data Dictionary base on your ERD diagram.
6)         i)          How would you identify entity and relationship types from a user’s requirements specification?         &n
6)         i)          How would you identify entity and relationship types from a user’s requirements specification?             ii)         How would you identify attributes from a user’s requirements specification and then associate the attributes with entity or relationship types?
Which of the following best illustrates the relationship between entities and attributes?
Which of the following best illustrates the relationship between entities and attributes?  A. The entity CUSTOMER with the attribute ADDRESS   B. The entity PRODUCT with the attribute CUSTOMER   C. The entity CUSTOMER with the attribute PRODUCT   D. The entity ADDRESS with the attribute CUSTOMER   E. The entity PRODUCT with the attribute PURCHASE
You are creating an enhanced entity relationship model for a campus information system. A junior team...
You are creating an enhanced entity relationship model for a campus information system. A junior team member who is helping you asks you to describe the following terms with examples of relevant entities from the system, for example, students, activities etc. 1.       Supertype and Subtype 2.       Disjoint and Overlapping Discriminator 3.       Total and Partial Completeness 4.       Attribute Inheritance
You are creating an enhanced entity relationship model for a campus information system. A junior team...
You are creating an enhanced entity relationship model for a campus information system. A junior team member who is helping you asks you to describe the following terms with examples of relevant entities from the system, for example, students, activities etc. 1.       Supertype and Subtype 2.       Disjoint and Overlapping Discriminator 3.       Total and Partial Completeness 4.       Attribute Inheritance
A database needs to be developed that supports a supermarket. (i) Design an entity-relationship diagram that...
A database needs to be developed that supports a supermarket. (i) Design an entity-relationship diagram that captures, as far as possible, the requirements stated below. (Statements in brackets are additional explanations and not part of the requirements proper.) If you make any assumptions in your design, please write them down. Assumptions, however, must not contradict the requirements. 1. The supermarket sells products. Each product is uniquely identified by its product number. Moreover, a product has price. The supermarket also records...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT