database
3
Interview Documentation
Objective of Interview:
To determine the data that will be maintained in the school system
Interview Date: 09/24/2017.
Interview Location: city, state
Start Time of the Interview: 1:30 pm
End Time of the Interview: 2:30 pm
Customer Participant(s): first Last .
Project Team Participant(s): first last
Interview Questions
Close-Ended Questions
1. Is the data you suggested during the first interview sufficient? Yes No
2. Do you have a limit to the amount of data to be stored in the database? Yes No
Open-Ended Questions
1. What data should be maintained in the database?
Students’ details, Parents’ details, Test scores, Fees details
2. f these data do you want included in the database?
Data Data Characteristics
Student Name, age, gender, class, parent’s name, Account number, cell phone, address, email, birthdate, ID number
Parents Name, Child’s name.
Teacher Name, Subjects they teach
Sports Types, students, trainer, awards.
3. Are the designers of this database free to add additional data they deem appropriate?
Yes they are so long as any board member reviews the data before launching of the database.
Data Characteristics
Student: Name, Gender, age, parent, Cellphone, Email, classes, grade.
Parent Name: Child, cellphone, Email, occupation, marital status.
Teacher, Name, subjects, cellphone, Email.
Sports: Types, students, trainer, awards.
Health: Diseases, blood type, medication, special needs.
References
Harrington, J. L. (2009). Relational Database Design and Implementation. 3rd Ed. Amsterdam : Morgan Kaufmann. Retrieved from
http://vlib.excelsior.edu/login
Eriksson, U. (2012). How to use interviews to gather requirements. Retrieved from:
http://reqtest.com/requirements-blog/how-to-use-interviews-to-gather-requirements/
Creating the School Sample Database (2010). Microsoft. Retrieved from:
https://msdn.microsoft.com/en-us/library/bb399731(v=vs.100).aspx