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 »
Data processing


ACCT6001 Assessment 4 – Database Application Page 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 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 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 Page 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 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 libreBase 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 ACCT6001 Assessment 4 – Database Application Page 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 b. List of all the suppliers’ information SUBMISSION REQUIREMENTS: 1) A word document containing: a) Introduction - a summary of the case study b) Justification of the use of database c) Database Design: E-R Diagram d) IT controls needed e) Ethical, privacy and security issues 2) LibreOffice 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 ACCT6001 Assessment 3- Excel Spreadsheet Page 4 of 7 Learning Rubrics 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 incorrect. More than 50% of the entities, attributes and relationships identified are incorrect. Points 0-6 E-R diagram is complete but some attributes and relationships are incorrect. Some entities identified should not be an entity. Around 50% of attributes are missing (or incorrect) and incorrect relationships are identified. Points 7-9 E-R diagram is complete. All entities identified are correct. Around 25% of the attributes and relationships are missing or incorrect. Points 10-11 E-R diagram is complete. Identified entities were correct and complete. Attributes were correct and complete. One or two relationships were missing (or incorrect) Points 12-13 E-R Diagram is complete. All entities, attributes and relationships are identified correctly. Points 14-15 ACCT6001 Assessment 3- Excel Spreadsheet Page 5 of 7 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. 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 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. 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 correct) All data in the table were entered. Most of the attributes have correct types. Some tables are normalised. Points 13-15 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. Points 16-18 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. Points 19-20 ACCT6001 Assessment 3- Excel Spreadsheet Page 6 of 7 Queries
Answered Same DayApr 14, 2020ACCT6001Torrens University Australia

Answer To: ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 1 of 7 ASSESSMENT BRIEF Subject Code and...

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, supplier
s 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 corresponding 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 broad 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