You have been assigned to a group and your job is to develop a relational database that can store, manipulate and report on student information for an average-sized school. (Whether it is elementary, middle school or high school is your choice.) This information will include primarily demographics and ITBS scores (NPR). You are creating a tool for teachers and administrators to use to identify how well students are achieving (by class and/or grade level) and where they need remediation to improve their outcome.
Let's begin by identifying the requirements for your final database:
Database Requirements: Your database must be able to store, manipulate and provide the following information:
You need to go through this development process using the same thought processes that you have used for your Personal and Expanded Personal Databases.
Begin by answering these questions as a group. You might want to do this as a group using a wiki that Dr. Z has created for you. Go to http://zeitz.wikispaces.com (look in left column.)
Define the Problem: Begin by identifying the problems that you are trying to solve through creating your database. BE SPECIFIC!!! Identify SPECIFIC questions that you want to answer using your database. Identify the SPECIFIC reports that you will need to generate to answer your questions.
Identify the Tables and Fields: What tables and fields will be needed to answer your questions?
Coordinate Your Tables and Fields: Develop your one-to-many relationships. How will this all fit together?
Define Your Forms: Having identified your fields and relationships, you must now define the forms that you will need to make this database accessible and productive. Remember that forms are used for entering information as well as displaying information.
Identify Your Queries: What queries need to be created to answer the questions? Don't know which questions your teachers and administrators will be asking? Can you make the queries customizable to allow for varied input?
Structure Your Reports: What reports need to be provided to answer the questions?
While these are not requirements, they are suggestions for how you might enhance your databases to increase the ease of the interface, their accessibility, and maybe even a graphic representation of the data.