Posts

Showing posts with the label IT FUNDAMENTALS

Top 10 IT Jobs [Information Technology]

Image
So Here are the list of most lucrative jobs offers that one can look around for with tech giants, medium giants and small giants. The career opportunity in Information Technology sector is tremendously large. There are bunch of job offers that one can choose from and get into it. So, here are the list of Top 10 IT jobs that might help you around. UI & UX Designers: source: pexels.com A lot of people join Engineering but still they have their hearts with the animations, designs, sketches and all these things. Now the great part is all those guys who are designers can actually move into the technology. For sure they have to learn a lot of new skills. The basic job of a UI & UX Designers is to make sure that how the mobile apps look like or how one's website or web product looks like. To determine how the page of a app or website looks like and how actually the entire structure is being designed, make sure how the user proceed in the app is all the role UI & ...

Data Warehouse | Advantages | Components | Uses

Data warehouse is a relational or multidimensional database management system (DBMS) designed to support the management in decision making process. • Data warehouse is a repository of an organization’s electronically stored data and are designed to facilitate reporting and analysis • It also emphasizes on the means to retrieve and analyze data, to extract, transform and load data, and to manage the data dictionary. • An expanded definition for Data warehousing includes business intelligence tools, tools to extract, transform, and load data into the repository, and tools to manage and retrieve metadata (data about data). • In contrast to data, warehouses are operational systems that perform day-to-day transaction processing. • A data warehouse is a collection of computer-based information that is critical to successful execution of enterprise initiatives • It provides a tool to satisfy the information needs of the employees at all organizational levels-not just for complex data ...

Database and Database Management System

Image
Database And Database Management System In Brief A computer system organizes data in a hierarchy that begins with bits, and proceeds to bytes, fields, records, files and databases. Bit is the smallest unit of data that a computer can process. It's valid values are 0s and 1s. Similarly Byte is a group of 8 bits.  Fields are the  logical grouping of characters into a word, a small group of words, or a complete number is called Field. Records are the logical grouping of related fields whereas Files are the grouping of related records.  Database:  A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. Advantages of Database: A. Database reduce  the problem of Data Redundancy. B. It help in avoiding the  Inconsistency. C. Data sharing D. Standards can be enforced. E. Security restrictions can be applied. F. Integrity or Accuracy can be maintained. Characteristics of Datab...

Planning Production | Automated Design Work | HRM

Image
Planning Production and Operations source: pexels Some of the major areas of planning and their computerized support are: Materials Requirement Planning (MRP): MRP is a production planning, scheduling and inventory control system used to manage manufacturing process. An MRP system is intended to simultaneously meet three objectives: • Ensure materials are available for production and products are available for delivery to customers. • Maintain the lowest possible material and product levels in store. • Plan manufacturing activities, delivery schedules and purchasing activities. • Manufacturing Resource Planning (MRP II):  MRP II is an integrated computer system that connects the regular MRP to other functional areas, especially finance and human resources. It can also be defined as a method for the effective planning of all resources of a manufacturing company. Ideally, it addresses operational planning in units, financial planning, and has a simulation capability to ...

Electronic Commerce | Types, Benefits, Limitations of E-commerce

Image
Electronic Commerce (E-Commerce) E-commerce is the process of buying, selling and exchanging of goods, services and information or the transmitting of funds or data, over an electronic network, primarily the Internet. It covers a range of different types of businesses, from consumer based retail sites, through auction or music sites, to business exchanges trading goods and services between corporations. It is currently one of the most important aspects of the Internet to emerge. E-commerce allows consumers to electronically exchange goods and services with no barriers of time or distance. These business transactions occur business-to-business, business-to-consumer, consumer-to-consumer or consumer-to-business. The terms e-commerce and e-business are often used interchangeably. source: pexels Types of E-Commerce:  • Business-to-Business Commerce (B2B):  B2B refers to electronic commerce between businesses rather than between a business and a consumer. B2B business...

Management Information System (MIS)| TPS | CRM | POM

Management information system (MIS) is a computerized database of financial information organized and programmed in such a way that it produces regular reports on operations for every level of management in a company.  Management Information System produces  the following reports: • Routine/Scheduled Reports Routine periodic reports are produced at scheduled intervals, ranging from hourly quality control reports to reports on monthly absenteeism rates. • Ad-Hoc(Demand) Reports  Managers frequently need special information, which is not included in the routine reports, or they need the same information that is included in the routine reports, but at different times. Such out-of-the routine reports are called ad-hoc reports. They also may include requests for drill down reports, which show a greater level of detail; key-indicator reports, which summarize the performance of critical activities; and comparative reports,which compare performances of different department...

Entity Relationship Modeling | Database Normalization and Data Models

Image
The entity-relationship model (or ER model) is a way of graphically representing the logical relationships of entities (or objects) in order to create a database. It uses ER diagram to document the conceptual data model. ER diagram consists of entities, attributes, and relationships and cardinalities.  • Entity: An entity can be a real-world object, either animate or inanimate, that can be easily identifiable. For example, in a school database, students, teachers, classes, and courses offered can be considered as entities. All these entities have some attributes or properties that give them their identity. • Attributes Entities are represented by means of their properties, called attributes. All attributes have values. For example, a student entity may have name, class, and age as attributes. • Relationship The association among entities is called a relationship. For example, an employee ”works at” a department, a student ”enrolls” in a course. Here, ”Works at” and ”Enroll...

Network Topology

Image
Network Topology is the schematic description of a network arrangement, connecting various nodes(sender and receiver) through lines of connection. Some basic types of Network topology are : Bus Topology: • Bus topology is a network type in where every computer and network device is connected to single cable. • It transmits data only in one direction. • Every device is connected to a single cable • It is cost effective. • Cable required is least compared to other network topology. • It is used in small networks. • It is easy to understand. • It is easy to expand joining two cables together. • Cables fails then whole network fails. • If network traffic is heavy or nodes are more the performance of the network decreases. • Cable has a limited length. • It is slower than the ring topology. Bus Topology Ring Topology:  • It is called ring topology because it forms a ring as each computer is connected to another computer, with the last one connected to the first. Ex...

Computer Network and Types of Network | Communication Media

Image
Computer Network A computer network is a group of computer systems and other computing hardware devices that are linked together through communication channels to facilitate communication and resource-sharing among a wide range of users.  Advantages of Network: • Facilitate communication via email, video conferencing, instant messaging, etc.  • Enable multiple users to share a single hardware device like a printer or scanner.  • Enable file sharing across the network. • Allow for the sharing of software or operating programs on remote systems. • Make information easier to access and maintain among network users. Disadvantages of Network: • Data and information maybe stolen by computer hackers.  • If any computer in the network get affected by the virus, there is high chance of spreading computer virus.  • Computers on the network have to depend on the server. Communication Media/Channel: Communication media refers to the means of...

Types Of Software | Programming Languages

Image
Software is a general term for the various kinds of programs used to operate computers and related devices.Software can be thought of as the variable part of a computer and hardware the invariable part. Software is a collection of data or instructions that tells the computer how to work. In contrast to hardware which is physical component, from which the system is built and actually performs the work. What is Software and Software Crisis? Types of Software: Software can be generally divided into two categories :  i. System Software  ii. Application Software System Software:     The class of programs that control and support the computer system and its information processing activities.  • It facilitates the programming, testing, and debugging of computer programs . • It is usually independent of any specific type of application. • It supports application software by directing the basic functions of the computer.  System Software...