Interview & Questions

The first thing you need to do when creating a database in Access is to look for a problem or select one that you would like to make easier , for example, we chose a problem and named it  Music Collection DataBase, we are going to start with the recollection of data , then we'll organized it, make an E/R Diagram in DIA  format, go to access, create the tables according to each entity with their corresponding attributes.Elaborate forms and queries based on the relationship between tables and at last we will take care of its interfaces. Below are a series of question we used to elaborate on our Database.

Questions Asked:

1. What is your name?
2. How many CDs do you have in your music collection?
3. What's your problem?
4. How do you want them to be arrange?
5. Do you want it private? If so, should we include your ID?
6. What's your ID?
7. If not, who are the members that can access it? Password?
8. What background do you want?
9. Any favorite colors?
10. Should we include images?
11. Do you have a preference of font style and size?
12. What are your favorite CDs?
13. Do you have a preference in the order of the arrangement?
14. Will you like to have links to the videos of each song?
15. Do you have in mind buying more CDs?
16. Will you like to be able to enter their data on the database?
17. When do you want this project to be done?
18. Would you like to enter data of your digital music too?
19. Should we include all your CDs to be in the system?
20. If not, which ones should we include?
21. Do you want information about the singers and songwriters?
22. Any other comments?