Suppose a company that sells products has a product entity type with the following attributes: prodNum, prodDesc, prodPrice
Computer Science
Share With
Suppose a company that sells products has a product entity type with the following attributes: prodNum, prodDesc, prodPrice. Suppose all three attributes are single-valued and that prodNum is a key attribute - each product has a different product number. Illustrate this information in an ERD.
Consider a banking application where each account is identified first by an account number and then by its type (Savings, Checking, and Loan). This scheme allows the customer to remember just one number instead of three, and then to pick a specific account by its type. Other attributes to be considered are the date the account was opened and the account’s current balance. Draw an ERD for the entity type Account with the attributes account number, account type, date opened, current balance. What is the key to the entity type? Is there an attribute that is likely a derived attribute? Show these attributes appropriately in the ERD.
Purchase A New Answer
Custom new solution created by our subject matter experts
