IT404: Computer Graphics Editing and Database Concepts, Assignment, LIBT, UK

Assignment Question

Task 1

Use computer graphic editing techniques to edit photos and create illustrations
1.1: You are required to print your old school photo. Using Photoshop, write the steps to
1) Crop and straighten
2) Improve lighting and colour
3) Eliminate distracting elements
4) Add creative effects

For the photo to make the photo look nicer? (1.1, 1.2)

1.2: List down the techniques that are used in the following illustration and briefly explain (1.3)

1.3: To animate the above image with steam effect, what are the techniques that you will use? (1.4)

Assessment Criteria

1.1. Apply photo editing, retouching and repairing techniques correctly
1.2. Use Photoshop correctly to create the required effects
1.3. Create illustrations using illustration software tools to the required standard
1.4. Analyse techniques to create movement in a graphical environment

Task 2

Create a database system

2.1: What is ‘Relation Database Management Systems’ (RDBMS) and how does it differ from ‘Database Management Systems’ (DBMS)? What categories of data integrity exist in RDBMS? How do they ensure the data integrity? (2.1)

2.2: “ABC hospital has a number of departments, rooms, doctors, nurses, and other staff working. Patients having different conditions visit and get checkup done from the doctors and if necessary they are admitted and discharged after recovering.”

1) Build an entity-relationship diagram for the above scenario, deriving relations and validating relations using normalisation up to third normal form (2.2)
2) From the ER diagram in the first part, create a database (DB) using ‘Data Definition Language’ (DDL). Define how would you insert, delete and update records from your ‘Doctors’ table using ‘Data Manipulation Language’ (DML) (2.3)

Assessment Criteria

2.1 Define the concept of a relational database

2.2 Build an entity-relationship diagram, deriving relations and validating relations using normalisation

2.3 Create a database using Data Definition Language (DDL) and manipulate a database using Data Manipulation Language (DML) that meets the specification

Submission of Assignments

-Before submitting your work check you have:
✓ Completed the tasks or activities as required by the assignment
✓ Labelled or numbered each task or activity
✓ Understood and responded to the command verbs in the Assessment Criteria
✓ Produced the tasks or activities in the required format
✓ Presented your work clearly
✓ Referenced sources you have used and cited from
✓ Put cited material in quotation marks
✓ Checked for any spelling or grammatical errors
✓ Added a footer with page numbers

Answer

Request Answer of this Assignment