Btec compare and contrast essay help Video Animation

If you feel that an assessment decision is unjustified, you are entitled to appeal. Please refer to your course handbook or speak to your teacher or tutor for details as to how to do this. Assessor’s General Comments/Feedback/ Action Plan: Learner Feedback: (Ensure you read the assessment criteria and teacher’s comments) Learner’s Declaration: I certify that the work submitted for this assignment is my own and research sources are fully acknowledged. Learner signature: Date: Assessor signature Date IV Signature Assignment Brief Qualification Unit number and title Deadline Assessor name Assignment title

The purpose of this assignment is to: To design and implement a relational database within given scenario Scenario You are an IT technician in the technical support section of an insurance company. Your manager needs to monitor the use of IT hardware, such as a keyboard, monitor, printer, system unit, laptop, CD writer, mouse, in order to improve the service provided to users and ensure the service is operated in an efficient way. In this situation the user need is that of the network manager.

The responsibility for monitoring each hardware item is allocated to a specific employee. Key information lready identified includes: Employee details Hardware location Hardware details Hardware types Supplier details Problems description. This list is not exhaustive and needs to be extended, as appropriate, to meet the network manager’s needs as described below. Know what hardware there is, who supplied it and which employee is responsible for it. What hardware items are in each room?

Know what problems have been reported by a particular employee. Know what specific items and types of hardware are faulty or having problems. Add, delete and modify information to all tables. In addition, the following features must be incorporated into the database. Employee gender and title must be consistent. Employee gender must be either M or F. All hardware serial numbers are composed of two alphabetic characters followed by four numeric characters. All supplier records must have at least a first line of address and postcode entered.

Problems cannot be reported on future dates. User prompts on the form where helpful. It must not be possible to enter a supplier or employee that already exists. When You are advised to research wherever possible and reference sources used. Task 1 – Pl Explain the features ofa relational database: Write a report on the purpose and features of relational databases. Use screenshots to illustrate these features. The report should include the following: The purposes of databases. Comparing relational databases to paper based systems. Define entity and attribute.