MAC002 Accounting Information Systems

Free Samples

MAC002 Accounting Information Systems

.cms-body-content table{width:100%!important;} #subhidecontent{ position: relative;
overflow-x: auto;
width: 100%;}

MAC002 Accounting Information Systems

0 Download5 Pages / 1,019 Words

Course Code: MAC002
University: Universal Business School Sydney

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Questions:
With the above information, you are required to do the following:1) Prepare an integrated REA diagram for the revenue and expenditure cycles of Amazon Travel Club2) Prepare a set of tables to implement your data model in a relational database. Assign every attribute mentioned in the narrative to the appropriate table

Answer:
The resource-event-agent or REA model is a method to conceptualize the elements of economic transactions. The Resources are referred to as the claims or economic resource. These resources are considered as objects which are controlled by agent(s). The examples of economic or claims resources are rights, cash, goods, obligations and more. Transactions, events, circumstanced and few other factors are considered to be the events of the REA diagram. These events have huge impact on the resources. Agents are responsible for managing the resources of the organization. In figure 1, the agents either buy or sell the resources.
The books and cash are the resources of Amazon Travel Club. The sales and cash receipt are the event. The sales representatives, shipping clerk, members, system and cash recipient are the agents. The REA diagram in the figure is developed using the abovementioned elements.
In figure 1, it has been shown that the organization two resources such as books and cash. It is very easy to understand that the organization sales the books and collects the cash. The outflow means that the books amount is decreasing after each sale. In contrast with that the inflow signifies that cash increases as the sales process increases. This successfully illustrates that with the increase of sales, the cash of the organization will increase and the book stock will decrease. The sales process is indirectly related to the cash receipt process.
As per the illustration done in the figure 1, the sales representative enters the order into the system. As the system is not a resource so it is not mentioned in the sales event related process. However, the system is a very powerful and most essential part of managing processes and stock of the books. The shipping clerk packs the ordered book(s). It is to be remembered that only if the order is complete, the order will be delivered otherwise the order will be on hold. In order to make the diagram understandable and simple we have not mentioned any condition involved in the order process. The conventional REA diagrams does not also support conditions, the conditions are the factors that are to be implemented through the developing language. The REA and Database only support the basic idea behind the conditions and business process.
The cash receipt event is the way of making profit for the organization. Amazon Travel Club collects the payment from the member and transfer that amount to the organization account. The cash receipts department is responsible for collecting the capital from the member. They handle the payment related processes. The system has active role in payment process. It may happen that a member has not paid the payment for thirty days. In that case, the system will send a notification to the member and automatically increase the payable amount by 6% as interest.
It is not always right to consider the system as an agent, often the system can act as the resource. As per the selected case study, the system acts as controller of the resources, both the books and cash, therefore, in the figure 1, the system is considered as agent.
Tables for Relational Database:

Table Name: Book

Attribute Name

Attribute Type

Constraint

Book_ID

INT

Primary Key

Book_Name

Varchar (40)

None

Book_Author

Varchar (40)

None

Book_Price

NUMBER(10,2)

None

Book_Published_Year

YEAR

None

Book_Description

Varchar (200)

None

Stock_Amount

INT

None

 

Table Name: Members

Attribute Name

Attribute Type

Constraint

Member_ID

INT

Primary Key

Member_Name

Varchar (40)

None

Member_Contact

Varchar (40)

None

Member_Address

Varchar (40)

None

Member_Email

Varchar (40)

None

Member_Login_ID

Varchar (40)

Unique

Member_Password

Varchar (40)

None

 

Table Name: Order

Attribute Name

Attribute Type

Constraint

Order_ID

INT

Primary Key

Member_ID

INT

Foreign Key

Date

Date

None

 

Table Name: Order_Book

Attribute Name

Attribute Type

Constraint

Order_ID

INT

Primary Key, Foreign Key

Book_ID

INT

Primary Key, Foreign Key

Amount

INT

None

Total_Cost

NUMBER(10,2)

None

 

Table Name: Sales_Representatives

Attribute Name

Attribute Type

Constraint

SR_ID

INT

Primary Key

SR_Name

Varchar (40)

None

SR_Contact

Varchar (40)

None

SR_Address

Varchar (40)

None

SR_Email

Varchar (40)

None

SR_Login_ID

Varchar (40)

Unique

SR_Password

Varchar (40)

None

SR_Salary

NUMBER(10,2)

None

 

Table Name: Order_Entered_By

Attribute Name

Attribute Type

Constraint

Order_ID

INT

Primary Key, Foreign Key

SR_ID

INT

Primary Key, Foreign Key

Booking_Method

Varchar (40)

None

 

Table Name: Shipping_Clerk

Attribute Name

Attribute Type

Constraint

SC_ID

INT

Primary Key

SC_Name

Varchar (40)

None

SC_Contact

Varchar (40)

None

SC_Address

Varchar (40)

None

SC_Email

Varchar (40)

None

SC_Login_ID

Varchar (40)

Unique

SC_Password

Varchar (40)

None

SC_Salary

NUMBER(10,2)

None

 

Table Name: Order_Packed_By

Attribute Name

Attribute Type

Constraint

Order_ID

INT

Primary Key, Foreign Key

SC_ID

INT

Primary Key, Foreign Key

Complete

Boolean

None

 

Table Name: Invoice

Attribute Name

Attribute Type

Constraint

Invoice_ID

INT

Primary Key

Order_ID

INT

Foreign Key

Date

Date

None

Total_Cost

NUMBER(10,2)

None

 

Table Name: Payment

Attribute Name

Attribute Type

Constraint

Payment_ID

INT

Primary Key

Invoice_ID

INT

Foreign Key

Date

Date

None

Paid_Amount

NUMBER(10,2)

None

Bibliography:
Arasu, A., Babcock, B., Babu, S., Cieslewicz, J., Datar, M., Ito, K., … & Widom, J. (2016). Stream: The stanford data stream management system. In Data Stream Management (pp. 317-336). Springer, Berlin, Heidelberg.
Azevedo, C. L., Iacob, M. E., Almeida, J. P. A., van Sinderen, M., Pires, L. F., & Guizzardi, G. (2015). Modeling resources and capabilities in enterprise architecture: A well-founded ontology-based proposal for ArchiMate. Information Systems, 54, 235-262.
Coronel, C., & Morris, S. (2016). Database systems: design, implementation, & management. Cengage Learning.
Dunn, C. L., Gerard, G. J., & Grabski, S. V. (2016). Resources-Events-Agents Design Theory: A Revolutionary Approach to Enterprise System Design. CAIS, 38, 29.
Guarino, N., Guizzardi, G., & Sales, T. P. (2018). On the ontological nature of REA core relations. In 12th Int. Workshop on Value Modeling and Business Ontologies.
Nidzwetzki, J. K., & Güting, R. H. (2016). DISTRIBUTED SECONDO: An extensible highly available and scalable database management system. FernUniversität, Fakultät für Mathematik und Informatik.

Free Membership to World’s Largest Sample Bank

To View this & another 50000+ free samples. Please put
your valid email id.

E-mail

Yes, alert me for offers and important updates

Submit 

Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

UploadUnique Document

DocumentUnder Evaluation

Get Moneyinto Your Wallet

Total 5 pages

PAY 3 USD TO DOWNLOAD

*The content must not be available online or in our existing Database to qualify as
unique.

Cite This Work
To export a reference to this article please select a referencing stye below:

APA
MLA
Harvard
OSCOLA
Vancouver

My Assignment Help. (2021). Accounting Information Systems. Retrieved from https://myassignmenthelp.com/free-samples/mac002-accounting-information-systems/travel-club.html.

“Accounting Information Systems.” My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/mac002-accounting-information-systems/travel-club.html.

My Assignment Help (2021) Accounting Information Systems [Online]. Available from: https://myassignmenthelp.com/free-samples/mac002-accounting-information-systems/travel-club.html[Accessed 18 December 2021].

My Assignment Help. ‘Accounting Information Systems’ (My Assignment Help, 2021) accessed 18 December 2021.

My Assignment Help. Accounting Information Systems [Internet]. My Assignment Help. 2021 [cited 18 December 2021]. Available from: https://myassignmenthelp.com/free-samples/mac002-accounting-information-systems/travel-club.html.

×
.close{position: absolute;right: 5px;z-index: 999;opacity: 1;color: #ff8b00;}

×

Thank you for your interest
The respective sample has been mail to your register email id

×

CONGRATS!
$20 Credited
successfully in your wallet.
* $5 to be used on order value more than $50. Valid for
only 1
month.

Account created successfully!
We have sent login details on your registered email.

User:

Password:

The deadline is coming closer, and you are still wondering “Who will write my paper for me?” Well, if you have other things to attend, or are feeling under the weather, then the best option for you is to take the much-needed essay help from MyAssignmenthelp.com. Writing essays are already quite tedious, and focusing on it when you have other things on your plate seems rather impossible. Simply avail our services. To ensure the paper is error-free, our essay editors invest extra time in proofreading and plagiarism-checking.

Latest Management Samples

div#loaddata .card img {max-width: 100%;
}

MPM755 Building Success In Commerce
Download :
0 | Pages :
9

Course Code: MPM755
University: Deakin University

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answers:
Introduction
The process of developing a successful business entity requires a multidimensional analysis of several factors that relate to the internal and external environment in commerce. The areas covered in this current unit are essential in transforming the business perspective regarding the key commerce factors such as ethics, technology, culture, entrepreneurship, leadership, culture, and globalization (Nzelibe, 1996; Barza, 2…
Read
More

SNM660 Evidence Based Practice
Download :
0 | Pages :
8

Course Code: SNM660
University: The University Of Sheffield

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answers:
Critical reflection on the objective, design, methodology and outcome of the research undertaken Assessment-I
Smoking and tobacco addiction is one of the few among the most basic general restorative issues, particularly to developed nations such as the UK. It has been represented that among all risk segments smoking is the fourth driving purpose behind infections and other several ailments like asthma, breathing and problems in the l…
Read
More
Tags:
Australia Maidstone Management Business management with marketing University of New South Wales Masters in Business Administration 

BSBHRM513 Manage Workforce Planning
Download :
0 | Pages :
20

Course Code: BSBHRM513
University: Tafe NSW

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Task 1
1.0 Data on staff turnover and demographics
That includes the staffing information of JKL industries for the fiscal year of 2014-15, it can be said that the company is having problems related to employee turnover. For the role of Senior Manager in Sydney, the organization needs 4 managers; however, one manager is exiting. It will make one empty position which might hurt the decision making process. On the other hand, In Brisba…
Read
More

MKT2031 Issues In Small Business And Entrepreneurship
Download :
0 | Pages :
5

Course Code: MKT2031
University: University Of Northampton

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answer:
Entrepreneurial ventures
Entrepreneurship is the capacity and willingness to develop, manage, and put in order operations of any business venture with an intention to make profits despite the risks that may be involved in such venture. Small and large businesses have a vital role to play in the overall performance of the economy. It is, therefore, necessary to consider the difference between entrepreneurial ventures, individual, and c…
Read
More
Tags:
Turkey Istanbul Management University of Employee Masters in Business Administration 

MN506 System Management
Download :
0 | Pages :
7

Course Code: MN506
University: Melbourne Institute Of Technology

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Introduction
An operating system (OS) is defined as a system software that is installed in the systems for the management of the hardware along with the other software resources. Every computer system and mobile device requires an operating system for functioning and execution of operations. There is a great use of mobile devices such as tablets and Smartphones that has increased. One of the widely used and implemented operating syste…
Read
More
Tags:
Australia Cheltenham Computer Science Litigation and Dispute Management University of New South Wales Information Technology 

Next