This is Database question

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 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