Burnies' Planning Page for Final DB Project:


This is anothertool for connecting

This is the next time that I am showing the wiki


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. This is really cool.

We need to track student test scores (NPR) for reading, math, science over a three year time span. Our students are currently in 5th and 6th grade at Burnies Elementary . Specific questions of information we need to track are: Does gender affect test scores? Does ethnicity and SES affect test scores? Who needs remediation? What is the difference in test scores within the grade level by teacher? What does student improvment look like over the three years? Reports that need to be generated. Total number of students who perform at/below the 40th percentile acording to thier SES. Total number of students who perform at/above the 80th percentile acording to their SES.

Identify the Tables and Fields: What tables and fields will be needed to answer your questions?

Possible Tables: Demographic Information:StudentNo, StudentID, ClassID, Name, Address, City, State, Zip, Phone, ContactName, ContactNo, Gender, Ethnicity, SES. ITBS Scores Reading: RecordNo, StudentID, R1, R2, R3. ITBS Scores Math: RecordNo, StudentID, M1, M2, M3. ITBS Scores Science: RecordNo, StudentID, S1, S2, S3.

Coordinate Your Tables and Fields: Develop your one-to-many relationships. How willl this all fit together?

Our Demographics Table has a one-to-many relationship from the StudentID (one) field to the StudentID field (many) in Math Table, Reading Table, and Science Table. See Attached.

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.
Our Demographics Form contains the following fields: Student ID, Name, Address, City, Zip, State, Phone, Contact Name, Contact No., Gender, SES, and Ethnicity. The Gender, SES, and Ethnicity fields are drop down menus, so it's easy to choose different options for those categories. We also created three other forms, Math Entry Form, Reading Entry Form, and Science Entry Form. These entry forms contain the same fields so we can enter and compare data based on the each test's results for each grade level. The fields used in the Math Entry Form are: RecordNo., StudentID, M4, M5, and M6. The fields used in the Reading Entry Form are: RecordNo., StudentID, R4, R5, and R6. The fields used in the Science Entry Form are: RecordNo., StudentID, S4, S5, and S6.


Identifying Your Queries: What queries neeed to be created to answer the questions? Don't know which questions your teachers and asministrators will be asking? Can you make the queries customizable to allow for varied input? A query that identifies students math test scores by gender 5th graders over a three year time period. A query that identifies reading scores by ethnicity and SES. A query that identifies 5th grade students who fall below the 40th percentile in science. A query that identifies 5th grade students who perform at or above the 80th percentile in science.


Structure Your Reports: What reports need to be provided to answer the questions?
Reports that need to be generated. Total number of students who perform at/below the 40th percentile acording to thier SES. Total number of students who perform at/above the 80th percentile acording to their SES.