Draw entity relationship diagrams for each of the following:
a. The attributes of a customer in an accounts receivable database include name, address, and charge card number.
b. The attributes of a student in a student database include student number (primary key), name, and class rank.
c. The attributes of an asset in a general ledger database include inventory number (primary key), description, and date of purchase.
d. The relationship between an employee and ‘‘is assigned parking’’ is one to many.
e. The relationship between an employee and ‘‘completes training program’’ is many to many.
f. The relationship between ‘‘employee’’ and ‘‘health plan’’ is many to one.
g. A customer can be a cash customer or a credit customer. If the customer is a credit customer, an attribute is his or her credit card number.
h. A patient is either an outpatient or an inpatient. If the patient is an inpatient, he or she is assigned a bed (one to one).
i. An investment asset could be cash, a stock, a bond, or a certificate of deposit (CD).
j. An account at a bank could be a checking account, a savings account, or a loan account.
Each type of account requires an account or loan number. If it is a loan account, another attribute is the monthly payment amount.