Imagine that you and your classmates are a research team developing a system based on predictive analysis to identify "at risk" students who are likely to withdraw from school because of poor academic performance rather than complete their course of studies. Prepare a brief report for your instructor addressing these questions:
a. What data do you need for each student?
b. Where might you get this data?
c. Take a first cut at designing a database for this application. Using the material in this chapter on designing a database, draw the logical structure of the relational tables for this proposed database.
In your design, include the data attributes you believe are necessary for this database and show the primary keys in your tables. Keep the size of the fields and tables as small as possible to minimize required disk drive storage space. Fill in the database tables with the sample data for demonstration purposes (10 records). After your design is complete, implement it using a relational DBMS.