As a volunteer working at the Elwood Retirement Community Library, you have been asked to create a database of borrower information. Use phpMyAdmin for the following:
Create a database named ElwoodDB.
Create a table named Borrowers with the following columns:
Borrower ID
First name
Last name
Telephone number
E-mail address
Be sure to use appropriate column names and column types. In addition, ensure that no two records can have the same value for Borrower ID and enable the means to quickly search for records by e-mail address.
Take a screenshot of the table properties as shown in phpMyAdmin. Submit the screenshot embedded in a Microsoft Word document to this Submissions Area. In addition, submit your rationale for:
Specifying a particular data type for each column.
Specifying the size of data that can be entered in each column.
Selecting a column as a primary key.
Creating an index on a particular column.
Please indicate at least one issue that you came across during the database creation process and explain how you overcome the problem.
Address the review comments in your work and resubmit the screenshot of the table properties to the Submissions Area by the end of the week. Provide a rationale for any feedback that you do not incorporate.
Support your responses with examples.
Cite any sources in APA format.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|