Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 1 of 7 ASSESSMENT BRIEF Subject Code and Title ACCT6001 Accounting Information Systems Assessment Assessment 4: Database Application...

1 answer below »
ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 1 of 7

ASSESSMENT BRIEF
Subject Code and Title ACCT6001 Accounting Information Systems
Assessment Assessment 4: Database Application
Individual/Group Individual
Length
Learning Outcomes 1. Explain the characteristics of relational databases
and their role in creation and communication of
usiness 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 11:55pm AEST/AEDT Sunday end of module 6 (week
12)
Weighting 30%
Total Marks 100 marks
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.

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.

ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 2 of 7

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
udget 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 numbe
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 li
eBase or Microsoft Access
3. You need to create the following forms for data entry:
a. Employee Form
. 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
. 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

ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 3 of 7

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
. List of all the suppliers’ information
SUBMISSION REQUIREMENTS:
1) A word document containing:
a) Introduction - a summary of the case study
) Justification of the use of database
c) Database Design: E-R Diagram
d) IT controls needed
e) Ethical, privacy and security issues
2) Li
eOffice Base/Microsoft Access files used in creating the tables, forms, queries and
eports
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
ACCT6001 Assessment 3- Excel Spreadsheet XXXXXXXXXXPage 4 of 7

Learning Ru
ics
Assessment Attributes Fail
(Unacceptable)
Pass
(Functional)
Credit
(Proficient)
Distinction
(Advanced)
High Distinction
(Exceptional)
Points
Need for the
implementation of the
database


15%%
Unsatisfactory
explanation provided is
very general, lacks
detail, does not answer
the question.



Points 0-6
Satisfactory explanation
provided, several
justifications discussed, lack
detailed explanation.




Points 7-9

Good explanation provided,
several justifications
discussed. Explanations are
detailed but some are not
convincing.



Points 10-11
Very good explanation and
justification. Explanations are
convincing. Main problems
are identified and discussed in
details. Provided some
examples.


Points 12-13
Excellent explanation and
justifications provided. Main
problems are identified and
prioritised. Each problem is
discussed in detail. Examples
were provided for each
problem.

Points 14-15
E-R Diagram


15%
E-R Diagram is
inco
ect.

More than 50% of the
entities, attributes
and relationships
identified are
inco
ect.








Points 0-6
E-R diagram is complete
ut some attributes and
elationships are
inco
ect.

Some entities identified
should not be an entity.

Around 50% of attributes
are missing (or inco
ect)
and inco
ect
elationships are
identified.


Points 7-9

E-R diagram is complete.

All entities identified are
co
ect.

Around 25% of the
attributes and
elationships are missing
or inco
ect.






Points 10-11

E-R diagram is complete.

Identified entities were
co
ect and complete.

Attributes were co
ect
and complete.

One or two relationships
were missing (or inco
ect)





Points 12-13
E-R Diagram is complete.

All entities, attributes and
elationships are identified
co
ectly.











Points 14-15
ACCT6001 Assessment 3- Excel Spreadsheet XXXXXXXXXXPage 5 of 7

Database Tables


20%
Database tables are
inco
ect and
incomplete.

E-R Diagram is not
co
ectly translated to
database tables.

Majority of the tables,
attributes are missing.
Not all entities were
translated into tables.


Tables are not
normalised.











Points 0-9
Database table is
complete.


All entities are translated
into tables.

Some attributes of the E-
R Diagram are not in the
table and types of
attributes are inco
ect.

Relationships are not
translated to tables
(primary keys and foreign
key are inco
ect).

Tables are not
normalised.

Some data in the table
were entered.



Points -10-12
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 co
ect)

All data in the table were
entered.

Most of the attributes
have co
ect types.

Some tables are
normalised.






Points 13-15

Database table is complete.

All entities are co
ectly
and completely translated
into tables.

Attributes and types of
attributes were co
ectly
identified.

All data in the table were
entered.

Most table relationships
are co
ect (primary keys
and foreign keys and their
elationship have been
mostly co
ectly
established).

All tables are normalised to
third normal form.




Points 16-18

Database table is complete.

All entities are co
ectly and
completely translated into
tables.

Attributes and types of
attributes are co
ectly
identified.

All data in the table are
entered.

All table relationships are
co
ect (primary and foreign
keys and their relationships
are all co
ectly identified)

All tables are normalised to
third normal form.






Points 19-20
ACCT6001 Assessment 3- Excel Spreadsheet XXXXXXXXXXPage 6 of 7

Queries

Answered Same Day Apr 14, 2020 ACCT6001 Torrens University Australia

Solution

Navashree answered on May 05 2020
123 Votes
Solution.docx
Introduction
The aim of this report is to present information about the justification of using a database application for the coordinator of a project management company. A project coordinator is responsible for keeping track of the projects’ progress, communicating with the team members, team leaders, suppliers and so on. The database will help a project coordinator to execute his jobs more efficiently and faster.
Justification of the use of the Database
A database is the most suitable solution for the given problem of keeping track of different aspects of project coordination. The justifications are (Carlos Coronel, 2018),
· A database will help to represent different real world entities like suppliers, projects, materials, activities and so on using different sets of attributes of each entity set.
· A database is suitable for modeling the relationships between entity sets and to represent the participation and cardinality of each relationship and the participating entity sets.
· Once implemented, the database will help to organize the data in a table. The tables can be stored, processed and updated systematically.
· A database ensures minimal data redundancy and anomalies.
· As the data volume grows up to a certain level, a database can support it.
· A database also allows to implement various security controls. It helps to ensure that the data are protected from various types of unauthorized accesses.
· A database also allows to enter data using user friendly interfaces like forms and can produce the outputs in the forms of reports.
· It also allows to analyze data using various queries.
ER Diagram
The ER diagram is,
Relational Schema
The relational schema co
esponding to the ER diagram is given below.
PROJECT (PrjID, PrjTitle, Location, EstBudget, DueDate)
EMPLOYEE (EmpNo, Name, Address, PhoneNumber, HighestDegree)
EMP_PRJ (PrjID, EmpNo, Role, DateAssigned, DateReleased)
EXPERTISE (ExpID, Expertise, Details)
EMP_EXP (ExpID, EmpNo)
SUPPLIER (SuppID, SuppName, SuppAddress, ABN, ContactPerson, ContactPhone)
MATERIAL (MatID, MatName, Cost)
ACTIVITY (ActID, ActName, ActDetails)
MAT_SUPP (MatID, SuppID)
PRJ_ACT_MAT (PrjID, ActID, MatID, DateOrdered, ExpectedDeliveryDate, ActualDeliveryDate)
Normalization
The relations are in 1NF already as each relation has its own primary key and there is no multivalued attribute in any relation. Then the relations also confirms the criteria of 2NF as all are already in 1NF and there is no partial dependency on the primary key of any relation.
Finally, there is no transitive dependency on the primary key through a non-prime attribute and the relations are already in 2NF. Hence, all relations are already in 3NF (Carlos Coronel, 2018).
IT Controls Needed
To ensure the protection and security of data stored in the project coordinator database, it will need to implement various security controls on the database. An IT control can be a policy or a procedure. It offers an assurance that the use of IT within an organization conforms to the laws, regulations and compliances set by the government or related authorities (Basta & Zgola, 2011). There are two
oad categories of IT controls. Those are, general controls and application controls.
Some...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here