Hands-On Database An IntroductIon to Database design and development 2nd

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