1. Engineering
  2. Computer Science
  3. 1 consider the following database table that stores data about...

Question: 1 consider the following database table that stores data about...

Question details

1) Consider the following database table that stores data about the University faculty.

SSN

name

Contact_Info

101-00-1234

Smith, Paul

Dodds 205, x124

290-89-9276

Jones, Mary

Echlin 319, x228

110-20-3762

McCarthy, Joseph

Charger 102, x291

  1. a. Redesign the table, correcting any mistakes you see.
  2. b. From the fields provided, which field(s) would be the most appropriate primary key?
  3. 2.  Consider the following table that stores SNP (Single Nucleotide Polymorphism) data. For this example, you may assume that at a given genomic position, there can be only one variant entry. rsNumbers uniquely identify known SNPs, but not every SNP detected is known.

    From the fields provided, which field(s) would be appropriate as a primary key?

    chromosome

    position

    rsNbr

    ref_allele

    alt_allele

    1

    6935788

    rs149879

    A

    T

    2

    12478020

    rs1002

    A

    C

    2

    23001345

    G

    T

    4

    1902200

    rs87290

    C

    A

3. In your reading you learned about a file-based approach that predated relational databases, where different data sets were maintained in different files. Sadly, this still occurs. Consider the following two “files” that were created by independent groups and create a database table that could store the data from both files. Add or choose an appropriate field(s) to be the primary key (and identify it).

file #1 (Computer Science students)           file #2 (Biology Students)
student name                                                 last name
student email                                                 first name
student advisor                                             phone number
student date of birth                                     campus address

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution