Laws / rules associated with evolution, PL-SQL Programming

Assignment Help:

LAWS / RULES -

Dollo's Law                     :           Living organisms do exhibit evolutionary irreversibility or evolution is irreversible.

Williston's Law               :           During the evolution of a lineage, serially homologous parts tend to reduce in number but get more and more differentiated and advance in function.

e.g. Trilobites - were having large number of appendages and more or less identical in shape and structure.

Modern arthropods possess fewer appendages but specialized function.

In fish the maximum number of bones in the skull has been counted 150. whereas in mammals only about 28 bones are present.

Cope's rule                     :           Organisms have tendency towards increase in size during their evolution.

E.g., evolution of horse, camel, elephant and all other herbivorous mammals exhibit increase in size. Dinosaurs, Turtle and Tortoise.

Hardy-Weinberg's Law  :            The relative frequencies of various kinds of gene in a large and randomly mating population tend to remain constant from generation to generation in the absence of mutation, selection and gene flow, (i.e., factors affecting gene frequency).

Gloger's Rule                  :           Desert animals are heavily pigmented and are comparatively small in Size.

Rapoport's Rule              :           Species adapted to colder region have wider latitudinal distribution than the species adapted to warmed climates.

Jordon's Rule                 :           Fishes of colder water are larger in size with more vertebra then those living in warmer water.

Bergman's Law               :           Warm blooded animals are larger in size in the colder regions as compared to hotter parts.

Allen's Law                     :           Extremities of the body like tails and ears become smaller in colder areas.

Baldwin effect                 :           Natural selection acts to bring about adaptations, could arise as a direct response to the environment or to the needs of organisms.

Sewall - Wright effect     :           The random changes in gene frequency occurring by chance in small population and not under the control of natural selection are called Sewall-Wright effect.

Bottleneck effect              :           If small deme isolated and restricted in distribution are exposed to random genetic drift resulting in the fixation of certain genes. The changes occurring in the gene ratio is called bottleneck effect. If in this case the gene pool is already limited the population cannot regain its former richness, that may cause extinction.


Related Discussions:- Laws / rules associated with evolution

Procedural constraint enforcement (triggers) , Procedural Constraint Enforc...

Procedural Constraint Enforcement (Triggers) SQL has an alternative method of addressing database integrity, involving event-driven procedural code. The special procedures th

Functions in pl/sql, Functions   The function is a subprogram that cal...

Functions   The function is a subprogram that calculates a value. The Functions and procedures are structured similar, except that the functions have a RETURN clause. You can

Anatomy of a table, Anatomy of a Table: Figure shows the terminology u...

Anatomy of a Table: Figure shows the terminology used in SQL to refer to parts of the structure of a table. As you can see, SQL has no official terms for its counterpa

Update the Status of an Ordere, Create a procedure named STATUS_SHIP_SP tha...

Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTAT

Exceptions - syntax, Exceptions An exception is the runtime error or wa...

Exceptions An exception is the runtime error or warning condition that can be predefined or user-defined. The Predefined exceptions are raised implicitly through runtime system

Name resolution-naming conventions, Name Resolution In potentially uncer...

Name Resolution In potentially uncertain SQL statements, the names of the database columns take precedence over the names of the local variables and formal parameters. For e.g.

Maintain an audit trail of product table changes, The accuracy of product t...

The accuracy of product table data is critical and the Brwebean's. owner wants to have an audit file that contains information regarding all DML activity on the BB_PRODUCT table. T

Dynamic ranges- iterative control, Dynamic Ranges The PL/SQL lets you det...

Dynamic Ranges The PL/SQL lets you determine the loop range dynamically at run time, as the example below shows: SELECT COUNT(empno) INTO emp_count FROM emp; FOR i IN 1..emp_cou

Sqls counterpart of the key words, SQLs counterpart of the key words: ...

SQLs counterpart of the key words: The text from the opening parenthesis to the end of the fourth line specifies the declared type of the table, meaning that every table ever

Case sensitivity-naming conventions, Case Sensitivity Similar to all the...

Case Sensitivity Similar to all the identifiers, the variables, the names of constants, and parameters are not case sensitive. For illustration, PL/SQL considers the following n

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