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

1 Page
Service Marketing

The topic for following question  is MacDonald.  ...

Type

Assignment

Subject

3 Pages
health sciences

In this assignment, you will select a program, quality improvement initiative, or other project from your place of employment. Assume you are presenting this program to the board for approval of fundi ...

Type

Thesis

Subject

7 Pages
ICS 462 Programming

Generate a list of classes you believe you will need to create for this assignment. For each class, create a list of methods and attributes you believe you will need. • Implement ‘stub&r ...

Type

Assignment

Subject

1 Page
management effective diversity

this is my group totpic o Discrimination (We're Going Global!) This is my part. The requirements for training, including level of acceptable quality (Rok) I send to you our group other topic ...

Type

Essays

Subject

COIS20026 Database Development and Management

Question

Answered

COIS20026 Database Development and Management (T1 2015) Assessment item 1— Entity Relationship Diagram (ERD) Due date: Midnight AEST Friday of Week 5 ASSESSMENT Weighting: 30% 1 Length: No fixed length Objectives This assessment item relates to the course learning outcomes numbers 1, 4 and 5 as stated on page 1 of the course profile. Assessment task In this assignment, you are to implement the data modelling based on the following application scenario. 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. 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. Appendix A Some major currencies traded in Australian market Code Name Interest rate Rating USD US Dollar 1.0% AA- from Standard & Poor (June 2014) EUR Euro 0 ABA from Moody (Aug.2014) JPY Japanese Yen 0 AA- from Standard &Poor (Dec.2014) CNY Chinese Yuan 5.5% Aaa from Fitch (Nov.2014) GBP Great Britain Pound 2% Aab from Fitch (Nov.2014) CAD Canadian Dollar 2.5% Aab from Fitch (Nov.2014) NZD New Zealand Dollar 2.0% Aab from Fitch (Oct.2014) HKD Hong Kong Dollar 4.5% Aaa from Fitch (Oct.2014) ZAR South African Rand 6% Bbb from Fitch (Oct.2014) DKK Danish Kroner 3% Aab from Fitch (Oct.2014) Note: (1) The interest rate and the rating result (symbol) are assumed for modelling purpose only. (2) The above specification may not be presented every detail because one of your tasks for this assignment is to do your own analysis and research based on the application scenario description and the common knowledge. 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. Your ER model must: • show all necessary entities, attributes and relationships • show unique identifiers • show multi-valued attributes (also called repeating attributes), if any • show participation and cardinality • show associative entities, if appropriate • use the notation described in the set text • use consistent and appropriate naming for entities and attributes throughout (refer to Chapter 2 & 3 of set text). Some business rules or other aspects of the case study may not be clear to you when you read the case study. If this is the case, then you should either approach your lecturer or tutor for clarification, or you may simply make an assumption and then develop your ER model accordingly. For example, the case study might not mention all relevant participation information (also called minimum cardinalities). If so, you may make an assumption about what the minimum cardinalities might reasonably be, and then show these in your ER model accordingly. You should justify each assumption in terms of the business, for example: it is assumed that each customer must have at least one order because it is assumed that the business does not record customer details until the customer places an order. To get yourself started, ask yourself, 'If I were running this business, what things would I need to keep a list of?' Write those things down. For each thing, what information would you need to record about it? 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. For example: STUDENT: A Student is a person who has enrolled in one or more programs at the university. This includes Start Uni Now high school students but does not include prospective students. Student No: Uniquely identifies each student. Student Name: The full name of the student. Date of Birth: The student’s date of birth. … PROGRAM: A Program is a program of study available at the university. Program code: Uniquely identifies each program Program name: The full name of the program. … What you should submit You should submit a Microsoft Word document containing: • A copy of your entity-relationship model(s). • A list of business rules that are apparent from the case study. • A list of any assumptions that you made (include any clarifications from your tutor) with justifications. • Your entity and attribute definitions. Your document should contain appropriate identifying information (your student number, name, course number, etc.) and should be appropriately formatted. For example, your document should contain a very brief introduction stating the purpose of the document, as well as headings for each section. Important points • You must work individually on this assignment. • The model solution to this assignment will be released approximately TWO (2) weeks after the due date. • Assignments that are submitted after the release of the model solution will receive zero. • You must state in your assignment (at the end under the heading Acknowledgements is a good place) all materials and sources you used. This may be as simple as 'This assignment was completed using only the COIS 20026 course materials' if that was all you used. • Extension requests must be submitted online (for AIC students, contact your local campus administration staff) before the assignment due date. A penalty of 5% of the total mark per calendar day will apply for late submissions without an extension, or zero if submitted after the release of the model solution. • Before submitting your assignment, review the marking criteria as shown on the marking guide (the guide will be available on the course website). Ensure that all the criteria are addressed in your submission. • After submitting your assignment, please verify that your submission was successful, i.e. download your submitted files to ensure they are correct and uncorrupted. Assessment criteria COIS20026 Assignment 1 Marking Sheet Student number: Student name: Entity-relationship data model (23 marks) Available marks Marks awarded Overall structure: Is the set of entities and relationships between them sound? (14 marks) •Will the overall design work? 4 •All necessary relationships are present? 2 •No extraneous or inappropriate entities? 2 •Unique identifiers are appropriate? 2 •Entities/relationships not apparent from the case study have been supported by appropriate assumptions? 2 •Entities follow consistent and appropriate naming standard? 2 Cardinalities: No major cardinality errors? (6 marks) •Maximum cardinalities are suitable for the business in question? 2 •Minimum cardinalities okay? 1 •Unusual cardinalities have been supported by an assumption? 2 •Naming convention is consistent? 1 Attributes: all necessary attributes are included? (3 marks) •Attributes are in the right entities? 1 •Attributes follow consistent and appropriate naming standard? 1 •Extra or “nice to have” attributes are supported by an assumption? 1 Entity and attribute definitions (4 marks) •Definitions follow the guidelines specified in the set text? 4 Assumptions, clarifications & business rules (3 marks) •Student has recognised where information is missing and assumptions/clarifications are required? 1 •Assumptions are reasonable for the business at hand? 1 •Assumptions are justified? 1 Sub-total before any possible deductions 30 0 Late penalty (enter as the number of days late) 0 Your assignment 1 total: 0 Comments:

COIS20026 Database Development and Management

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.

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

MyAssignmenthelp.com is committed to provide top-notch quality academic assistance at affordable price. To help students from different backgrounds, we have hired more than 3000 experts. Owing to in-depth knowledge in their respective subjects, they effectively provide geography assignment help, Physics assignment help, Strategic assignment help, history assignment help, art architecture assignment help and much more.

More COIS20026 Database Development and Management : Questions & Answers

Q

The topic for following question  is MacDonald.  ...

View Answer
Q

In this assignment, you will select a program, quality improvement initiative, or other project from your place of employment. Assume you are presenting this program to the board for approval of funding. Write an executive summary (850-1,000 words) to present to the board, from which they will make ...

View Answer
Q

Generate a list of classes you believe you will need to create for this assignment. For each class, create a list of methods and attributes you believe you will need. • Implement ‘stub’ versions (minimally) of the classes defined by your design and integrate with the CLI. ! 2) ...

View Answer
Q

this is my group totpic o Discrimination (We're Going Global!) This is my part. The requirements for training, including level of acceptable quality (Rok) I send to you our group other topic too, it can help you. ...

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
Khloe Pierce

Pharmaceutical and Biomedical Sciences, M.Sc from the University of Georgia

650 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Albert Ambrosio

MSc in Nursing

2632 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Jacob Galbraith

PhD in Management

1074 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Leigh Schmidt

PhD in Psychology with specialization in Developmental Psychology

207 - 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

Programing

Programming: 10 Pages, Deadline: 7 days

excellent work..great writing...on time delivery super expert...excellent work..great writing...on time delivery super expert....excellent work..great ...

flag User ID: 4***78 London, Great Britain

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

Civil Engineering

Course Work: 1 Page, Deadline: 13 hours

it was very fast and convenience, i feel very confidence, quick response very expert no long wait till they assign my assignment. thank you so much.

flag User ID: 8***26 United States

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

Management

Assignment: 20 Pages, Deadline: 9 days

thank you, I scored 97/100. Thank you to all of the writers who help me get a good score.

flag User ID: 7***60 Germany

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

It Write Up

Assignment: 5.2 Pages, Deadline: 13 days

Fine. Im okay with your work i have passed the subjrct thanks thabks for your help

flag User ID: 6***01 London, Great Britain

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

Healthcare

Home Work: 10 Pages, Deadline: 6 days

Got the great grade. Thank you the expert. Will still use this service, but if the expert can give more real life example is better.

flag User ID: 4***0 Central District, Hong Kong

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

Management

Home Work: 2.4 Pages, Deadline: 3 days

perfect and well done . I enjoy working and trusting my assignment. I recommend it to all students

flag User ID: 8***51 Offenburg, Germany

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

Healthcare

Assignment: 1.2 Pages, Deadline: 16 hours

I am happy with this good work, I like to deal with my assignment group every time

flag User ID: 5***45 Saudi Arabia

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

Programing

Programming: 10 Pages, Deadline: 7 days

excellent work..great writing...on time delivery super expert...excellent work..great writing...on time delivery super expert....excellent work..great ...

flag User ID: 4***78 London, Great Britain

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

Civil Engineering

Course Work: 1 Page, Deadline: 13 hours

it was very fast and convenience, i feel very confidence, quick response very expert no long wait till they assign my assignment. thank you so much.

flag User ID: 8***26 United States

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

Management

Assignment: 20 Pages, Deadline: 9 days

thank you, I scored 97/100. Thank you to all of the writers who help me get a good score.

flag User ID: 7***60 Germany

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

It Write Up

Assignment: 5.2 Pages, Deadline: 13 days

Fine. Im okay with your work i have passed the subjrct thanks thabks for your help

flag User ID: 6***01 London, Great Britain

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

Healthcare

Home Work: 10 Pages, Deadline: 6 days

Got the great grade. Thank you the expert. Will still use this service, but if the expert can give more real life example is better.

flag User ID: 4***0 Central District, Hong Kong

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

Management

Home Work: 2.4 Pages, Deadline: 3 days

perfect and well done . I enjoy working and trusting my assignment. I recommend it to all students

flag User ID: 8***51 Offenburg, Germany

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

Healthcare

Assignment: 1.2 Pages, Deadline: 16 hours

I am happy with this good work, I like to deal with my assignment group every time

flag User ID: 5***45 Saudi Arabia

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

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?