Order custom papers, masters thesis and dissertation in 3 guided steps; human written!
Posted: May 15th, 2022
ASSESSMENT BRIEF
Subject Code and Title ACCT6001 Accounting Information Systems
Assessment Assessment 4: Database Application
Individual/Group Individual
Learning Outcomes 1. Explain the characteristics of relational databases and their role in creation and communication of business intelligence.
2. Identify and assess IT controls, auditing, ethical, privacy and security issues with respect to information.
3. Apply technical knowledge and skills in creating information for the workplace using spreadsheets and relational databases.
4. Communicate with IT professionals, stakeholders and user groups of information systems.
Submission by tutor Thursday, 11 of May
Context:
The aim of this assessment is to assess the student’s ability to solve business problems using database design tool and software. It also aims to enable students to think about the impacts of using IT in Businesses and communicate key issues through a written report.
Absolutely! We prioritize fast delivery to ensure your dissertation, research paper, or thesis writing is completed well before the deadline. This gives you time for last-minute tweaks—like edits, corrections, or revisions—for dissertation help or essays. Need urgent homework or dissertation assistance? Reach out today and boost your chances of scoring top marks in your grading rubrics with our expert research paper and thesis writing support!
Many companies depend on the accurate recording, updating and tracking of their data on a minute-to-minute basis. Employees access this data using databases. An understanding of this technology allows business professionals to be able to perform their work effectively.
CASE STUDY
DATABASE APPLICATION
You have been assigned as coordinator for a project management company. You will be managing several ongoing projects. As part of your job, you are supposed to keep track of its commercial projects, employee and the employees’ participation in each project. Usually, each project will have multiple team members, but some projects have not been assigned to any team member. Each employee can be assigned to one or more projects. Some employees can also be on leave and will not be working on any assignment. Project leaders usually need to know the following information about their team members:
• Name
• Address
• Phone number,
• Highest degree attained
• Expertise (e.g. accounting, IS, marketing and finance)
For each project, the company must keep track of the project’s title, description, location, estimated budget and due date. For each project description, a list of associated activities is recorded and for each activity, a list of materials needed are also monitored. This list includes the material needed, cost, the date it was ordered, date expected to be delivered and actual delivery date. Each material can be sourced from different suppliers. As the coordinator, you need to monitor where the materials were sourced from. The following details you should know about the supplier:
• name of supplier
• address,
• ABN
• contact person
• contact number
Instructions:
1. You need to design and develop a new database given the information provided above. Create the E-R diagram, translate to relational schema and then normalise.
2. Create the tables, forms, reports and queries using libre Base or Microsoft Access 3.You need to create the following forms for data entry:
a. Employee Form
b. Project Form
c. Supplier Form
4.The following are the queries that should be answered by the database:
a. List of all the projects’ information
b. List of all the projects titles, description, due date and activities per project
c. List of all information about the team members of each project
d. List all the projects that are due on December 2018 5.Priority reports that are needed are the following:
a. List of the materials that were delivered on November 18 and the name of their suppliers
b. List of all the suppliers’ information
Every dissertation, research paper, or thesis we deliver is researched and written from scratch, ensuring original content tailored just for you. You’ll be the only one with access to the final dissertation or research paper, complete with proper references. Your privacy is our top priority. When you order dissertation help or thesis writing from us, your identity and payment details stay confidential, minimizing any risk of detection or content theft by third parties. We help you stay discreet, so you can focus on your goals.
SUBMISSION REQUIREMENTS:
1) A word document containing:
a) Introduction - a summary of the case study
b) Justification of the use of database / importance of data base for company
Advantages of data base and some problems of excel overcome by database.
c) Database Design: E-R Diagram
d) IT controls needed e.g access to individual/ who can have access to where of database
e) Ethical, privacy and security issues
2) Libre Office Base/Microsoft Access files used in creating the tables, forms, queries and reports
Criteria
• Need for the implementation of the database
• E-R Diagram
• Normalised Database Tables
• Queries
• Forms and Reports
• IT Controls, Ethical, Privacy and Security Issues
Learning Rubrics
Assessment Attributes Fail
(Unacceptable)
Points 0-9 Pass (Functional)
Points -10-12
Credit (Proficient)
Points 13-15
Distinction (Advanced)
Points 16-18
High Distinction (Exceptional)
Points 19-20
Need help with dissertation, thesis writing, or research papers? Our ace my homework platform is the go-to solution for college students across Australia, the UK, the USA, China, and the UAE—plagiarism-free and without AI. Share your requirements via our simple order form, secure your spot with an escrow payment, and we’ll match you with a skilled writer for dissertation help or research paper expertise. Wondering if we’re reliable? We’ve earned a 4.9/5 rating on Sitejabber and Trustpilot, backed by glowing testimonials. Plus, we offer affordable dissertation and thesis writing support—so even on a tight budget, you get maximum quality.
Points
Need for the implementation of the database
15%% Unsatisfactory explanation provided is very general, lacks detail, and does not answer the question.
Satisfactory explanation provided, several justifications discussed, lack detailed explanation.
Good explanation provided, several justifications discussed. Explanations are detailed but some are not convincing.
Very good explanation and justification. Explanations are convincing. Main problems are identified and discussed in details. Provided some examples.
Excellent explanation and justifications provided. Main problems are identified and prioritised. Each problem is discussed in detail. Examples were provided for each problem.
E-R Diagram
15% E-R Diagram is incorrect.
More than 50% of the entities, attributes and relationships identified are incorrect.
E-R diagram is complete but some attributes and
Relationshipsare incorrect.
Some entities identified should not be an entity.
Around 50% of attributes are missing (or incorrect) and incorrect relationships are identified.
E-R diagram is complete.
All entities identified are correct.
Around 25% of the attributes and relationships are missing or incorrect.
E-R diagram is complete.
Identified entities were correct and complete.
Attributes were correct and complete.
One or two relationships
were missing (or incorrect
E-R Diagram is complete.
All entities, attributes and relationships are identified correctly.
Database Tables
20% Database tables are incorrect and incomplete.
E-R Diagram is not correctly translated to database tables.
Majority of the tables, attributes are missing. Not all entities were translated into tables.
Tables are not normalised.
Database table is complete.
All entities are translated into tables.
Some attributes of the ER Diagram are not in the table and types of attributes are incorrect.
Relationships are not translated to tables (primary keys and foreign key are incorrect).
Tables are not normalised.
Some data in the table were entered.
Database table is complete.
All entities are translated into tables.
Attributes are all present and relationships among tables are established (primary keys and foreign
keys are mostly correct)
All data in the table were entered.
Most of the attributes have correct types.
Some tables are normalised.
Database table is complete.
All entities are correctly and completely translated into tables.
Attributes and types of attributes were correctly identified.
All data in the table were entered.
Most table relationships are correct (primary keys and foreign keys and their relationship have been mostly correctly established).
All tables are normalised to third normal form.
Database table is complete.
All entities are correctly and completely translated into tables.
Attributes and types of attributes are correctly identified.
All data in the table are entered.
All table relationships are correct (primary and foreign keys and their relationships
are all correctly identified)
All tables are normalised to third normal form.
Queries
20% SQL queries and generated are mostly incorrect.
Complex queries are not answered
More than 50% of the SQL queries are correct.
Complex queries are incorrect.
More than 75% of the SQL queries are correct.
Complex queries are mostly incorrect.
Almost all queries are correct (one or two
incorrect queries).
Some complex queries were answered.
All SQL queries are correct.
Can generate complex queries.
Forms and Reports
15% Unsatisfactory forms. Forms does not enter data.
Reports are mostly incorrect. No report formatting used.
Satisfactory forms. Some links to the tables are not functioning. Some data cannot be entered in the tables via forms.
Simple design incorporated in the forms. Not professional looking.
More than 50% of the reports are correct. No report formatting used.
Good forms. Most data can be entered in the tables via forms.
Some design were incorporated in the forms but not professional looking.
More than 75% of the reports are correct. Some report formatting used.
Very good forms. All elements of the forms are created. All data can be entered via forms.
Design were incorporated in the forms. Somewhat professional looking.
Almost all of the reports are correct (one or two incorrect). Report formatting used.
Excellent form.
All elements of the forms are created. All data can be entered via forms.
Professional looking forms.
All of the reports are correct Report formatting used extensively.
IT Controls, Ethical,
Privacy and Security
Issues
15% Makes assertions about the IT controls, ethical, privacy and security issues that are not justified.
Some issues are justified by arguments and not merely assertions.
Issues identified are appropriate. Arguments are presented to justify the issues.
Takes into account the complexities of the issues. Other viewpoints were acknowledged.
Justifies any conclusions reach with arguments and not merely assertions.
Issues identified are appropriate. Arguments are presented to justify the issues.
Accurately takes into account the complexities of the issues. Other viewpoints were acknowledged.
Justifies any conclusions reach with well-developed arguments and not merely assertions.
Issues identified are appropriate. Arguments are presented to justify the issues.
Accurately takes into account the complexities of the issues and provided examples. Other viewpoints were acknowledged.
Justifies any conclusions reach with well-developed arguments and wellarticulated viewpoint on the issues and substantiated by research.
You Want Quality and That’s What We Deliver
We’ve put together our writing team with care, choosing talented writers who shine in their fields. Each one goes through a tough selection process, where we look for folks with deep expertise in specific subjects and a solid history of academic writing. They bring their own mix of know-how and flair to the table, making sure our content hits the mark—packed with info, easy to read, and perfect for college students like you.
We don’t do AI-written essays or copycat work—everything’s original. Competitive pricing is a big deal for us; we keep costs fair while delivering top-notch quality. Our writers are some of the best out there, and we charge rates that stack up well against other services. This means you get stellar content without draining your wallet. Our pricing is straightforward and honest, built to give you real value for your money. That’s why students turn to us for high-quality writing services that won’t break the bank.
Academic integrity is at the heart of what we do. Every paper starts from scratch, with original research and writing tailored just for you. We write 100% authentic—no plagiarism research essays. Our strict quality control process includes scanning every draft with top tools like SafeAssign and Turnitin, so you get a similarity score and proof of originality. We’re obsessive about proper citation and referencing too, crediting every source to keep things legit. It’s all about giving you peace of mind with content that meets the highest standards.
When you decide to place an order with Dissertation Writer, here is what happens: