You have been asked to help design a database that stores information about individuals. It is stipulated that e all individuals in this system are United States citizens e all individuals in this system have valid United States passports e all individuals in this system have a valid Social Security Number e all individuals in this system have a valid state issued identification from some state The system gathers the following information about each individual. What is provided below is the description of the information, and a one-character abbreviation that is used for that piece of information US Passport Number Date of Birth Social Security Number State issued identification number (like driver's license) The state that issued this identification The individual's address The individual's Twitter name The individual's email address The individual's Instagram name The individual's Facebook name This information is stored in a relational database table R (S, U, L, F, A, T, E, D, I, P). You have been told that an individual is uniquely identified by any one of the following their US Passport Number (P), or their Social Security Number (S) AND Date of Birth (D), or their state issued identification number (L) AND the state that issued this identity (U) nt additional information- read carefull You have been informed that the individual's address is a residential address which includes the state in which the person lives; and this is identical to the state that issued the state issued identification number. (Put differently, if you know the address, you know the state that issued the 'state issued identification number') Not all users have Twitter, email, or Instagram, or Facebook names. If the user does not have one of those names, the field will be NULL. However, if they exist, twitter names, email addresses, Instagram, and Facebook names are unique 1. 2. You have been asked to help design a database that stores information about individuals. It is stipulated that e all individuals in this system are United States citizens e all individuals in this system have valid United States passports e all individuals in this system have a valid Social Security Number e all individuals in this system have a valid state issued identification from some state The system gathers the following information about each individual. What is provided below is the description of the information, and a one-character abbreviation that is used for that piece of information US Passport Number Date of Birth Social Security Number State issued identification number (like driver's license) The state that issued this identification The individual's address The individual's Twitter name The individual's email address The individual's Instagram name The individual's Facebook name This information is stored in a relational database table R (S, U, L, F, A, T, E, D, I, P). You have been told that an individual is uniquely identified by any one of the following their US Passport Number (P), or their Social Security Number (S) AND Date of Birth (D), or their state issued identification number (L) AND the state that issued this identity (U) nt additional information- read carefull You have been informed that the individual's address is a residential address which includes the state in which the person lives; and this is identical to the state that issued the state issued identification number. (Put differently, if you know the address, you know the state that issued the 'state issued identification number') Not all users have Twitter, email, or Instagram, or Facebook names. If the user does not have one of those names, the field will be NULL. However, if they exist, twitter names, email addresses, Instagram, and Facebook names are unique 1. 2
