Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Give the commands for opening a MYSQL program, and then connecting to a database called my_chado. Then write an SQL query that lists the types

Give the commands for opening a MYSQL program, and then connecting to a database called my_chado. Then write an SQL query that lists the types of features in a feature table and gives the count of each. The database contains two tables: 1. feature: all of the feature types are stored in this table: the type_id column gives each different type a different numerical designation. 2. cvterm: each of the numerical types from the feature table is given a plain language name based on names in this table. Each numerical type has a unique identifier listed in a cvterm_id field. 3. The cvterm_id can be linked directly to the type_id field in the feature table.

The output must look like this example:

+- - - - - - - - - - - - - - - + - - - - - - - - - - - - +

: feature type : feature count

+- - - - - - - - - - - - - - - + - - - - - - - - - - - - +

: assembly : 1

: exon : 4200:

:gene : 4200:

: mRNA : 4200:

: polypeptide : 4200:

+- - - - - - - - - - - - - - - + - - - - - - - - - - - - +

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

Sams Teach Yourself Beginning Databases In 24 Hours

Authors: Ryan Stephens, Ron Plew

1st Edition

067232492X, 978-0672324925

More Books

Students also viewed these Databases questions

Question

4. I can tell when team members dont mean what they say.

Answered: 1 week ago