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.