MySQL_Notes
3 Pages

MySQL_Notes

Course Number: CG 525, Fall 2009

College/University: Pratt

Word Count: 2032

Rating:

Document Preview

MySQL/PHP Workshop 2 MySQL Lectures (June 22nd and June 24 th) 2 PHP Lectures (June 29 th and July 1st) Each lecture builds on concepts taught and learned in the previous lecture. The first two lectures discuss the concept of a relational database such as MySQL and show you how to manipulate the data stored in the database from the command line. It is essential to learn this first because PHP makes use of...

Unformatted Document Excerpt
Coursehero >> New York >> Pratt >> CG 525

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Workshop MySQL/PHP 2 MySQL Lectures (June 22nd and June 24 th) 2 PHP Lectures (June 29 th and July 1st) Each lecture builds on concepts taught and learned in the previous lecture. The first two lectures discuss the concept of a relational database such as MySQL and show you how to manipulate the data stored in the database from the command line. It is essential to learn this first because PHP makes use of the language of the database. The third and fourth lectures will introduce you to PHP, a server-side scripting language that allows you to interact with the MySQL database from a web browser and create fancy web pages to display the data. PHP is the go-between that fetches the data from the MySQL database and then spits it out dynamically as the nicelyformatted HTML page that the browser expects. MySQL Part 1 Michael Honig Weill Cornell Medical College Computational Genomics Core Facility Agenda Why Relational Databases ? Relational Databases Introduction to MySQL Entering Basic Queries Workshop: Create Database/Exercises Reading: MySQL Documentation (see course web site.) Large collections of well-annotated data Most public databases provide cross-links to other databases NCBI GenBank:NCBI taxonomy Gene Ontology:SwissProt human, mouse, fly, FlyBase, SGD SwissProt:PFAM, SwissProt:Prosite Although cross-linking data is available, one cannot integrate all the related data in one query Benefits of Relational Databases The Relational Model Data and relationships are represented by a collection of tables. Each table has a certain number of columns with unique names The goal of a relational database is to provide an environment that is both convenient and efficient to use in: Retrieving information from the database (queries) Storing information into the database. Redundancy can be reduced Same information may be duplicated in several places. All copies may not be updated properly. Standards can be enforced Restrict columns to specified data-types and sizes Security restrictions can be applied Every user of the system should be able to access only the data they are permitted to see. Excel Spreadsheet of Sample Data to be loaded into our MySQL database, ensmartdb Ensembl Gene ID ENSG00000186891.3 ENSG00000078808.4 ENSG00000176022.1 ENSG00000160087.5 ENSG00000162572.4 ENSG00000162576.4 ENSG00000175756.3 ENSG00000131586.2 ENSG00000179403.2 ENSG00000160072.5 ENSG00000008128.5 ENSG00000169911.4 ENSG00000008130.3 ENSG00000078369.3 ENSMUSG00000041954.1 ENSMUSG00000023286.1 Symbol / Name TNFRSF18 CAB45 B3GALT6 UBE2J2 SCNN1D MGC3047 AKIP MRPL20 WARP ATAD3B CDC2L2 SLC35E2 FLJ13052 GNB1 TNFRSF18 UBE2J2 Chromosome Name Position (bp) End Position (bp) LocusLink IDTaxonomy_ID Start Common NameSpecies 1 1044947 1048147 8784 9606 human Homo sapiens 1 1058370 1073469 51150 9606 human Homo sapiens 1 1073703 1076476 126792 9606 human Homo sapiens 1 1095352 1115292 118424 9606 human Homo sapiens 1 1123634 1133467 6339 9606 human Homo sapiens 1 1194130 1199973 84308 9606 human Homo sapiens 1 1215168 1216641 54998 9606 human Homo sapiens 1 1288703 1294063 55052 9606 human Homo sapiens 1 1322311 1327547 64856 9606 human Homo sapiens 1 1358611 1396091 83858 9606 human Homo sapiens 1 1582617 1604060 985 9606 human Homo sapiens 1 1611978 1625728 9906 9606 human Homo sapiens 1 1630975 1659805 65220 9606 human Homo sapiens 1 1665027 1770792 2782 9606 human Homo sapiens 4 154139702 154142251 21936 10090 mouse Mus musculus 4 154057210 1540722964 140499 10090 mouse Mus musculus 1 Genbank Flat File Flat Files are not Relational Data-type is part of the data Contains multiline records There is a considerable number of repeating elements or duplicate data This wastes vast amounts of disk space and will slow down any queries we run against the table More potential for typographical errors Normalization Entity Relationship Diagram (ERD) One to Many Relationship An organism can have one to many ensembl_gene_ids associated with it, but an ensembl_gene_id is associated with one and only one organism. The crows foot indicates the many side of the relationship. Organism is the parent table and Gene is the child table. Organism_ID in the Gene table is a foreign key (FK) reference to ID in the Organism table Normalization is the process of adjusting a data model so that it consists of tables that conform to strict relational tenets, or norms. At its core, the process calls for removing redundancy from the database. One does not build a house without blueprints, or a database without a data model. A data model consists of an ERD (Entity Relationship Diagram) and the supporting detailed column and constraint definitions. The ERD shows the entities, or areas of interest, of the database and how they interrelate. Gene ID (PK) Ensembl_Gene_ID Organism_ID (FK) Name LocusLink Chromosome Chromo_Start Chromo_End Description Organism ID (PK) Taxonomy_ID Common_Name Species MySQL Introduction to MySQL MySQL is a popular, open source database. Officially pronounced my Ess Cue Ell (not my sequel). Handles very large databases; very fast performance. Why are we using MySQL? Free (much cheaper than Oracle!) Each student can install MySQL locally. Easy to use Shell for creating tables, querying tables, etc. Easy to use with PHP, Java, Perl, etc. 2 Connecting to MySQL Sample Session For example: shell> mysql -u root -p Enter password: ***** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1966 to server version: 3.23.58 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> MySQL provides an interactive shell for creating tables, inserting data, etc. On UNIX, you connect to MySQL via the mysql command. To get help: shell> mysql --help To connect: shell> mysql u <username> -p You will then be prompted to type in your password To exit the MySQL shell, type quit; mysql> quit Basic Queries Basic Queries (continued) Once logged in, you can try some simple queries. For example: Heres another query which demonstrates that you can use MySQL as a simple calculator: mysql> select user(), version(), current_date(); +----------------+-----------+----------------+ | user() | version() | current_date() | +----------------+-----------+----------------+ | root@localhost | 3.23.58 | 2004-06-07 | +----------------+-----------+----------------+ 1 row in set (0.00 sec) Note that most MySQL commands end with a semicolon (;) MySQL returns the total number of rows found, and the total time to execute the query. mysql> select 2+2, (4+1)*5, SIN(PI()/4); +-----+---------+-------------+ | 2+2 | (4+1)*5 | SIN(PI()/4) | +-----+---------+-------------+ | 4 | 25 | 0.707107 | +-----+---------+-------------+ 1 row in set (0.02 sec) Basic Queries (continued) Multi-Line Commands You can also enter multiple statements on a single line. Just end each one with a semicolon: mysql> select version(); select now(); +-----------+ | version() | +-----------+ | 3.23.58 | +-----------+ 1 row in set (0.00 sec) +---------------------+ | now() | +---------------------+ | 2004-06-07 12:50:15 | +---------------------+ 1 row in set (0.00 sec) MySQL determines where your statement ends by looking for the terminating not semicolon, by looking for the end of the input line. Here's a simple multiple-line statement: mysql> select -> user() -> , -> current_date(); +----------------+----------------+ | user() | current_date() | +----------------+----------------+ | root@localhost | 2004-06-07 | +----------------+----------------+ 1 row in set (0.00 sec) 3 Canceling a Command Using a Database If you decide that you do not want to execute a command that you are in the process of issuing, cancel it by typing \c : Using a database involves three steps: mysql> select user(), -> current_date(), -> \c mysql> Creating (initializing) the database Creating the tables within the database Interacting with the tables by inserting, retrieving, modifying, or deleting data Creating a Database Creating a Database (continued) To create a new database issue the command create database. To get started on your own database, first check which databases currently exist. Use the SHOW statement to find out which databases currently exist on the server: mysql> create database ensmartdb; Query OK, 1 row affected (0.00 sec) mysql> show databases; +----------+ | Database | +----------+ | mysql | | test | +----------+ 2 rows in set (0.01 sec) To select a database, issue the command use; mysql> use ensmartdb; Database changed Creating Tables Creating Tables (continued) Once you have selected a database, you can view all existing tables in the database: mysql> show tables; Empty set (0.00 sec) Lets create a table for storing data about genes. Table: gene COLUMN DATATYPE An empty set, as you may guess, indicates that no tables have been created yet in the database. gene_id name ensembl_gene_id organism_id locuslink chromosome chromo_start chromo_end description INTEGER VARCHAR(35) VARCHAR(50) INTEGER VARCHAR(10) TINYINT INTEGER INTEGER VARCHAR(255) 4 Datatypes used in this database Column Type Attributes VARCHAR a variable length fixed string INTEGER a whole number ranging from -2147683648 to 2147483647 TINYINT a whole number ranging from -128 to 127 DATE a date value, in YYYY-MM-DD format NULL is something of a typeless value. Generally, its used to mean no value, unknown value, missing value, out of range, none of the above, and so forth. You can insert NULL values into tables, retrieve them from tables, and test whether or not a value is NULL. You cant perform arithmetic on NULL valuesand if you try, the result will be NULL. AUTO_INCREMENT Use the AUTO_INCREMENT attribute when you wish to generate unique identifiers or values in a series. AUTO_INCREMENT values normally begin at 1 and increase by 1 per row. When you insert NULL into an AUTO_INCREMENT column, MySQL inserts a value one greater than the current maximum value in that column. You may have at most one AUTO_INCREMENT column in a table. MySQL also requires that every AUTO_INCREMENT column have a unique index. Column Type Attributes (continued) Creating Tables (Continued) UNSIGNED This attribute disallows negative values. Making a column UNSIGNED does not change the size of the underlying datatypes range; it just shifts the range upward. Consider this table specification: To create a table, use the CREATE TABLE command: CREATE TABLE gene ( gene_id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY (gene_id), name VARCHAR(35) NOT NULL, ensembl_gene_id VARCHAR(50) NOT NULL, locuslink VARCHAR(10) NULL, chromosome TINYINT NULL, chromo_start INTEGER NULL, chromo_end INTEGER NULL, description VARCHAR(255) NULL, UNIQUE(ensembl_gene_id) ); CREATE TABLE my_table ( column_tiny column_tiny_u ) TINYINT, TINYINT UNSIGNED column_tiny and column_tiny_u are both TINYINT columns with a range of 256 values. However, the range of column_tiny is -128 to 127 whereas the range of column_tiny_u is 0 to 255. PRIMARY KEY means that the column is indexed for fast lookups and that each value in the column must be unique. This prevents us from using the same ID twice by mistake. mysql> -> -> -> -> -> -> -> -> -> -> -> Query OK, 0 rows affected (0.00 sec) Showing Tables Describing Tables To verify that the table gene has been created, issue the SHOW TABLES command: To view a table structure, use the DESCRIBE command: mysql> show tables; +---------------------+ | Tables_in_ensmart...

Textbooks related to the document above:

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

Pratt - CG - 525
FlashMXandPHPCommunicating with PHP (or any other serverside script) from Flash has gotten much easier with the introduction of the LoadVars object in Flash MX. Here's a sample in which we use a MySQL database (containing friends' email and phone in
Pratt - CG - 525
An Introduction to PHP Lesson I: An Intro PHP, or Hypertext Preprocessor, is a embedded server-side scripting language. Not only is PHP's popularity growing among web designers, but its features are growing with the release and development of PHP4.
Pratt - CG - 525
Search For :in:All SectionsGet Man PagemysqldumpSection: MySQL database (1) Updated: 19 December 2000DB2 SQL SolutionsPredict &amp; Prevent Potential Problems For Your SQL Database.Synchronize DatabasesSynchronize massive amounts of offlin
Pratt - CG - 525
Using PHP To Backup MySQL DatabaseAds by Goooooogle Free MySQL Dev Tool Create, execute &amp; modify queries Download Toad for MySQL freewarewww.quest.comPHP MySQL generator Generate PHP code for any local or remote MySQL database.www.xlinesoft.com/
Pratt - CG - 525
String Commands: Chop() Chr() echo explode() get_meta_tags() htmlentities() htmlspecialchars() implode() Join() Print Strcasecmp() Remove trailing whitespace $trimmed = chop ($line); Return a specific character $str = chr (27); Output one or more str
Pratt - CG - 525
MySQL : Unix@CMS : University of GreenwichMySQL Can I use MySQL? How and where can I connect to MySQL? Example MySQL command line session Is there a web interface for managing my MySQL database? How do I use mysqldump to backup my database? Ca
Pratt - CG - 525
SITE SEARCH HOME WAP Tutorial WAP HOME WAP Introduction WAP Basic WML Formatting WML Links WML Input WML Tasks WML Timer WML Variables WML Examples WML Validator WAP Demo WAP W3Schools References WML Reference WML Entities WML DTD Resources WAP Forum
Pratt - CG - 525
PHP Fundamentals BASIC SYNTAX All PHP code must be enclosed inside &lt;? and ?&gt; closing tags echo outputs text. &lt;? $a=1; echo $a; ?&gt; will display the value of $a which is 1 &lt;? $a=5; echo &quot;Display this text \$a=$a&quot;; ?&gt; will display whatever is between th
Pratt - CG - 525
Dev Shed04/24/2005 04:21:19 PMPHPWAPEnabling a Website with PHP3 Contributed by Mike Banahan 20000612 [ Send Me Similar Content When Posted ] [ Add Developer Shed Headlines To Your Site ]DISCUSSNEWSSENDPRINTPDFArticle Index:The UK
Pratt - CG - 525
commentsinphp.txt Printed: Monday, April 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57Page 1 of 2 4, 2005 2:24:43 PMComments Comme
Pratt - CG - 525
cookiecode.php Printed: Monday, 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45Page 1 of 1 April 4, 2005 2:19:26 PMsetcookie() is the main function that is used to
Pratt - CG - 525
WML Tag ReferenceThe links in the &quot;Start tag&quot; column points to more useful information about the specific tag. It also cover attributes of the specific tag and code examples.Deck / Card ElementsStart tag &lt;access&gt; &lt;card&gt; &lt;head&gt; &lt;meta&gt; &lt;template&gt;
Pratt - CG - 525
Proxy Scripting with PHP and Flash Tutorial - by: Flash-dB.com - 2002 http:/www.flash-db.com/Search/ProxyScriptingTutorial.php Introduction One of the greatest things about the internet is the wealth of free information and content available. Their a
Pratt - CG - 525
Article Publication Date: August 3, 2000 Article URL: http:/www.zend.com/zend/tut/wap.php Author URL: n/a Back to ArticleBuilding WML Applications Using PHPAugust 3, 2000 By W.J. Gilmore Intended Audience Overview Learning Objectives Definitions B
Pratt - CG - 525
A Crash Course in WML.txt Printed: Sunday, April 24, 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Page 1 of 7 2005 5:13:26 PMA Crash Course in WML - P
Pratt - CG - 525
mimes4wap.txt Printed: Sunday, 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Add the AddType AddType AddType AddType AddType AddType AddType AddType AddType AddType AddType AddType AddType AddType A
Pratt - CG - 525
Pratt - CG - 525
Mail() From Start To Finishby Andrew Walsh (kendo)2004-06-17SynopsisEver wanted to know how to send basic text emails/Html emails and emails with attachments? In this tutorial you will learn how to send emails in text, html and with attachments.
Pratt - CG - 525
Max WML deck sizeThe recommended maximal size = Max WML deck size - 300 BNOKIA 6210, 3330, 3610, 6340, 8910i 5100, 9110i 6650 3410 6800, 6250, 7110 3320/60, 3350, 3510, 3590, 5210, 5510, 6310, 6310i, 6510, 6590, 8310/90, 8910, 6100, 6610, 7210, 72
Pratt - CG - 525
headersCommand.txt Printed: Monday, April 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38Page 1 of 2 4, 2005 2:12:09 PMheader (PHP 3, PHP 4 &gt;= 4.0.0) Send a raw HTTP head
Pratt - CG - 520
Pratt Institute's campus, located in the historic landmark district of ClintonHill in northern Brooklyn has evolved during the past century from a five blockarea to twenty-five acres.The Institute is a fully-accredited private college granting
Pratt - CG - 520
Chapter 6: Mac/ISO Hybrid_The HYBRID format combines both ISO 9660 and HFS format on a single disc. This allows Macintosh users to see the normal icons and window positions for the data, while maintaining complete compatibility with DOS/Windows sy
Pratt - CG - 520
adaptive palette A set of colors created by sampling the spectrum of hues appearing most commonly in an image and optimizing them for color reduction. aliasing A jagged, stairstep pattern caused by the square edges of individual pixels that most comm
Harvard - BIOSUN - 1
IJE vol.33 no.1 International Epidemiological Association 2004; all rights reserved.International Journal of Epidemiology 2004;33:68 DOI: 10.1093/ije/dyh034Commentary: Screening mammography: a decision analysisDonald BerryArguments over the cr
Harvard - BIOSUN - 1
IJE vol.33 no.1 International Epidemiological Association 2004; all rights reserved.International Journal of Epidemiology 2004;33:5664 DOI: 10.1093/ije/dyh014On the benefits and harms of screening for breast cancerPeter C GtzscheIn their qual
Harvard - BIOSUN - 1
IJE vol.33 no.1 International Epidemiological Association 2004; all rights reserved.International Journal of Epidemiology 2004;33:6973 DOI: 10.1093/ije/dyh061RejoinderDavid A Freedman, Diana B Petitti and James M RobinsWe reviewed1 the critiq
Harvard - BIOSUN - 1
Harvard - BIOSUN - 1
Harvard - BIOSUN - 1
Harvard - ASTRO - 201
Some of the Hot Jupiters do not match well models based on Jupiter &amp; Saturn: More diversity than expected ?.Gaudi (2005) &amp; Charbonneau et al (2006) w Bodenheimer et al.(2003), Laughlin et al. (2005) models; and Burrows et al. (2003)Interio
Harvard - AY - 45
THE ASTROPHYSICAL JOURNAL, 536 : 6267, 2000 June 10( 2000. The American Astronomical Society. All rights reserved. Printed in U.S.A.TESTS OF THE ACCELERATING UNIVERSE WITH NEAR-INFRARED OBSERVATIONS OF A HIGH-REDSHIFT TYPE Ia SUPERNOVA ADAM G. RIE
Harvard - ICAP - 2002
Cooling of cesium atoms by collective emission inside an optical resonatorAdam T. Black, Hilton W. Chan, and Vladan Vuleti c Department of Physics, Stanford University, Stanford, California 94305-4060 We observe collective emission when a sample of
Harvard - ICAP - 2002
Ultracold neutral plasmasS. L. Rolston and J. L. Roberts Atomic Physics Division National Institute of Standards and Technology Gaithersburg, MD 20899-8424 Abstract Photoionization of samples of laser-cooled atoms has allowed the creation of ultraco
Harvard - ICAP - 2002
Quantum communication and memory with entangled atomic ensemblesEugene Polzik, Brian Julsgaard, Christian Schori and Jens Srensen QUANTOP - Danish National Research Foundation Center for Quantum Optics, Department of Physics and Astronomy, Universit
Harvard - ICAP - 2002
AtomMolecule Coherence Near a Feshbach Resonance in a Bose-Einstein Condensate1Sarah T. Thompson1 , Neil R. Claussen1 , Elizabeth A. Donley2 , and Carl E. Wieman1 JILA, National Institute of Standards and Technology and the University of Colorado,
Harvard - ICAP - 2002
Single molecule studies of biological processesSteven Chu Physics Department, Stanford University, Stanford CA 94305 A sampling of our recent applications of single molecule fluorescent studies to biological molecules and molecular systems is review
Harvard - AY - 45
THE ASTROPHYSICAL JOURNAL, 560 : 4971, 2001 October 10( 2001. The American Astronomical Society. All rights reserved. Printed in U.S.A.VTHE FARTHEST KNOWN SUPERNOVA : SUPPORT FOR AN ACCELERATING UNIVERSE AND A GLIMPSE OF THE EPOCH OF DECELERATIO
Harvard - ICAP - 2002
Multiple Ionization in Strong Fields1J. Ullrich1, R. Drner2, R. Moshammer1, H. Rottke3, W. Sandner3 Max-Planck-Institut fr Kernphysik, Saupfercheckweg 1, D-69117 Heidelberg 2 Insitut fr Kernphysik, August Euler Str. 6, D-60486 Frankfurt 3 Max-Born
Pratt - GCHOI - 58
Design Critique: Tompkins County Public Library vs. Brooklyn Public Library LIS-654-4:Information Technologies Date: 10/9/08 Professor: Dr. Gilok Choi Group Members: Nicole Gitau Gerritt Reeves Michael Santangelo Caitlin SeifritzIntroduction Librar
Pratt - GCHOI - 58
Open Source &amp; LINUXJackie Baer Jessica Brooks Elizabeth Hernandez Gerritt ReevesWhat is Open Source Software (OSS)? Accessibility to the source code of software Based on principles of freedom; not free as in no cost Free distribution and Collab
Pratt - GCHOI - 58
Content Management Systems CMSRachel Crowe Nicole Gitau Jill Goldstein Carrie ShauretteArticles PresentedPullman, G. and Baotong Gu. &quot;Guest Editor's Introduction: Rationalizing and Rhetoricizing Content Management&quot;. Technical Communication Quarte
Pratt - GCHOI - 58
YOURSElf OnlinE Several major Internet risksspam, spyware, and virus infectionshave declined significantly over the past few years, our new State of the Net survey has found. But Internet threats are still of great concern, according to our research
Pratt - GCHOI - 58
Content Management for the Virtual LibraryTraditional, larger libraries can rely on their physical collection, coffee shops, and study rooms as ways to entice patrons into their library. Yet virtual libraries merely have their online presence to att
Pratt - GCHOI - 58
The Semantic WebLIS - 654Amber Billey Leslie Gillette Andrew Martrich Michael SantageloSemantic Web is COMUNICATIONSemantic Web at its most fundamental level is COMMUNICATION:Most of the Webs content today is for humans to read, not for comput
Pratt - GCHOI - 58
Coumnicationsages designed for the collaborative construction and maintenance of large Web sites. Generally, they support a separation of content from presentation, thereby allowing the look and feel of a Web site to be controlled centrally while
Harvard - V - 09
Harvard Journal of Law &amp; Technology Volume 9, Number 1 Winter 1996THE END OF WORK: THE DECLINE OF THE GLOBAL LABOR FORCE AND THE DAWN OF THE POST-MARKET ERABy Jeremy RiCh. ~ New York, N.Y.: G.P. Putnam's Sons. 1995. Pp. 350. $24'.95 (hard). Many c
Harvard - V - 10
Harvard Journal of Law &amp; Technology Volume I0, Number 3 Summer 1997SCIENCE ON TmAL: THE CLASH OF MEDICAL EVIDENCE AND THE LAW IN THE BREAST IMPLANT CASEBy Marcia Angell, M.D. t New York, N.Y.: W. IV. Norton &amp; Company, Inc. 1996. Pp. 245. $2Z50 (ha
Harvard - V - 17
Harvard Journal of Law &amp; Technology Volume 17, Number 2 Spring 2004THE NAKED CLONE: HOW CLONING BANS THREATEN O UR PERSONAL R IGHTSBY JOHN CHARLES KUNICH WESTPORT, CT:P RAEGER PUBLISHERS, 2003 PP. 172. $39.95 (HARDCOVER). ISBN: 0-275-97964-4Vick
Harvard - GOV - 3009
Do virginity pledges cause virginity?: Estimating the efficacy of sexual abstinence pledges Janet Rosenbaum Abstract Objectives: To determine the efficacy of virginity pledges in delaying sexual debut for sexually inexperienced adolescents in the Nat
Pratt - SERVER - 12
Pratt eLearning SystemPELS Administration Courses EnrolmentsSite AdministrationNotificationsYou are logged in as Peter EastonBlocks editing onChoose enrolment plugin:LDAPUsers CoursesAdd/edit courses Enrolments Course request Backups
Pratt - CG - 525
PhpFlash 2.5By: Rodolfo Ruiz : www.alesys.netEnglish Version: Roberto Gutirrez Calvillo : www.softbert.comPhpFlash 2.5 is conformed by series of .php and .as files, they are granted totally free of charge (I am not responsible if this tool is use
Pratt - AFISHER - 9
&quot;Metaballs, also known as blobby objects, are a type of implicit modeling technique. We can think of a metaball as a particle surrounded by a density field, where the density attributed to the particle (its influence) decreases with distance from the
Harvard - MATH - 134
MATH 134 - SOLUTIONS TO HOMEWORK #5SAM LICHTENSTEINProblem 1 To put a nonvanishing vector eld on a Klein bottle K note that K is dieomorphic to a manifold obtained from a at rectangle by identifying the top and bottom edges (with matching orientat
Harvard - MATH - 134
Homework 3Math 134DUE: Wednesday 11th October, 2006. References: Spivak Chapter 2, Boothby Ch 3 sect 4, 5 and classnotes. For more practice questions, see the extra problem page found on the class webpage. 1. Consider the set S of points in R5 den
Harvard - MATH - 134
Final Exam Math 134Elizabeth Denne 18th December 2006INSTRUCTIONSPLEASE READ CAREFULLY! This exam consists of 11 questions. You must do all the questions. (Some questions have several parts.) The exam is out of a possible 140 points. The deadline
Harvard - HULSWEB - 1
Lab of Andrew Murray, Harvard University, June 2006 Genomic Hybridization onto Affymetrix S98 Yeast Arrays (2 day process)Reagents are kept in either 20C (*) or 4 C (*). DAY 1 1. Take arrays out of 4C; allow to reach room temperature before use. 2.
Harvard - HULSWEB - 1
Mapping Evolution: Linking Adaptive Traits to Genomic LocationLiza Gross | DOI: 10.1371/journal.pbio.0040275 Life exists in an impressive variety of forms, but the processes responsible for generating all that variation typically take far longer tha
Harvard - HULSWEB - 1
Lab of Andrew Murray, Harvard University, June 2006 Protocol for selecting random pool of segregants for mapping traits in yeast 1. Mate the two parental haploids (one expressing the trait of interest (target strain) and the other a reference strain
Harvard - HULSWEB - 1
PLoS BIOLOGYHigh-Resolution Mutation Mapping Reveals Parallel Experimental Evolution in Yeast` Ayellet V. Segre, Andrew W. Murray, Jun-Yi Leu*Department of Molecular and Cellular Biology, Harvard University, Cambridge, Massachusetts, United State
Harvard - SY - 001
Harvard Forest Schoolyard Ecology Buds, Leaves, and Global WarmingAutumn Student Data SheetDecember 2007Name: Date:_ Teacher:_School: _Tree Number:_ Branch letter _ Tree Species:__ Leaf 1 Leaf 2 Leaf 3 Leaf Length (cm.) Leaf Width(cm.) Put a c
Harvard - CS - 246
To appear in Proceedings of the 34th Annual International Symposium on Microarchitecture, December 2001Saving Energy with Architectural and Frequency Adaptations for Multimedia Applications Christopher J. Hughes, Jayanth Srinivasan, and Sarita V.