Project and Presentations 2 and 3
Please design your own database. You may propose an application or you may (as I have suggested) design a database that will help you learn more about what alumni of Cornell College have done professionally after earning their degree at Cornell College.
If you choose the database of alumni, look for data on LinkedIn or other sources on the Web. You might want to create at the least tables to hold descriptions of alumni, their employers, and the graduate and professional schools at which our alumni have studied. In your description of alumni, you might want to include information about their involvement in athletic programs, the arts, or student organizations. You might want to look for professional credentials other than degrees or examples of leadership and service in volunteer organizations. You might want to classify employers by industry or size. Be imaginative.
Present a report on your project to us this week (the third week of the term). Present another report on your project to us next week (the fourth week of the term).
Show your design in more than one way. You might choose to show us:
- an entity-relationship diagram
- UML diagrams
- SQL statements that create and populate the tables in your database
- SQL statements that query your database
- JSON, XML, or CSV files that contain data for your database
- Python functions that access the data in your database
A simple design that is presented well is better than a more ambitious coding effort that does not allow enough time for an edited, rehearsed, and clear presentation.