Database general questions:

Cell phones are great. But what happens if your phone gets dropped in water or gets stolen. You could use all of your contacts. Yes, there are apps out there to store your contacts, but if you build your own database of contacts, you can access the data from your phone or you can store it on the cloud and get it from anywhere, even if your phone is not working. Your task is to plan a database which contains a contact list. For each person, business, or other contact you will need to keep a name, an address, including city, state and zip code. You should have a place for up to three phone numbers (cell, business, and land-line), although you may not need to use any of the three spaces in the database. Also a column for e-mail address might be useful. A separate table containing codes and their descriptions would be useful. For example Code"F, Description "Friend," or "B""Business Associate." "R""Relative," and "BF" Business associate that is also a friend. Task: 1. Plan what your database table will look like. 2. What will you name the tables? a_ 3. List the columns and data type for each column in each table (you may not need all the space below.). Table a: Primary key Data Type: Name Name Name Name Data Type Data Type Data Type Data Type Data Type: Data Type Data Type Name Name 4. How will the tables be related? (what columns will be used to connect the 2 tables) 5. Write SQL statements that will do the following: a. Show all the contacts' names and their cell phone numbers, but nothing else b. Show all of the names and the code and code descriptions a. Show all of the names and cell phone numbers, where the code is "F