CBSE CS and IP

CBSE Class 11 & 12 Computer Science and Informatics Practices Python Materials, Video Lecture

Showing posts with label Class 12 CS. Show all posts
Showing posts with label Class 12 CS. Show all posts

IPR (Intellectual Property Rights)

IPR

What is IPR?

  • If a person creates something by himself he posses the right on it, this right is called Intellectual property rights (IPR).
  • IPR gives the right to the creator over the use of his/her creation for a certain period of time.
  • Intellectual property rights can be obtained at the national level/regional level.

Types Of IPR -

The most well-known types are -
  1. Copyrights
  2. Patents
  3. Trademarks
  4. Trade Secrets
The intellectual property right encourages the creation of a wide variety of intellectual goods. To achieve this, the law gives people and businesses property rights to the information and intellectual goods they create, usually for a limited period of time.

Wat Is Copyrights?

  • Copyright (or author’s right) is a legal term, it is used to describe the rights that creators have over their artistic and literary creation. 
  • Copyright is automatic; once you create something, it is yours. However, if you want to file a lawsuit against the infringement of your copyrighted work, then registration of your copyright will be necessary.
  • Works covered by copyright range from books, music, paintings, sculpture, and films, to computer programs, databases, advertisements, maps, and technical drawings.
  • Copyright protection extends only to expressions, and not to ideas, procedures, methods of operation, or mathematical concepts as such. 
  • Typically, the public law duration of a copyright expires 50 to 100 years after the creator dies, depending on the jurisdiction.
  • Copyright may or may not be available for a number of objects such as titles, slogans, or logos, depending on whether they contain sufficient authorship.
  • In the majority of countries, and according to the Berne Convention, copyright protection is obtained automatically without the need for registration or other formalities.

What are Patents?

  • A patent is a type of limited-duration protection that can be used to protect inventions (or discoveries) that are new, non-obvious, and useful, such a new process, the machine, article of manufacture, or composition of matter.
  • When a property owner holds a patent, others are prevented, under law, from offering for sale, making, or using the product.
  • A patent is an exclusive right granted for an invention, which is a product or a process that provides, in general, a new way of doing something, or offers a new technical solution to a problem. 
  • To get a patent, technical information about the invention must be disclosed to the public in a patent application.
  • Kind of protection: Patent protection means that the invention cannot be commercially made, used, distributed, imported, or sold by others without the patent owner's consent.
  • The protection is granted for a limited period, generally 20 years from the filing date of the application.

What Are Trademarks?

  • A trademark is a sign capable of distinguishing the goods or services of one enterprise from those of other enterprises. Trademarks are protected by intellectual property rights.
  • At the national/regional level, trademark protection can be obtained through registration, by filing an application for registration with the national/regional trademark office and paying the required fees.
  • The term of trademark registration can vary but is usually ten years.

What Is Trade Secrets -

  • Trade secrets refer to specific, private information that is important to a business because it gives the business a competitive advantage in its marketplace. Trade secrets are intellectual property (IP) rights on confidential information that may be sold or licensed.
  • Trade secrets are not made public, unlike patents, they do not provide “defensive” protection, as being prior art.
  • Trade secrets are protected without official registration; however, an owner of a trade secret whose rights are breached–i.e. someone steals their trade secret–may ask a court to ask against that individual and prevent them from using the trade secret.
  • kind of information is protected by trade secret: 
  • recipes for certain foods and beverages (like coca-cola or Sprite), new inventions, software, processes, even different marketing strategies. , technical information, such as information concerning manufacturing processes, pharmaceutical test data, designs and drawings of computer programs, distribution methods, list of suppliers and clients, and advertising strategies, financial information, formulas and recipes, and source codes.
  • A trade secret owner, however, cannot stop others from using the same technical or commercial information, if they acquired or developed such information independently by themselves through their own R&D, reverse engineering or marketing analysis, etc. 



MYSQL ORDER BY

 

order by

MYSQL ORDER BY clause

When you use the SELECT statement to query data from a table, the result set is not ordered. It means that the rows in the result set can be in any order.

To sort the result set, you add the ORDER BY clause to the SELECT statement. 
The SQL ORDER BY clause is used to sort the records in the result set for a SELECT statement.

The syntax for using ORDER BY -:

SELECT expressions
FROM tables
[WHERE conditions]
[GROUP BY <COL_NAME>
HAVING <CONDITION ON GROUPS>]
ORDER BY COL1,COL2,.. [ ASC | DESC ];

ASC –:
 Ascending order by COLUMNS [Default]
DESC – :
Descending order by COLUMNS

Note -:

ORDER BY clause is always evaluated after the FROM and SELECT clause.





MYSQL GROUP BY and HAVING



 MySQL  GROUP BY

The GROUP BY statement in SQL is used to arrange data into groups with the help of some functions. GROUP BY statement is used to retrieve grouped records based on one or more columns.

The aggregate function on SELECT Statement can be used with the GROUP BY Statement.
Aggregate Functions : AVG(),COUNT(),MAX(),MIN(),SUM().

The syntax for GROUP BY Statement in SQL -:

SELECT  <COL_NAME>
FROM  <TABLE>
WHERE  <CONDITION>
GROUP BY <COL_NAME>
HAVING <CONDITION ON GROUPS>;

Description MySQL GROUP BY -:

The GROUP BY clause combines all those records (Rows) that have identical values in a particular field (Column) or a group of fields.
This grouping results in one summary record per group.

If you want to total salary for all employees then we used the SUM function and you will get a sum of the total salary.
group by

If you want to total salary department wise like D1 or D2 then we have used GROUP BY.
group by MYSQL

Now you have also used the SUM function and using GROUP BY  tHen you will get the department-wise total salary  You can see all D1 and D2 columns combine in one row.
group by MYSQL

GROUP BY(Nested Grouping) using more than one column -

If you want to GROUP BY using more than one column, you can give all columns by using comma separation.  

Syntex -

SELECT Col1, Col2,AGG_FUN(Col3)
FROM Tab1
[WHERE <Condition>]
GROUP BY Col1, Col2 ;

group by MYSQL Nested grouping

GROUP BY Condition -

The GROUP BY clause is used with Aggregate Functions.
 All the fields (Columns) other than used in aggregate function should be put in GROUP BY clause.

Syntex -

SELECT AGG_FUN(Col1), Col2, Col3
FROM Tab1
WHERE <Condition>
GROUP BY Col2, Col3;










CLASS 12 SAMPLE QUESTION PAPER SOLUTIONS (COMPUTER SCIENCE) - 2020-21

 

CLASS 12 COMPUTER SCIENCE SAMPLE QUESTION PAPER

Hope you are doing great. I have prepared a question-wise solution for cbse class 12 informatics practices sample question paper 2020-21. I have also discussed cbse class 12 informatics practices question paper pattern 2020. To download the question paper click here.

To check the video you can click on the below-given link. After going to the video you will find time in the description of the video where you can click to go to any question. 

Solution for Sample Question Paper - 2020-21


Data Structures in Python (List / Stack / Queue)