PROJECT_CODE PROJECT_CODEPROJECT_MANAGER PROJECT_CODEMANAGER_PHONE PROJECT_CODEMANAGER_ADDRESS PROJECT_CODEPROJECT_BID_PRICE 21-5Z Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 16833460.00 25-2D Janet D. Grant 615-898-9909 218 Clark Blvd., Nashville, TN 36362 12500000.00 25-5A George F. Dorts 615-227-1245 124 River Dr., Franklin, TN 29185 32512420.00 25-9T Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 21563234.00 27-4Q George F. Dorts 615-227-1245 124 River Dr., Franklin, TN 29185 10314545.00 29-2D Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 25559999.00 31-7P William K. Moor 904-445-2719 216 Morton Rd., Stetson, FL 30155 56850000.00 Figure P1.1 How many records does the file contain? How many fields are there per record? What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure? If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure? What data redundancies do you detect? How could those redundancies lead to anomalies?

Code for the following: Web application is written using the MVC (Model, View, Controller) architecture Web application is written using object-oriented PHP programming, including classes for: Database Connection & Information Products table model Products table DB Products table controller Categories table model Categories table DB Categories table controller Web application includes 3 user interface pages: Index/landing/navigation page Title: "Your Name Wk 3 GP" Page Header: Your Name Product Information Includes navigation links to all other pages Filename index.php Database Connection Status page Title: "Your Name Wk 3 GP" Page Header: Your Name Database Status Includes: Text display of the database name Text display of the database user ID Text display of the database password Text display of the status of the connection (successful or unsuccessful) Navigation link to the home page Filename db_conn_status.php Products page (and Product Add/Update page) Title: "Your Name Wk 3…

Q3: Jami is an intern on a sales team at a large insurance company. On the first day of the internship, Jami is asked to download a list of all of her friends and contacts from Facebook and upload them to the company database. The team lead explains "This database keeps track of all of our employees, and well as their customers and prospects. This makes it really easy to avoid redundant customer interactions, and also keeps us from cannibalizing customers and business from one another." Jami is wondering if there are ethical issues she should be concerned about. Do you think there are ethical issues involved with this situation? If yes- what are those issues, specifically, and how would you advise Jami?