Easy database assignment.

Quick and easy assignment. Everything is in the folder.

Get Help With a similar task to - Easy database assignment.

Login to view and/or buy answers.. or post an answer
Additional Instructions:

© Didasko 2020. All rights reserved. 1 CSE1ITX Information Technology Fundamentals Assessment 4 – Database Objectives: ▪ To develop and interpret simple database tables, queries and reports This is an INDIVIDUAL assignment. Students are not permitted to work in a group when writing this assignment. Copying, Plagiarism This is an individual assignment. Students are not permitted to work in a group when writing this assignment. Plagiarism is the submission of another person’s work in a manner that gives the impression that the work is their own. La Trobe University treats plagiarism seriously. When detected, penalties are strictly imposed. Further information can be found on http://www.latrobe.edu.au/students/academic- integrity/explanation/plagiarism Submission Guidelines  Your assignment submission should be typed, not written/drawn by hand.  Submit the electronic copy of your assignment through the subject LMS.  Submission after the deadline will incur a penalty of 5% of the final assignment mark per day capped at 5 days. No assignment will be accepted after 5 days. If you have encountered difficulties that lead to late submission or no submission, you should apply for special consideration. 2 © Didasko 2020. All rights reserved. Background The IT department of PayFast payroll company is responsible for handling all computer related issues of the company. Some of these responsibilities of the team includes, purchasing and keeping stock of new computers, assigning computers to employees (which then become personal computers or PCs), and installing and managing software and software packages on PCs assigned to employees of the company. As the company is growing steadily since the start of the year, the IT department has decided to create a database system to help manage the computer related information so that they can manage it more efficiently. The company has hired you to do this task for them. As an initial step PayEast would like to record information about computers, PCs, software packages and the employees that are assigned a PC. The next step is to implement a prototype database for the system. For each computer, the IT team wishes to record the following details.  A unique CompID (e.g. B121) to identify each computer  MfgName that describes the computer manufacturer’s name (e.g. Hewlett Packard)  MfgModel that describes the computer manufacturer’s model code (e.g. Z8)  Processor that describes the computer processor type (e.g. i5) The database must record the following information about their employees:  A unique EmpNum (e.g. 124) to identify each employee  LastName that records the employees’ last name  FirstName that records the employees’ first name  Phone that records the phone extension number that is used internally in the company (e.g. 2212) For each software package, the following information is recorded:  A unique PackID (e.g. AC01) to identify each software package  PackName that records the name of the software package (e.g. Freeware Processing)  PackVer that records the release version number of the software package (e.g. 1.5)  PackType that records the category of the software package (e.g. Word Processing)  PackCost that records the cost of the software package cost (e.g. $725.83) A computer is recorded as a PC in the database when it is assigned to an employee. One computer can only become one PC. The information stored about PCs are as follows:  A unique TagNum (e.g. 2234), that identifies each PC with the tag number it’s assigned in the asset register of the company  CompID to track each PC against the computer ID it was assigned before  EmpNum that identifies the employee that each PC is assigned to  Location that identifies the department each PC is assigned to (e.g. Sales) © Didasko 2020. All rights reserved. 3 The database must record the following information about each software installed on a PC. A PC can have many software installed on it. Each software belongs to one software package. But, each software package may have more than one software in it.  A unique SID (e.g. 4), that identifies each software installed on a PC  PackID to track the software package each software belongs to  TagNum that identifies each PC that the software is installed on  InstallDate that records the date the software was installed (e.g. 13/09/2017)  SoftCost that records the cost of the software at the time of its installation (e.g. $380.00) Figure 1 illustrates the design of the prototype database system. Figure 1 Your tasks In this assessment, you are expected to create an example database and an application prototype. You are recommended to use Microsoft Access for this purpose. Task 1 Insert the following software records to database.  SID: 1, PackID: AC01, TagNum: 32808, InstallDate: 13/09/2017 and SoftCost: $754.95  SID: 2, PackID: DB32, TagNum: 32808, InstallDate: 12/03/2017 and SoftCost: $380.00  SID: 3, PackID: WP08, TagNum: 32808, InstallDate: 1/12/2017 and SoftCost: $185.00  SID: 4, PackID: DB32, TagNum: 37691, InstallDate: 15/06/2017 and SoftCost: $380.00  SID: 5, PackID: WP08, TagNum: 37691, InstallDate: 15/06/2017 and SoftCost: $227.50  SID: 6, PackID: DB33, TagNum: 57772, InstallDate: 27/05/2017 and SoftCost: $412.77 4 © Didasko 2020. All rights reserved.  SID: 7, PackID: WP08, TagNum: 57772, InstallDate: 27/05/2017 and SoftCost: $170.24  SID: 8, PackID: WP09, TagNum: 59836, InstallDate: 30/10/2017 and SoftCost: $35.00  SID: 9, PackID: WP09, TagNum: 77740, InstallDate: 27/05/2017 and SoftCost: $35.00  SID: 10, PackID: DB33, TagNum: 77740, InstallDate: 6/06/2017 and SoftCost: $900.00 Task 2 Update the fields given below to include validation rules (and validation text to go with them) and/or change field parameters to ensure the following.  SID is an integer number between 1 and 999  InstallDate is a date either today or a date before today  SoftCost is less than $2000 dollars  Ensure that all phone numbers in the Phone field in the Employee table have exactly 4 digits Task 3 Design the following query on the database. The query should be named Task3. List the package IDs, names and package types for all packages whose type is ‘Database’ or ‘Spreadsheet’. Task 4 Design the following query on the database. The query should be named Task4. List all information of software packages with the word ‘Process’ in its package type. Task 5 Design the following query on the database. The query should be named Task5. List all the software packages that cost more than $400. © Didasko 2020. All rights reserved. 5 Task 6 Design the following query on the database. The query should be named Task6. Display the TagNum, PackID, SoftCost and the discounted software cost (SoftCost * 0.95) for each software on which the discounted cost is at least $400. The discounted software costs should be displayed in a column named ‘DiscountPrice’. Task 7 Design and test the following query on the database. The query should be named Task7. Calculate and display the total cost the company has spent on software packages. Task 8 Design and test the following query on the database. The query should be named Task8. Find the average package cost for packages whose type is Word Processing. Task 9 Design and test the following query on the database. The query should be named Task9. List the package ID and name for all packages whose cost is more than average. Task 10 Design and test the following query on the database. The query should be named Task10. This query should prompt the user to enter 2 values for InstallDate (e.g. software installed between 1/1/2017 and 6/6/2017) and then display the Software ID, Package ID and the software cost of all software that have been installed within that range (not including the dates entered). Task 11 Design and test the following query on the database. The query should be named Task11. For each PC assigned to employee with EmpNum 124, list the TagNum and the CompID along with the name of the computer manufacturer. 6 © Didasko 2020. All rights reserved. Task 12 Design and test the following query on the database. The query should be named Task12. Display the manufacturer names and models of all PCs that are assigned to at least one employee who uses a computer at Home. Task 13 Design and test the following query on the database. The query should be named Task13. Display the employee numbers and names of all employees who are not assigned a PC for Home use. Task 14 Design and test the following query on the database. The query should be named Task14. Find the tag number and computer IDs for those PCs that have at least one Database package installed on it. Task 15 Design and test a form that can be used to display the data from the database. The form should be named Task15. Figure 1 shows a sample of how this form may look like. The form should be able to perform the following:  Display one record at a time  The field labels should be descriptive This combo box contains all the PackIDs’. When a specific PackID is picked from the combo box, the relevant record details should appear on the form (refer to Figure 1). The form must contain three (3) buttons. The buttons should be functional and perform the following functions (Figure 1 is an example)  Update Package– Any changes made to a record are updated when this button is clicked  Delete Package – Deletes the record that is selected  Cancel – Undo any changes made to a record when this button is clicked © Didasko 2020. All rights reserved. 7 Figure 1 Submitting your work When you have completed, submit the solutions to the above parts via the CSE1ITX_2018_04 A4: Database on the LMS. You should submit the following:  Submit your Microsoft Access database called xxx_cse1ITX_A4_Database.accdb (where xxx is your student number)  Submit any additional comments or explanations as a Microsoft Word document called xxx_cse1ITX_A4_Database.docx (where xxx is your student number) 8 © Didasko 2020. All rights reserved. Assessment 4 Marking Criteria 0 Point 1 Point 2 Points Task 1 No records present. Some records inserted correctly. All records inserted correctly. Task 2 No visible present. validation Partial validation present. All expected implemented. data validation Task 3 No query written or written incorrectly. Partially correct answer Entire query is correct. Task 4 No query written or written incorrectly. Partially correct answer Entire query is correct. Task 5 No query written or written incorrectly. Query partially correct. Entire query is correct. Task 6 No query written or written incorrectly. Query partially correct. Entire query is correct. Task 7 No query written or written incorrectly. Query partially correct. Entire query is correct. Task 8 No query written or written incorrectly. Query partially correct. Entire query is correct. Task 9 No query written or written incorrectly. Query partially correct. Entire query is correct. © Didasko 2020. All rights reserved. 9 Task 10 No query written or written incorrectly. Query partially correct. Entire query is correct. Task 11 No query written or written incorrectly. Query partially correct. Entire query is correct. Task 12 No query written or written incorrectly. Query partially correct. Entire query is correct. Task 13 No query written or written incorrectly. Query partially correct. Entire query is correct. Task 14 No query written or written incorrectly. Query partially correct. Entire query is correct. Task 15 Form not present. No combo box present. No buttons present Form partially meets expectation, Combo box present, but does not work as expected and partially correct answer Form implemented correctly, Combo box present and works as expected and all buttons present and work as expected Task 16 Assignment submitted late. Marks deducted against final score as per academic comments. Assignment submitted on time. No late penalties. Assignment submitted late. Marks deducted against final score as per academic comments. Total 20

Related Questions

Similar orders to Easy database assignment.
2
Views
0
Answers
Internet of things
This is master degree course and there are 5 questions which only 3 need to be answered. It has to be done within 2 hours and send it to me so I can upload it to the university portal. I need to get A or better....
29
Views
0
Answers
TCP and Attacks on TCP
Consider these attacks on TCP: SYN Flooding, NULL Flooding, Information Covert channel, Timing Covert channel and DDoS. From the perspective of the attacker, which do you think is the easiest to launch? Which is the most difficult? From the perspective...
15
Views
0
Answers
Laravel Rating System
admins can: Update admin info Insert user account Update user account Delete user account Update book attribute...
48
Views
0
Answers
Database Design
Please put it in a Microsoft Word document....