Yahoo Web Search

Search results

1. Top results related to what are the different types of software in computer

   • What are the different types of keys in RDBMS?

     Top Answer

     Answered Nov 10, 2009 · 21 votes

     From here and here: (after i googled your title)

     • Alternate key - An alternate key is any candidate key which is not selected to be the primary key
     • Candidate key - A candidate key is a field or combination of fields that can act as a primary key field for that table to uniquely identify each record in that table.
     • Compound key - compound key (also called a composite key or concatenated key) is a key that consists of 2 or more attributes.
     • Primary key - a primary key is a value that can be used to identify a unique row in a table. Attributes are associated with it. Examples of primary keys are Social Security numbers (associated to a specific person) or ISBNs (associated to a specific book). In the relational model of data, a primary key is a candidate key chosen as the main method of uniquely identifying a tuple in a relation.
     • Superkey - A superkey is defined in the relational model as a set of attributes of a relation variable (relvar) for which it holds that in all relations assigned to that variable there are no two distinct tuples (rows) that have the same values for the attributes in this set. Equivalently a superkey can also be defined as a set of attributes of a relvar upon which all attributes of the relvar are functionally dependent.
     • Foreign key - a foreign key (FK) is a field or group of fields in a database record that points to a key field or group of fields forming a key of another database record in some (usually different) table. Usually a foreign key in one table refers to the primary key (PK) of another table. This way references can be made to link information together and it is an essential part of database normalization

     Other Answers

     Answered Sep 21, 2014 · 89 votes

     (I) Super Key – An attribute or a combination of attribute that is used to identify the records uniquely is known as Super Key. A table can have many Super Keys.

     E.g. of Super Key

     • ID
     • ID, Name
     • ID, Address
     • ID, Department_ID
     • ID, Salary
     • Name, Address
     • Name, Address, Department_ID

     So on as any combination which can identify the records uniquely will be a Super Key.

     (II) Candidate Key – It can be defined as minimal Super Key or irreducible Super Key. In other words an attribute or a combination of attribute that identifies the record uniquely but none of its proper subsets can identify the records uniquely.

     E.g. of Candidate Key

     • ID
     • Name, Address

     For above table we have only two Candidate Keys (i.e. Irreducible Super Key) used to identify the records from the table uniquely. ID Key can identify the record uniquely and similarly combination of Name and Address can identify the record uniquely, but neither Name nor Address can be used to identify the records uniquely as it might be possible that we have two employees with similar name or two employees from the same house.

     (III) Primary Key – A Candidate Key that is used by the database designer for unique identification of each row in a table is known as Primary Key. A Primary Key can consist of one or more attributes of a table.

     E.g. of Primary Key - Database designer can use one of the Candidate Key as a Primary Key. In this case we have “ID” and “Name, Address” as Candidate Key, we will consider “ID” Key as a Primary Key as the other key is the combination of more than one attribute.

     (IV) Foreign Key – A foreign key is an attribute or combination of attribute in one base table that points to the candidate key (generally it is the primary key) of another table. The purpose of the foreign key is to ensure referential integrity of the data i.e. only values that are supposed to appear in the database are permitted.

     E.g. of Foreign Key – Let consider we have another table i.e. Department Table with Attributes “Department_ID”, “Department_Name”, “Manager_ID”, ”Location_ID” with Department_ID as an Primary Key. Now the Department_ID attribute of Employee Table (dependent or child table) can be defined as the Foreign Key as it can reference to the Department_ID attribute of the Departments table (the referenced or parent table), a Foreign Key value must match an existing value in the parent table or be NULL.

     (V) Composite Key – If we use multiple attributes to create a Primary Key then that Primary Key is called Composite Key (also called a Compound Key or Concatenated Key).

     E.g. of Composite Key, if we have used “Name, Address” as a Primary Key then it will be our Composite Key.

     (VI) Alternate Key – Alternate Key can be any of the Candidate Keys except for the Primary Key.

     E.g. of Alternate Key is “Name, Address” as it is the only other Candidate Key which is not a Primary Key.

     (VII) Secondary Key – The attributes that are not even the Super Key but can be still used for identification of records (not unique) are known as Secondary Key.

     E.g. of Secondary Key can be Name, Address, Salary, Department_ID etc. as they can identify the records but they might not be unique.

     Other Answers

     Answered Nov 10, 2009 · 9 votes

     Ólafur forgot the surrogate key:

     A surrogate key in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data.

     Check all answers on Stack Overflow

     1/5

   • What are the different types of errors in python?

     Top Answer

     Answered Feb 09, 2015 · 3 votes

     These errors can, and should, be defined by modules and projects as they are developed - so, there is no limited and "closed" set of errors like you are asking for.

     Python introspection capabilities allow one to see, through the interactive console, which errors are defined as derived directly from "Exception" - but there could be more:

     >>> [err.__name__ for err in Exception.__subclasses__()]['TypeError', 'StopIteration', 'ImportError', 'OSError', 'EOFError', 'RuntimeError', 'NameError', 'AttributeError', 'SyntaxError', 'LookupError', 'ValueError', 'AssertionError', 'ArithmeticError', 'SystemError', 'ReferenceError', 'BufferError', 'MemoryError', 'Warning', 'error', 'Error']

     Note that exception itself is derived from BaseException, which subclasses are not limited to "error" exceptions, but to Exceptions used in flow control as well:

     >>> [err.__name__ for err in BaseException.__subclasses__()]['Exception', 'GeneratorExit', 'SystemExit', 'KeyboardInterrupt']

     Bottom line: knowing the total number of errors is impossible and irrelevant for learning the language. Each function/library you are dealing with can define new ones, and you should check the documentation to know which exceptions they can throw.

     (On a side note, the __sublass__ method I used above does return a list of the classes that are direct descendants of that class. I them pick the __name__ attribute of each class to display)

     The document posted by @GP89 in the comments will also show the errors which are not direct descendants of exception: https://docs.python.org/2/library/exceptions.html#exception-hierarchy

     Check all answers on Stack Overflow

     2/5

   • What are the different types of storage in HTML5 ?

     In this article, you will get to know about different types of Web storage in HTML5. The web storage is more secure and large amounts of data can be stored locally on the client-side web browser. All the data is stored in key-value pairs. 

     In HTML5 there are two types of web storage API.

     • localStorage
     • SessionStorage

     localStorage: It is used to store data on the client side. It has no expiration time, so the data in the LocalStorage exists always till the user manually deletes it.

     Syntax:

     • For storing data in web storage: The key and value both should be string or number;

     LocalStorage.setItem("key", "value");

     • For getting data from web storage: We will pass the key and it will return value.

     LocalStorage.getItem("key");

     Example: In this example, we will use local storage.

     HTML

     <!DOCTYPE html><html><head>    <style>        body {            color: green;            text-align: center;font size...

     Check all answers on Geeksforgeeks

     3/5

   • What are the different types of Nodes in a Tree

     Trees are nonlinear data structures that organize data hierarchically and in a recursive manner. 

     It is a method of organizing and storing data in the computer in a way that makes it more effective to use. Nodes in the graph are connected via edges. It has different types of nodes which are called parent node, child node, leaf node, etc.

     What is a root node?

     A node that is the first or topmost node in a tree is called a root node. In every tree, there is always one root node, which is the only node that has never previously been connected to another node.

     The root node in this tree is node (A).

     Importance of root node:

     • The root node, which has no parents, is the highest node in the tree structure. 
     • The entire message is represented by this node, which is a global element. 

     Check all answers on Geeksforgeeks

     4/5

   • What are the different types of dependencies in Node.js ?

     NPM (Node Package Manager) is a package manager for the Node JavaScript platform. It consists of an npm registry that enables Open-Source developers to publish and share their code. You might need to install a few packages to streamline your project. Packages contain code written by other developers. Our root project has a package.json file that keeps track of all the packages we’ve installed. This file contains information about the project and defines the attributes that npm uses for installing dependencies, running scripts, and identifying the entry point for the package.

     • Production Dependencies
     • Development Dependencies
     • Peer Dependencies
     • Optional Dependencies
     • Bundled Dependencies

     Create Package json file: Run the following command from the root directory of the project to create the package.json file.

     npm init

     Note: Npm init prompts you for information about your project such as package name, version, test command, git repository, keywords, author and license.

     Check the images on geeksforgeeks

     Creating a package.json file 

     Adding Package: Following is the syntax to install the package:

     npm install <package_name>

     Example: Run the following command to install express package:

     npm install express

     Check the images on geeksforgeeks

     Installing Express...

     Check all answers on Geeksforgeeks

     5/5

   Show moreShow less

2. People also ask

   What are the two types of software?

   • The two main categories of software are application software and system software. An application is software that fulfills a specific need or performs tasks. System software is designed to run a computer's hardware and provides a platform for applications to run on top of.

   What is Software? Definition, Types and Examples - TechTarget

   www.techtarget.com/searchapparchitecture/definition/software

   See all results for this question

   What are some examples of computer software?

   • For desktop computers, laptops and tablets: For smartphones: Other examples include game engines, computational science software, industrial automation software and software as a service applications. Other than operating systems, some people also classify programming software and driver software as types of system software.

   A Complete Guide to Different Types of Software | Coderus

   www.coderus.com/software-101-a-complete-guide-to-the-different-types-of-software/

   See all results for this question

   What are the different types of application software?

   • Types of Application Software There are different types of application software and those are: General Purpose Software: This type of application software is used for a variety of tasks and it is not limited to performing a specific task only. For example, MS-Word, MS-Excel, PowerPoint, etc.

   What is Software? Definition, Types, Examples, and More - GeeksforGeeks

   www.geeksforgeeks.org/software-and-its-types/

   See all results for this question

   What is an example of system software?

   • System software runs things in the background and operating systems are an example of system software. For desktop computers, laptops and tablets: For smartphones: Other examples include game engines, computational science software, industrial automation software and software as a service applications.

   A Complete Guide to Different Types of Software | Coderus

   www.coderus.com/software-101-a-complete-guide-to-the-different-types-of-software/

   See all results for this question

3. www.indeed.com › types-of-software16 Types of Software: What They Are and How To Use Them - Indeed

   www.indeed.com › types-of-software

   • Cached

   Sep 26, 2023 · Learning about various computer software types can help you understand how software packages work and the value they provide. In this article, we explain what software is, list 16 types of software you may use and provide tips for getting the most out of your software.

4. www.geeksforgeeks.org › software-and-its-typesWhat is Software? Definition, Types, Examples, and More

   www.geeksforgeeks.org › software-and-its-types

   • Cached

   Aug 29, 2023 · You need software in order for the computer to operate effectively. It is a collection of data that is given to the computer to complete a particular task. three main categories of software are application software, programming software, and system software.

5. www.businessinsider.com › guides › techWhat Is Software? a Guide to All of the Different Types

   www.businessinsider.com › guides › tech

   • Cached

   Mar 26, 2021 · Software is computer code that tells a computer how to perform a specific task. There are many kinds of software, including operating systems, applications, and malware.

6. Videos

   • 

     4:01

     youtube.com

     What is Software? full explanation | Types of Computer Software

     Oct 1, 2021

     915.9K Views

   • 

     1:35

     techtarget.com

     What is Software? Definition, Types and Examples

     Mar 5, 2020

     0 Views

   • 

     6:14

     youtube.com

     What are the computer softwares and their types, examples and differences?

     Nov 22, 2021

     52K Views

   View all

7. www.techtarget.com › definition › softwareWhat is Software? Definition, Types and Examples - TechTarget

   www.techtarget.com › definition › software

   The two main categories of software are application software and system software. An application is software that fulfills a specific need or performs tasks. System software is designed to run a computer's hardware and provides a platform for applications to run on top of.

   • Author: Linda Rosencrance

   • Video Duration: 2 min

8. enosta.com › insights › types-of-softwareDifferent Types of Software: What are they & Examples

   enosta.com › insights › types-of-software

   • Cached

   Let’s delve into the various types of software and some real-world examples to help you grasp its significance and versatility. What is Software? Software can be defined as a collection of instructions and data that enables computers and devices to perform specific tasks.

   • 5/5 (1)

9. www.coderus.com › software-101-a-complete-guide-toA Complete Guide to Different Types of Software | Coderus

   www.coderus.com › software-101-a-complete-guide-to

   • Cached

   Nov 10, 2020 · Firmware. Programming Software. Driver Software. Freeware. Shareware. Open Source Software.

10. en.wikipedia.org › wiki › SoftwareSoftware - Wikipedia

    en.wikipedia.org › wiki › Software

    • Cached

    On virtually all computer platforms, software can be grouped into a few broad categories. Purpose, or domain of use. Based on the goal, computer software can be divided into: Application software uses the computer system to perform special functions