fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

250 words

Error goes here

Students Who Viewed This Also Studied

6 Pages
Leadership

(Task) - Write (1200 words) in which you reflect on your personal learning experience during the last 11 weeks. Use any format that works for you. It is important that you maintain a weekly diary/lear ...

Type

Assignment

Subject

1 Page
us budget

Please answer the following questions: •Should the U.S. budget run a deficit? If yes, what are the benefits? If no, why not? •Is our tax system really progressive? Why or why not? ...

Type

Essays

Subject

15 Pages
Green Rent Agency

The Green Rent Agency manages properties for rent in South East London.  Clients who register at the agency provide personal details and information on the type of property which they are looking ...

Type

Programming

Subject

8 Pages
Business and Corporate Law

Swimmingpool Co Pty Ltd employs Martin as the manager of their Tasmanian sales division. Martin is to quote to potential customers the cost of installing the various pools that the company offers, to ...

Type

Assignment

Subject

COIT20247 Database Design and Development

Question

Answered

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. The employees of CQCP mainly consist of analysts, portfolio managers and administrative staff. Each employee is given a job title. The duty of the analysts is regularly to review for various currencies that are traded in Australian financial market and make recommendations based on their research, including a comprehensive fundamental analysis and a thorough technical analysis. Each analyst is recorded with his/her ID, full name, address, phone number (including mobile phone) and expertise area. The recommendation could be ‘buy’, ‘sell’, or ‘hold’, with a brief reason. Of course the exchange rate of a currency against Australian dollar in market could vary significantly at any time. This is because the financial market is a highly complicated place where numerous factors like the concurrency of investment and speculation, macroeconomics performance of a country even a geo-political event all impact the actual exchange rate. So the recommendation should be time-sensitive. This means that a ‘buy’ recommendation for a particular currency at a time could be downgraded as ‘sell’ recommendation at other times. The currency can be described by its code, name, current interest rate and the rating information. The rating is normally conducted by an internationally recognized credit-rating agency like Standard & Poor, Moody and Fitch. In Australian FX trading market, a 3-letter code can uniquely identify a currency. As an example, the currency of US dollar has the code USD, with interest rate 1.0% set by the Federal Reserve Bank, and the rating is AA- from Standard & Poor. A currency may receive multiple ratings from different agencies. Appendix A lists some major currencies traded in Australian FX trading market. The personal information (address, phone and qualification) of managers and administrative staff is also required to be recorded into the database. Each manager may manage multiple portfolios. Each portfolio has its own ID. Conceptually a portfolio can be regarded as equivalent to an account. However a portfolio should be only associated to one client. In addition, the portfolio could contain the data like available cash. Although CQCP provides service for all aspects of the wealth management, the database to be developed in this case study only concerns its core business – foreign currency trading. When a manager decides to make a trade, he/she will trade the currency for a particular portfolio. In other words, the managers trade the currencies on behalf of clients rather than for themselves. The aim of trading is to try to make a profit when the managers buy and sell foreign currencies. A trade or a deal is defined as using Australian dollar to buy other currencies or other currencies you hold are sold in terms of Australian dollar, through an online trading platform. The database will record the trade details like amount or quantity traded, trade mode (buy or sell), price or exchange rate per currency unit (for example, currently the exchange rate of US dollar to Australian dollar is 1.28 approximately, that means 1 US dollar is sold/bought with 1.28 Australian dollar), and transaction date. The client normally can be categorized into three types: individual, trustee and corporate investor. Their IDs, names, addresses, and contact phones should be recorded. In addition, the Tax File Number (TFN) of an individual client is required. For a trustee client, a corresponding trust account is required to nominate; whereas for a corporate client, an Australian Business Number (ABN) is an essential data item.

COIT20247 Database Design and Development

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

17 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com has proved to be the best cheap assignment help provider in USA. Despite keeping the prices to a minimum, we keep providing top-notch quality college paper writing services for all types of academic papers. Our wide range of services includes report writing help, help with essays, dissertation writing services, coursework help. Students from all corners of the USA prefer to pay our experts for writing top quality assignments. Moreover, it is guaranteed they won't regret for paying our experts to write assignment.

More COIT20247 Database Design and Development: Questions & Answers

Q

(Task) - Write (1200 words) in which you reflect on your personal learning experience during the last 11 weeks. Use any format that works for you. It is important that you maintain a weekly diary/learning journal/learning log to record your weekly learning experiences. You may draw on the activities ...

View Answer
Q

Please answer the following questions: •Should the U.S. budget run a deficit? If yes, what are the benefits? If no, why not? •Is our tax system really progressive? Why or why not? ...

View Answer
Q

The Green Rent Agency manages properties for rent in South East London.  Clients who register at the agency provide personal details and information on the type of property which they are looking for, the location and the maximum rent that they are prepared to pay.  The agency holds detail ...

View Answer
Q

Swimmingpool Co Pty Ltd employs Martin as the manager of their Tasmanian sales division. Martin is to quote to potential customers the cost of installing the various pools that the company offers, to draw up any new contracts on behalf of the company and further to ensure that a deposit is paid by p ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

expert
student rating student rating student rating student rating student rating
Herman Berens

MSc in Psychology

1896 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Richard McManus

PhD in Sociology with Specialization in Communication for Social Change

233 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Jaydon Key

I am a research scholar in Columbia University and am pursuing my doctorate degree in Physics.

150 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Wayne Flynn

MSc in Electrical engineering

424 - Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 11 Pages, Deadline: 11 days

It was great assignment , i have got very high score on this course . many thanks

flag User ID: 7***78 Saudi Arabia

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 12 Pages, Deadline: 17 days

Thank you for another fantastic assignment help, i very pleased on this work i must say once again thank you

flag User ID: 7***88 Melbourne, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Marketing

Assignment: 3 Pages, Deadline: 2 days

I am happy with the result. The paper is concise and ideas are well presented. Key details needed to respond to the task are evident.

flag User ID: 7***73 Indonesia

student rating student rating student rating student rating student rating
08 Dec 2021

Marketing

Assignment: 2 Pages, Deadline: 1 day

The paper is well-written and covered the required task. I am happy for the output.

flag User ID: 7***73 Indonesia

student rating student rating student rating student rating student rating
08 Dec 2021

Finance

Home Work: 1 Page, Deadline: 7 days

thanks for the grades its very nice to get your great and supportive services, appreciate the expert and the whole team.

flag User ID: 6***96 Kashipur, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Business Law

Home Work: 1 Page, Deadline: 6 days

I got 52 marks out of 100 marks, i am really happy for these grades in business law, because its tough marking subject . really appreciate the expert ...

flag User ID: 6***96 Kashipur, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Project Management

Home Work: 1 Page, Deadline: 4 days

i got 64 marks out 100 marks, thank you so much for the efforts and supports. I appreciate the whole team.

flag User ID: 6***96 Kashipur, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Home Work: 1 Page, Deadline: 6 days

i got 70 marks out 100 . Thanks for the grades and efforts made by the whole team.Great!

flag User ID: 6***96 Kashipur, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 8 Pages, Deadline: 13 days

Quick response and doing my escalation properly, satisfied in general and will be happy to make another order anytime soon.

flag User ID: 4***31 Swansea, Great Britain

student rating student rating student rating student rating student rating
08 Dec 2021

Assignment

Home Work: 1 Page, Deadline: 7 hours

This was spot on! Thank you so much for your help! This was spot on! Thank you so much for your help!T his was spot on! Thank you so much for your hel ...

flag User ID: 8***59 United States

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 11 Pages, Deadline: 11 days

It was great assignment , i have got very high score on this course . many thanks

flag User ID: 7***78 Saudi Arabia

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 12 Pages, Deadline: 17 days

Thank you for another fantastic assignment help, i very pleased on this work i must say once again thank you

flag User ID: 7***88 Melbourne, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Marketing

Assignment: 3 Pages, Deadline: 2 days

I am happy with the result. The paper is concise and ideas are well presented. Key details needed to respond to the task are evident.

flag User ID: 7***73 Indonesia

student rating student rating student rating student rating student rating
08 Dec 2021

Marketing

Assignment: 2 Pages, Deadline: 1 day

The paper is well-written and covered the required task. I am happy for the output.

flag User ID: 7***73 Indonesia

student rating student rating student rating student rating student rating
08 Dec 2021

Finance

Home Work: 1 Page, Deadline: 7 days

thanks for the grades its very nice to get your great and supportive services, appreciate the expert and the whole team.

flag User ID: 6***96 Kashipur, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Business Law

Home Work: 1 Page, Deadline: 6 days

I got 52 marks out of 100 marks, i am really happy for these grades in business law, because its tough marking subject . really appreciate the expert ...

flag User ID: 6***96 Kashipur, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Project Management

Home Work: 1 Page, Deadline: 4 days

i got 64 marks out 100 marks, thank you so much for the efforts and supports. I appreciate the whole team.

flag User ID: 6***96 Kashipur, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Home Work: 1 Page, Deadline: 6 days

i got 70 marks out 100 . Thanks for the grades and efforts made by the whole team.Great!

flag User ID: 6***96 Kashipur, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 8 Pages, Deadline: 13 days

Quick response and doing my escalation properly, satisfied in general and will be happy to make another order anytime soon.

flag User ID: 4***31 Swansea, Great Britain

student rating student rating student rating student rating student rating
08 Dec 2021

Assignment

Home Work: 1 Page, Deadline: 7 hours

This was spot on! Thank you so much for your help! This was spot on! Thank you so much for your help!T his was spot on! Thank you so much for your hel ...

flag User ID: 8***59 United States

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?