CITM-001: Certified Information Technology Manager

The select clause corresponds to the projection operation of the relational algebra. It is used to list the attributes desired in the result of a query.For example, the queryselect name, age from studentwill return the name and age attributes of all tuples in the student relation12.Reference:1: CSE132A F05 SQLpart1 - University of California, San Diego2: Basic Operations - RDBMS Questions and Answers - Sanfoundry

The conceptual level is a high-level description of the data and its relationships in the database, without specifying how the data is physically stored or implemented. It defines the main entities, attributes, and constraints for the entire database, and is independent of any specific database management system or application. The conceptual level is also known as the logical level, and it is usually represented by an entity-relationship diagram (ERD).Reference:Conceptual schema - Wikipedia,Navigating the Three Levels of Database Design: Conceptual, Logical, and Physical

An attribute is a property that describes various characteristics of an entity. For example, an entity type called Employee may have attributes such as name, age, salary, department, etc. An attribute can also be a primary key that uniquely identifies an entity instance, or a foreign key that references another entity type. An attribute can have a data type, a domain, and a constraint that define its format, range, and validity. An attribute is represented by an oval in an ER diagram, and by a column in a table.Reference:3,EXIN EPI Certified Information Technology Manager - EXIN(page 23)

Structured design and object-oriented design are two common approaches to design a system. Structured design is a method of breaking down a system into smaller and simpler modules, which can be independently created and tested. Structured design follows a top-down approach, where the system is divided into sub-systems, and then into modules, until the desired level of detail is reached. Structured design is suitable for systems that have well-defined inputs and outputs, and a clear hierarchy of functions. Object-oriented design is a method of modeling a system as a collection of objects, which have attributes and behaviors. Object-oriented design follows a bottom-up approach, where the system is built from reusable and interchangeable components, called classes. Object-oriented design is suitable for systems that have complex interactions, dynamic behavior, and multiple inheritance. Functional design and organizational design are not considered to design a system, but rather to describe the system's purpose and structure. Functional design is a process of defining the functions and processes that the system performs, and how they relate to each other. Functional design focuses on the what and why of the system, rather than the how. Organizational design is a process of defining the roles and responsibilities of the people and units involved in the system, and how they communicate and coordinate with each other. Organizational design focuses on the who and where of the system, rather than the how.Reference:Structured Design - an overview | ScienceDirect Topics,Object-Oriented Design - an overview | ScienceDirect Topics,Functional Design - an overview | ScienceDirect Topics, [Organizational Design - an overview | ScienceDirect Topics]