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