Types of evolution, PL-SQL Programming

Assignment Help:

TYPES OF EVOLUTION -

Sequential evolution                  :                    Minor changes in the gene pool of a population from one generation to the next, with the result that no new populations are formed, but the descendent population is not genetically identical with its predecessor.

Microevolution                            :           Evolution of subspecies or geographic races.

Macroevolution                           :           Evolution of species and genera.

Megaevolution (Simpson 1953)   :            Evolution of families, order, classes and phylum.

Quantum evolution                     :                    (a) Evolution of higher taxonomic group such as orders and classes (b) Evolutionary processes operating above species level i.e., combination of macro and mega evolutions.

Phyletic evolution                       :                    The directional changes in the average character of a population. This is caused either due to adaptation to a shifting environment or due to increasing specialization for a particualr environment or improved adaptation in a constant environment.

Convergent evolution                  :                    Acquiring similar sets of characteristics in response to the adaptation to a common or similar environment by the individuals of two or more totally unrelated or distantly related groups. As a result, the organism with completely different body organization come to possess superficial resemblance.

Divergent evolution/                    :           Development of different structures from a common ancestral form.

adaptive radiation                                            Examples of adaptive radiation occurred on the isolated continent of Australia, where the diversity of habitats and the absence of competitors sparked an adaptive radiation of marsupials (pouched mammals).

Progressive evolution                 :           Development of complex and specialized structure from simpler forms.

Retrogressive evolution              :           Development of simpler structure from complex forms.

Parallel evolution                       :                     Organisms of different classes can acquire similar characters independently and separately to avail the similar environment. Parallel evolution occurs when genetically related species adapt to similar environmental changes in similar ways.

Co-evolution                               :           In nature, species frequently interact so closely that evolutionary changes in one species may cause evolutionary adjustments in others. This evolutionary interaction between organisms is called co-evolution.


Related Discussions:- Types of evolution

Design a script and integrate procedures, Initial thought process: Design...

Initial thought process: Design a script which was simple and user friendly. Integrate procedures/functions to extract data under the hood. I focused on giving the user the opt

Rowid - sql pseudocolumns, ROWID The ROWID returns the rowid (binary a...

ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il

Triggers, At times, customers make mistakes in submitting their orders and ...

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

Remote operations in pl sql, Remote Operations: As the illustration sh...

Remote Operations: As the illustration shows below, the PL/SQL subprograms can execute the dynamic SQL statements which refer to the objects on a remote database: PROCEDURE

Structure of an object type in pl/sql, Structure of an Object Type: Si...

Structure of an Object Type: Similar to package, an object type has 2 parts: the specification and the body. The specification is the interface to your applications; it declar

Creating a table, Creating a Table Syantax: CREATE TABLE ENROL...

Creating a Table Syantax: CREATE TABLE ENROLMENT (StudentId SID, Name   VARCHAR (30) NOT NULL, CourseId CID, PRIMARY KEY (StudentId, CourseId)) ; Explan

Example of foreign key constraint - sql, Example of Foreign Key Constraint ...

Example of Foreign Key Constraint Example: Alternative formulation for 6.3 as a foreign key constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_take_exam

Example of add constraint in sql, Example of ADD CONSTRAINT in SQL Exa...

Example of ADD CONSTRAINT in SQL Example: Alternative formulation for MAX_ENROLMENTS ALTER TABLE IS_ENROLLED_ON ADD CONSTRAINT MAX_ENROLMENTS CHECK ((SELECT COUNT (*)

Pragma restrict_references in pl sql, Using Pragma RESTRICT_REFERENCES: ...

Using Pragma RESTRICT_REFERENCES: The function called from the SQL statements should obey certain rules meant to control the side effects. To check for violation of the rules,

Theory of catastrophism or catalysm - origin of life, THEO R Y OF CATASTR...

THEO R Y OF CATASTROPHISM OR CATALYSM (CUVIER 1769-1832) - The world has passed thorugh several stages and at the end of each stage there was a catastrophe killing all the

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd