ACCT6001 Assessment 4 – Database Application – Case Study
ASSESSMENT BRIEF Topic Code and Title ACCT6001 Accounting Info Methods Evaluation Evaluation four – Database Utility - Case Research Particular person/Group Particular person Studying Outcomes (b) Clarify the traits of relational databases and their position in creation and communication of enterprise intelligence. (c) Determine and assess IT controls, auditing, moral, privateness and safety points with respect to info. (d) Apply technical information and expertise in creating info for the office utilizing spreadsheets and relational databases. (e) Talk with IT professionals, stakeholders and consumer teams of data programs. Submission By 11:55pm AEST/AEDT Sunday finish of Week 11/Module 6.1 For Intensive class: By 11:55pm AEST/AEDT Sunday finish of Week 6/Module 6.2 Weighting 30% Whole Marks 100 marks Context: The goal of this evaluation is to evaluate the scholar’s capacity to unravel enterprise issues utilizing database design instruments and software program. It additionally goals to allow college students to consider the impacts of utilizing IT in Companies and talk key points by way of a written report. Many companies rely on the correct recording, updating and monitoring of their knowledge on a minute-to-minute foundation. Workers entry this knowledge utilizing databases. An understanding of this know-how permits enterprise professionals to have the ability to carry out their work successfully. The purpose of this analysis is to survey the understudy's capability to deal with enterprise points using knowledge set plan gadgets and programming. It moreover expects to empower understudies to think about the consequences of using IT in Companies and convey details of curiosity by way of a composed report. Quite a few organizations depend upon the exact account, refreshing and following of their info on a second to-minute premise. Representatives entry this info using knowledge units. A comprehension of this innovation permits enterprise consultants to have the choice to play out their work adequately. Lodging Directions You'll want to plan and perform the info set using Microsoft Entry. (1) Present a phrase report containing the accompanying: a) Introduction - a synopsis of the contextual evaluation b) Examine numerous social info bases (for instance Microsoft Entry and SQL Server) c) Database Design: E-R Diagram d) Define how circulated knowledge set innovation (for instance Blockchain) contrasts from typical knowledge units like Microsoft Entry. (2) Present the Microsoft Entry paperwork utilized in making the tables, buildings, inquiries and experiences Janie's Pet Minding Submission Directions You'll want to design and implement the database utilizing Microsoft Entry. (1) Present a phrase doc containing the next: a) Introduction - a abstract of the case research b) Examine totally different relational databases (e.g. Microsoft Entry and SQL Server) c) Database Design: E-R Diagram d) Define how distributed database know-how (e.g. Blockchain) differs from conventional databases like Microsoft Entry. (2) Present the Microsoft Entry recordsdata utilized in creating the tables, types, queries and experiences Janie’s Pet Minding Janie is an area provider of pet strolling and sitting providers for enterprise folks. The plan is to ultimately develop the enterprise to additionally present on-line equipment to pet homeowners. A number of years after beginning, the enterprise has skilled rising demand for the providers provided. Subsequently, Janie wants an accounting system to document transactions and handle the small print of consumers and their pets. As a result of development of the enterprise, Janie desires to rent a part-time employee to develop and handle a system for processing orders. Having efficiently utilized for the job, you start researching with Janie about how the corporate works. YOU: Inform me about how you're taking orders. JANIE: When a possible buyer requests a job, I first take down all the buyer info, such because the buyer’s: first and final identify, road tackle, metropolis, state, and postcode. I additionally request their cellphone quantity (work and cell) together with their e-mail tackle in case I've pressing issues that should be attended. YOU: Sorry to interrupt, however can some prospects have the identical identify? JANIE: Sure. As I used to be saying, then I document all the details about their pets, such because the pet’s identify, date of delivery, gender, sort of animal, a photograph, together with particulars of equipment utilized by the pet. YOU: What different info would you wish to document within the database? JANIE: Nicely, I then present the purchasers an inventory of the providers that I provide. Right here, I element the providers together with day stays, strolling, in a single day stays and pet taxi providers. Every has a special price, which must be recorded within the database. When the client is able to order a service, I full a kind with details about the client, pet, pickup date, and fee methodology (Money, bank card, cheque, account) recorded on the highest of the shape. Nevertheless, I typically make copying errors and would recognize it if I didn't should enter repetitive info every time. I then put the date on the prime and often embody an order quantity that I've created. After that heading, I checklist the service(s) the client desires, together with amount. YOU: What different info would you wish to get out of the database? JANIE: I would love to have the ability to: • take orders rapidly, as a result of sure instances are very busy for me. • present what number of providers are as a consequence of be carried out every week. • change costs simply, as a result of the price of offering providers is rising quick. YOU: I can create a kind so that you can rapidly enter particulars in regards to the providers provided, and queries will enable you to with the opposite two duties. I may also enable you to handle your small business with particular queries which may enable you to enhance the providers provided to shoppers. Are you able to consider some evaluation that might be useful? JANIE: To enhance my promoting campaigns and total administration of the enterprise, I'd like to see: • my best-selling providers • who my finest prospects have been • a report of what accounts stays unpaid in addition to a break down of how prospects have paid (for financial institution reconciliation and money administration functions). Earlier than working the report, I'd additionally like a straightforward method to replace the fee data in my database. Required: (1) Why ought to Janie implement a Microsoft Entry database for her enterprise versus one other database answer akin to Microsoft SQL Server? Present justification in your reply by evaluating various kinds of databases. (2) Create an E-R Diagram for Janie’s enterprise utilizing a Diagram Editor or Microsoft Entry’ relationship supervisor. (three) Create tables utilizing the next pointers. (a) Enter data for a minimum of ten prospects. Use a hypothetical identify, tackle, cellphone quantity, and e-mail tackle particulars to create buyer data. Assume that the purchasers are situated in Australian cities and states. (b) Enter a minimum of 4 data for the providers provided together with: day stays, strolling, in a single day stays and pet taxi providers. Assume that each one attire besides headwear is available in small, medium, and enormous sizes. (c) Every buyer ought to have a minimum of one order; just a few prospects ought to place two orders. Every order ought to include a minimum of one service and a few should embody a number of providers. (d) Appropriately restrict the dimensions of the textual content fields; for instance, a phone quantity doesn't want the default size of 255 characters. (four) Create types utilizing the next pointers (a) Type 1: Create a kind primarily based in your Pets desk. Save the shape as “Type 1_Pet”. Your kind ought to resemble that in Determine 1 and embody a photograph of the pet. Determine 1 (b) Type 2: Create a kind and sub-form primarily based in your Orders and Order Particulars tables. Save the shape as “Type 1_Order”. Your kind ought to resemble that in Determine 2. Determine 2 (c) Type three: Create a kind and save the shape as “Type 3_Main Menu”. Your kind ought to embody hyperlinks to every of the types in your database by embedding a macro when a Form is clicked as proven in Determine three (Be aware: photos will not be required). Determine three (d) Type four: Create a kind and save the shape as “Type 4_Main Menu”. Your kind ought to embody hyperlinks to every of the types in your database by embedding a macro when a Form is clicked as proven in Determine four (Be aware: photos will not be required however be constant in your presentation of types). Determine four (5) Create the next queries in your database (a) Question 1: Create a choose question known as “Question 1_Services Due” that shows an inventory of all providers which might be as a consequence of be carried out inside a particular date vary. Your output ought to resemble that proven in Determine 5, though your knowledge can be totally different. Determine 5 (b) Question 2: Create a parameter/replace that prompts for the incremental quantity of a worth improve after which prompts for the service ID or service description. Save the question as “Question 2_Price Change”. Take a look at the question by including $zero.25 to the price of a service. View the modified worth in your datasheet view of the up to date desk. (c) Question three: Create a question known as “Question 3_Best Promoting Companies”. Checklist the service descriptions and decide what number of orders and the portions which have been obtained for every service. Report the quantities in columns labelled “Hours Ordered” and “Variety of Orders” (Be aware: these column labels would require adjustments from the default setting supplied by the question generator). Kind the output. Your output ought to resemble the format proven in Determine 6, however the knowledge can be totally different. Determine 6 (d) Question four: Create a question known as “Question 4_Best Clients” that lists the purchasers’ names, cellphone numbers, hours ordered, variety of orders and the whole quantities of their orders (Be aware: these column labels would require adjustments from the default setting supplied by the question generator). You'll have to calculate the order quantities and type the output. Your output ought to resemble the format proven in Determine 7, however the knowledge can be totally different. Determine 7 (e) Question 5: Create an motion/replace question that change the “Paid” discipline of orders with a “Money” fee methodology by prompting the consumer to enter a “from date” and “to this point” vary. Save the question as “Question 5_Paid Change”. Take a look at the question by working the question for the primary week of money funds saved within the order desk. View the modified values in your datasheet view of the up to date desk (6) Create the next experiences in your database (a) Report 1: Create a report named “Report 1_Customers by Location”. The information for the report will originate from a question, by which all prospects who order providers between a pre-defined date vary are included within the report (use the parameters and a standards filter such “ =[StartDate] And [EndDate]+1)” to filter the question knowledge. Then you definately calculate the Whole gross sales (Value multiplied by the Amount of providers ordered in that date vary). The date vary for the question must be displayed on the prime of the report. The report’s output must be grouped by Suburb and embody headings for Avenue Handle, First Title, Final Title, Buyer E-mail, and Whole. Embrace a Whole for every group (suburb) displayed in a report. Guarantee that all column headings and knowledge are seen and that each one cash quantities are formatted correctly into forex. Relying in your knowledge, your output ought to resemble that proven in Determine eight. (a) Report 1: Create a report named "Report 1_Customers by Location". The knowledge for the report will begin from a query, by which all shoppers who request administrations between a pre-characterized date vary are remembered for the report (make the most of the boundaries and a measures channel such " =[StartDate] And [EndDate]+1)" to channel the inquiry info. At that time you work the Whole offers (Value elevated by the Amount of administrations requested in that date vary). The date vary for the query should be proven on the highest level of the report. The report's yield should be gathered by Suburb and incorporate headings for Avenue Handle, First Title, Final Title, Buyer E-mail, and Whole. Incorporate a Whole for every gathering (suburb) confirmed in a report. Be certain that all phase headings and data are noticeable and that each one money sums are organized appropriately into cash. Contingent upon your info, your yield should appear to be that appeared in Determine eight. Determine eight (b) Report 2: Create a report named “Report 2_Orders by Cost Technique”. Convey the Favourite Colours question output right into a report. Save the report as Favourite Colours. Guarantee that all column headings and knowledge are seen. Relying in your knowledge, your report ought to resemble that in Determine 9. Determine 9 (7) Clarify to Janie how distributed database applied sciences akin to Blockchain differ from conventional databases like Microsoft Entry? Studying Rubric: Evaluation 1 Evaluation Standards Fail Implementation and comparability of databases 15% Unsatisfactory clarification supplied may be very basic, lacks element, doesn't reply the query. Passable clarification supplied, a number of justifications mentioned, lack detailed clarification. Good clarification supplied, a number of justifications mentioned. Explanations are detailed however some will not be convincing. Excellent clarification and justification. Explanations are convincing. Predominant issues are recognized and mentioned in particulars. Offered some examples. Wonderful clarification and justifications supplied. Predominant issues are recognized and prioritised. Every downside is mentioned intimately. Examples had been supplied for every downside. E-R Diagram 15% E-R Diagram is wrong. Greater than 50% of the entities, attributes and relationships recognized are incorrect. E-R diagram is full however some attributes and relationships are incorrect. Some entities recognized shouldn't be an entity. Round 50% of attributes are lacking (or incorrect) and incorrect relationships are recognized. E-R diagram is full. All entities recognized are appropriate. Round 25% of the attributes and relationships are lacking or incorrect. E-R diagram is full. Recognized entities had been appropriate and full. Attributes had been appropriate and full. One or two relationships had been lacking (or incorrect) E-R Diagram is full. All entities, attributes and relationships are recognized accurately. Database Tables 20% Database tables are incorrect and incomplete. E-R Diagram is just not accurately translated to database tables. Majority of the tables, attributes are lacking. Database desk is full. All entities are translated into tables. Some attributes of the ER Diagram will not be within the desk and sorts of attributes are incorrect. Database desk is full. All entities are translated into tables. Attributes are all current and relationships amongst tables are established (major keys and Database desk is full. All entities are accurately and utterly translated into tables. Attributes and sorts of attributes had been accurately recognized. All knowledge within the desk had been entered. Database desk is full. All entities are accurately and utterly translated into tables. Attributes and sorts of attributes are accurately recognized. of 11 Not all entities had been translated into tables. Tables will not be normalised. Relationships will not be translated to tables (major keys and international key are incorrect). Tables will not be normalised. Some knowledge within the desk had been entered. international keys are principally appropriate) All knowledge within the desk had been entered. A lot of the attributes have appropriate varieties. Some tables are normalised. Most desk relationships are appropriate (major keys and international keys and their relationship have been principally accurately established). All tables are normalised to 3rd regular kind. All knowledge within the desk are entered. All desk relationships are appropriate (major and international keys and their relationships are all accurately recognized) All tables are normalised to 3rd regular kind. Queries 25% SQL queries and generated are principally incorrect. Complicated queries will not be answered Greater than 50% of the SQL queries are appropriate. Complicated queries are principally incorrect. Virtually all queries are appropriate (one or two incorrect queries). Some advanced queries had been answered. All SQL queries are appropriate. Can generate advanced queries. Kinds and Reviews Unsatisfactory types. Kinds doesn't enter knowledge. Reviews are principally incorrect. No report formatting used. Passable types. Some hyperlinks to the tables will not be functioning. Some knowledge can't be entered within the tables through types. Good types. Most knowledge will be entered within the tables through types. Some design had been integrated within the types however not skilled trying. Excellent types. All components of the types are created. All knowledge will be entered through types. Design had been integrated within the types. Considerably skilled trying. Wonderful kind. All components of the types are created. All knowledge will be entered through types. Skilled trying types. 15% Easy design integrated within the types. Not skilled trying. Virtually all the experiences are appropriate (one or two incorrect). Report formatting used. The entire experiences are appropriate Report formatting used extensively. of 11 Blockchain (distributed) databases versus conventional (relational) databases Makes assertions in regards to the moral, privateness and safety points that aren't justified. Some points are justified by arguments and never merely assertions. Points recognized are acceptable. Arguments are offered to justify the problems. Points recognized are acceptable. Arguments are offered to justify the problems. Points recognized are acceptable. Arguments are offered to justify the problems. Takes into consideration the complexities of the problems. Different viewpoints had been acknowledged. Precisely takes into consideration the complexities of the problems. Different viewpoints had been acknowledged. Precisely takes into consideration the complexities of the problems and supplied examples. Different viewpoints had been acknowledged. 10% Justifies any conclusions attain with arguments and never merely assertions. Justifies any conclusions reached with well-developed arguments and never merely assertions. Justifies any conclusions attain with well-developed arguments and effectively articulated viewpoint on the problems and substantiated by analysis. of 11