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

  
🔴 LIVE EXPERT
  121 Orders

Unit 4IT04: Computer Graphics Editing and Database Concepts 

Unit code: D/617/6695 RQF
Level: 4

Unit Aims
This unit aims to explain the concepts of photo editing. This will enable learners to insert photos into documents such as user manuals and the IT structure of an organization. The photos may need to be touched up before they are ready for use. This mainly involves using Adobe Photoshop and Adobe Illustrator for photo/image editing and designing. The unit delivers skills in photo retouching and digital drawing to address the issues of digital image design. It emphasizes exploration, techniques, media, ideas development and production techniques.

This unit also provides the fundamental concepts of a database system through Database Management System (DBMS), relational databases, entity relationship modelling and normalization. Learners are also required to create database systems using the database language of Structured Query Language (SQL).

Learning Outcomes and Assessment Criteria

Learning Outcomes: To achieve this unit, the learner must be able to:

Assessment Criteria: Assessment of these outcomes demonstrates the learner can:

1. Use computer graphic editing techniques to edit photos and create illustrations

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

2. Create a database system

2.1 Define the concept of a relational database
2.2 Build an entity-relationship diagram, deriving relations and validating relations using normalization
2.3 Create a database using Data Definition Language (DDL) and manipulate a database using Data Manipulation Language (DML) that meets the specification

Indicative Content

  • The work area, tools, options bar, other panels, customizing documents and workspace
  • Working with selections
  • Photoshop
  • Photo corrections
  • Layers
  • Mask and channels
  • Typographic design
  • Selecting and aligning in Adobe Illustrator
  • Creating and editing shapes including techniques to create movement in a graphical environment
  • Transforming objects
  • Drawing with pen and pencil tools
  • Colour and painting
  • Working with type
  • Blending colours and shapes
  • Preparing files for the web
  • Data, information, database management, DMS and DAP
  • Relational database
  • Database Management System (DBMS)
  • Structured Query Language (SQL) – Data Manipulation Language (DML)
  • SQL – Data Definition Language (DDL)
  • Entity relationship modelling
  • Deriving ER Diagrams
  • Normalization

Recommended Text
Adobe Team (2016), Adobe Photoshop CC Classroom in a book, Adobe Press. Adobe Team (2017), Adobe Illustrator CC Classroom in a book, Adobe Press.
Thomas M. Connolly and Carolyn E. Begg (2015) Database Systems: A Practical Approach to Design, Implementation and Management, Edition: 6, Addison-Wesley.


The quoted price covers up to 3000 words. For custom requirements Live Chat or Whatsapp Click Here



                             

Email: [email protected]

100% Plagiarism Free & Custom Written, Tailored to your instructions

Our Giveaways

Plagiarism Report

for د.إ50 Free

Formatting

for د.إ32 Free

Title page

for د.إ20 Free

Bibliography

for د.إ36 Free

Outline

for د.إ19 Free

Limitless Amendments

for د.إ38 Free

Get all these features for
د.إ195.00 FREE

ORDER NOW
assignment bank giveaways

Our Ratings