Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started