- Entity-relationship data model
You are required to develop an ER model to represent the information requirements for the application scenario (CQCP) as described on last two pages.
Entity and attribute definitions
You are required to write brief definitions for the entities and attributes in your model. For each entity and attribute in your model, write a sentence to describe the meaning of that entity or attribute. You should refer to the sections Naming and Defining Entity Types and Naming and Defining Attributes in the textbook.
The application scenario: CQ Capital Partner (CQCP)
Central Queensland Capital Partners (CQCP) is a leading investment management company in Australia with the headquarter office located in Rockhmapton, Queensland. It was founded by a group of professional funding managers and foreign currency analysts. Specialized in foreign currency exchange (FX) trading in Australian financial market, it provides investment in FX & consultant services to institutional investors and private clients. With the growth of its business, CQCP needs a relational database to keep track of all employees, their clients, analyst’s reviews for foreign currencies, portfolio managed, as well as the currency trade history.