Brief description: This schema describes the various transgenic plant lines in a laboratory collection. Each transgenic line is denoted by a Genotype object, which tells which Species the plant belongs to, which Plasmid was used to create the transgenic line, and which Seed_stocks are available for that line. Each Experiment object documents the Seed_stocks produced, as well as the person (Author) who did the work. Publications for each Author can also be included. IMPORTANT: Each class in the schema is an abstraction. It is NOT an example of an object. Thus, it would be incorrect to for the schema to show the Seed_stock class with specific values in each field: Seed_stock AM312.Westar43 Experiment AM312 Line Westar Container Box12 The above is an object, not a class. |
Type |
Description |
Examples |
Tag |
The name for a data field, to
be shown in the display. Tags can not contain blanks. |
Common_name |
Text |
short free text, often one word
but never more than a single line. |
oilseed rape |
LongText |
Intended for use in long
comments or descriptions |
The library was sent by surface mail and
therfore spent several days at room temperature. Some
decrease in titre may have occurred. |
Int |
positive or negative integer |
17 -123 0 |
Float |
A real number in floating-point
notation |
0.58 1.2e+09 |
UNIQUE |
an enumerated choice; This
means that the data field can only be set to one of a small
list of choices |
Linear Circular |
Date |
date and time |
04-12-10 04-12 04 04-12-10_13:23:00 04-12_18:00 NOW TODAY |
pointer to a Class |
pointer to an object of another
class. A class name can not contain blanks. Pointers work
like hypertext links. |
pBI121 |
File type |
Model/Object |
Text |
Pick_me_to_call Text Text Pick_me_to_call $ACE_FILE_LAUNCHER $ACEDB/externalFiles/exp75.txt |
Graphic image |
Pick_me_to_call Text Text Pick_me_to_call $ACE_FILE_LAUNCHER $ACEDB/externalFiles/pBR322.gif |
PDF |
Pick_me_to_call Text Text Pick_me_to_call $ACE_FILE_LAUNCHER $ACEDB/externalFiles/plasmidprotocol.pdf |
HTML (external) |
Pick_me_to_call Text Text Pick_me_to_call $ACE_FILE_LAUNCHER http://www.ncbi.nlm.nih.gov/projects/genome/guide/cow |
First, spend some time just thinking
about how the data related to your topic is
structured. What are the most important things that
you want to represent as objects? What are the
relationships between objects in your data? After you
have a pretty good understanding of your data, then
decide how you will represent those things in your
schema. What is NOT acceptable for a database topic:
|