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

Using rename in combination with join - sql, Using RENAME in combination wi...

Using RENAME in combination with JOIN - SQL Example gives pairs of ids of students having the same name, by joining two renamings of IS_CALLED. Example gives an equivalent ex

Majority of differences among 9i-10g-11g, Majority of Differences among 9i,...

Majority of Differences among 9i, 10G, 11G :- These are some combine feature which has differences among others. Automatic Workload Repository (AWR) Drop database' s

Using forall and bulk collect - bulk bind performance, Using FORALL and BUL...

Using FORALL and BULK COLLECT Together You can unite the BULK COLLECT clause with the FORALL statement, in that case, the SQL engine bulk-binds column values incrementally. In

Sql pseudocolumns, SQL Pseudocolumns The PL/SQL recognizes the followin...

SQL Pseudocolumns The PL/SQL recognizes the following SQL pseudocolumns, that returns the specific data items: LEVEL, NEXTVAL, CURRVAL, ROWID, & ROWNUM. The Pseudocolumns are n

Sql outer join, SQL outer join SELECT * FROM IS_CALLED NATURAL LEFT...

SQL outer join SELECT * FROM IS_CALLED NATURAL LEFT JOIN IS_ENROLLED_ON Note that adding LEFT to an invocation of CROSS JOIN has no effect unless the right-hand operand

%found - implicit cursor attributes, %FOUND Until the SQL data manipul...

%FOUND Until the SQL data manipulation statement is executed, the %FOUND yields NULL. Afterward, the %FOUND yields TRUE, when an INSERT, UPDATE, or DELETE statement affected o

Use bulk binds - improve performance of application, Use Bulk Binds If...

Use Bulk Binds If SQL statements execute inside a loop using the collection elements as bind variables, context switching between the PL/SQL & SQL engines can slow down the ex

Scope rules - user-defined exceptions, Scope Rules You cannot declare ...

Scope Rules You cannot declare an exception twice in the similar block. Though, you can, declare the similar exception in 2 different blocks. The Exceptions declared in a bloc

Bulk binds advantages, Bulk Binds advantages In the Embedded Oracle RDB...

Bulk Binds advantages In the Embedded Oracle RDBMS, the PL/SQL engines accept any valid PL/SQL subprogram or block. As the figure shows, the PL/SQL engine executes all procedur

Cursor variables, Cursor Variables Similar to a cursor, cursor variable...

Cursor Variables Similar to a cursor, cursor variable points to the current row in the result set of a multi-row query. But, dissimilar a cursor, a cursor variable can be opene

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