Reference no: EM132494227

Construct an ER diagram for a database system that models data of the following situation. You are creating a database for a stock trading company. The company has clients and financial officers. Each client is either an individual or another legal entity (e.g. another company). A client has a name, social security number, address, contact information, the date that entered the database system, and also a ranking that the trading company keeps internally (high, med, low). Financial officers have a name, employee ID, social security number,annual salary, bonus, bonus. There are contracts that one client (or more clients together in one contract) have with the hedge fund. Each contract has a contract id, budget and task. For One constraint is that each contract has exactly one financial officer that is responsible and at least one client. There can also be more than 1 financial officer in 1 location. There is one office location for hedge fund with address and phone number. Draw an ER diagram for the above description...Database Management