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

Operators on tables and rows, Operators on Tables and Rows Row Extrac...

Operators on Tables and Rows Row Extraction TUPLE FROM r, SQL has row subqueries. These are just like scalar subqueries except that they may specify more than one column.

Using for update, Using FOR UPDATE If you declare a cursor which will ...

Using FOR UPDATE If you declare a cursor which will be referenced in the CURRENT OF clause of an UPDATE or DELETE statement, you should use the FOR UPDATE clause to obtain an

Defining autonomous transactions, Defining Autonomous Transactions To ...

Defining Autonomous Transactions To define an autonomous transaction, you use the pragma (compiler directive) AUTONOMOUS_TRANSACTION. The pragma instructs the PL/SQL compiler

Join query, Using a join on 3 tables, select 5 columns and 10 rows from the...

Using a join on 3 tables, select 5 columns and 10 rows from the 3 tables without the use of a Cartesian product Query: SELECT E.LAST_NAME, E.FIRST_NAME, S.BUILDING, S.BRAN

Heap sort algorithm in pl sql, I want to implement heap sort algorithm in p...

I want to implement heap sort algorithm in pl sql please share the source code for guidance

Select into statement - syntax, SELECT INTO Statement   The SELECT INT...

SELECT INTO Statement   The SELECT INTO statement retrieve data from one or more database tables, and then assigns the selected values to the variables or fields. Syntax:

PROCEDURE, Create a procedure named DDPROJ_SP that retrieves project inform...

Create a procedure named DDPROJ_SP that retrieves project information for a specific project based on a project ID. The procedure should have two parameters: one to accept a projec

%rowcount, %ROWCOUNT When its cursor or cursor variable is opened, the...

%ROWCOUNT When its cursor or cursor variable is opened, the %ROWCOUNT is zeroed. Before the first fetch, the %ROWCOUNT yields 0. Afterward, it yields the number of rows fetche

Group and having query, Using a join on 2 tables, select all columns and 10...

Using a join on 2 tables, select all columns and 10 rows from the 2 tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 E JOIN STAFF S ON E.EMP_

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

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