DATABSE CONTSTRUCT MNGT SEPT a) Managing Director of "SUN RISE CORPORATION" wish to have a computerize Accounting System for his company.

DATABSE CONTSTRUCT & MNGT SEPT

a) Managing Director of “SUN RISE CORPORATION” wish to have a computerize Accounting

System for his company. A requirement study has been carried out and summarized as

below: -

· There are five types of ACCOUNT GROUP, namely, Expense, Revenue, Asset, Liability and

Income.

· Each ACCOUNT GROUP consists of one or more than one ACCOUNT CODE. In the other

word, each ACCOUNT CODE will be belong to one and only one ACCOUNT GROUP

· ACCOUNT CODE may consists one or more than one SUBACCOUNT. The maximum

number of SUBACCOUNT for each ACCOUNT CODE is 50.

· SUBACCOUNT may be further classified into CATEGORYs. There is some SUBACCOUNT

without any classification.

· Each CATEGORY can have only one and only one BAR CODE.

Draw the resulting Entity-Relationship diagram.

b) Explain the Legal, Ethical and Privacy Concerns associated with the use of online

databases.