Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an ER diagram that captures the information below. A gene is described by a chromosome number, an organism, a name, a start position in

Draw an ER diagram that captures the information below.

A gene is described by a chromosome number, an organism, a name, a start position in the chromosome, and an end position

A gene is composed of one or more exons and zero or more introns.

An exon has a start position, a stop position, and a number in the gene sequence (1 means first exon, etc.).

An intron has a start position, a stop position, and a number in the gene sequence.

Each intron and each exon belongs to exactly one gene.

Each gene has zero or more associated transcription promoter elements.

A promoter element has a name and a type (examples: TATA box, transcription factor binding site).

Each promoter stored will be associated with at least one gene.

Experiments are run to test gene activity.

Each experiment involves one or more genes and is run by one student using one of several protocols. The lab, date, and gene activity are recorded with each experiment.

Each student has an id number and a name.

Each protocol has a set of experimental conditions (this could be a text file listing the conditions).

Not all protocols are necessarily used and some will be used repeatedly.

Students can run more than one experiment. Some students will not run any experiments.

No two experiments are the same on the same day

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Describe Table Structures in RDMSs.

Answered: 1 week ago