代寫 > 布里斯班作業代寫 > >


AFW2851– Accounting Information Systems & Financial Mode

AFW2851– Accounting Information Systems & Financial Mode

Mike’s Movie Magic
Mike has been operating a small sole trader “hire” business for movies on DVDs and
blue ray disks (with customers visiting his store to physically hire DVDs and blue ray
disks). Since opening his business three months ago, the “membership” (customers) of
his business has grown rapidly and he is now struggling to keep track of the “hires” on a
spreadsheet based system. Mike currently has approximately one thousand DVD and
blue ray disks in his store and has multiple copies of many movies. When studios release
new movies that Mike thinks will be popular for hire he typically will purchase ten to
fifteen copies of the same movie across DVD and blue ray formats.
Mike charges the same rate for DVD and blue ray hire, and has three categories of hire:
? Daily (most recent movie release) $4.50 per day
? Three day (slightly less recent/popular movie releases) $3.50 for the 3 day period
? Weekly (all other movies) $2.50 for the week
Mike is aware that you have some expertise in accounting information systems and has
asked for your assistance to design a logical database structure for his business.
1) Visualise the computer data entry screens that could be used to capture data for the
following business events in Mike’s business:
a) Adding a new “member” (so they are able to hire movies)
b) Adding a new “movie” (so it can be hired by members)
c) Rental of “movies” (this screen could include a listing of multiple movies as a
customer may hire several movies at a time)
d) Return of rented “movies” (once again, this screen could include a listing of
multiple movies).
Draw a representation of one of these data entry screens (indicate to which of the
business events, a, b, c, or d, your screen relates)
2) List the “data attributes” you think you would need to capture/store for each of these
four business events. What entities do you think would be involved in these business
events? Allocate the data attributes to these entities (tables). (Note: I expect that, at
this stage, your tables may have “issues” in terms of their “logical” structure; that
is, the tables have not yet been “normalized”.)
3) List your tables (from requirement 2) using the notation method shown to you during
class. Normalise these tables to third normal form (3NF), explaining in detail each
step in the process that you have undertaken in reaching your set of 3NF tables.
4) Based upon the 3NF tables that you have produced above, present the logical data
structure for your database as a Data Structure Diagram using the notation method
shown to you during class.
5) For three (3) possible reports  (*) that could be generated from your “logical” database
design, explain:
a) what information you would include on that report
b) in general terms, the purpose of that report, and
c) how you have used the “links” between the tables in your database to extract the
required information for that report.
Note:  (*) one report might be a daily listing of sales events!
Where you have used references (books, web sites etc.) in preparation for your
assignment submission, these need to be acknowledged using the APA (or Harvard) style.
For further details on referencing see the Faculty Q Manual. at:



QQ: 273427
QQ: 273427



價格性感 質量豐滿
Copyright ? 2002-2012 悉尼論文代寫,墨爾本論文代寫,悉尼作業代寫.墨爾本作業代寫.


ESSAYCASE |essay代写|assignment代写|paper代写,全球在线写作中心 EasyDue™-北美地区论文作业ESSAY代写服务机构,作业代写-覆盖100+全学科 EssayBerry:美国论文ESSAY代写服务,代写essay,统计代写,代写文章 EssayWill-论文代写网|经济代写,数学,CS代写,Assignment代写 Essaymint:专注软文代写和代写作业等服务|作业代写-100%原创高分 Essay代写,论文代写,Report代写,网课代修-浩天教育 Essay代写-Assignment「免费修改」Paper代写,-51Due留学教育 Essay代写-各学科论文代写|留学作业网课代修代做|优质的代写文章的网站 Essay代写|Assignment代写|提供留学生Essay代写服务-留学写作网 ITCS代写 | math代写,统计代写,金融代写,economic,accounting代写等