Database Design Research Paper

1450 Words6 Pages
Axia College Material Appendix B IT/260 Database Design Document [This project is design to care for Contact Information, calls made and receive, details of callers and messages left by callers, planned meeting and follow-ups on calls etc] Prepared By: [] Date Modified: [] Week: [] Part 1: Introduction (due Week Two) a) Application Summary [Provide in a couple of sentences a brief summary of the application you selected in the Week One assignment. The application selected in week 1 was Contact Management. This application is going to be designed to care for numerous contacts information for all clients and employees alike, and their personal data.]…show more content…
An ERD stand for Entity Relationship Diagrams and it means a process by witch in a database, entities or objects, attributes, and relationships when properly designed an provide a meaningful graphical representation that users can understand. As we have defined ERD, we see the importance of this tool, some of which is the visual representation it provides; it also presents a snapshot of data structure. b) Entity Relationship Diagram [Take a screen shot of the Relationships tool in Microsoft® Access® once you have created the tables and established the necessary relationships. Paste the screenshot here in this document.] A screenshot of my relationship tool: Print screen is not working with…show more content…
- I will need a separate form to input employment related information to the Employment Information table. - A main and child form will be created to have display the following: * Main Form: this, form displays basic contact information while each contact is linked to a child form (displaying history of contacts by the current individual displayed in the main form) * Child form is linked Call Information - A separate form will be required for storing Contact Information to the table. - There may be a menu option showing New contacts, top 5 or top 10 contacts, Menu to Add new contact to the table, menu to delete contacts, menu to save current contact especially after an update is made to the tables. Part 5: Testing and Implementation Plan (due Week Seven) a) Testing
Open Document