chapter 1: Who Needs a database
narrative Sharon, a student at a community college, applies to become a tutor for
database-related subjects at the school. She discovers they use spiral notebooks and
spreadsheets to manage the tutoring information. She suggests to the supervisor that
they could benefit from a database and offers to build it. The supervisor agrees to the
project. Sharon interviews her and gets a sense of what the overall database will entail
and drafts a statement of scope. She and the supervisor discuss the statement and make
some modifications.
outcomes
• Define relational databases
• Understand the position of relational databases in the history of databases
• Identify major relational database management systems
• Identify main characteristics of relational databases
• Understand SQL’s role in relational database
• Recognize some indications of where a database could be useful
• Define a statement of scope for a given database scenario
chapter 2: Gathering information
narrative Now that she has the scope of the database, Sharon begins to gather information about the data the database will need to capture and process. First, she looks at the
spiral notebooks that have been used to schedule tutoring sessions. She also looks at
the spreadsheets the supervisor develops for reports and other related documents.
Then she arranges an interview with several of the tutors and an additional interview
with the supervisor, and creates a questionnaire for students who use the tutoring
services. Finally, she spends an afternoon in the computer lab, observing how students
schedule tutoring and how the actual tutoring sessions go.
outcomes
• Review documents to discover relevant entities and attributes for database
• Prepare interview questions and follow up
• Prepare questionnaires
• Observe work flow for process and exceptions
xiv Preface
chapter 3: requirements and business rules
narrative Having gathered all this information, Sharon must figure out what to do
2021-11-25 18:49:50
16.05MB
数据库开发
1