Project You will create a database and host it either locally from your own machine or online as a server. You will then fill that database with relevant data for your project. Finally you will build a software interface/client that connects to the database and retrieves and presents (and/or updates) the data is some novel way. You may leverage a software client that you have already build or are building for another course. However, your term project needs to be of sufficient complexity to be approved. It should beat least as complex as a CINF201 project. Ideally, it will utilize some of the concepts from this course,such as SQL, JSON files, Excel reports, etc. Group projects are not allowed in order to ensure you challenge yourself sufficiently. (a) Contract Agreement Your instructor must sign off on your proposed project before you can begin working on it! Please complete the contract at the end of this document and email it directly to your instructor. Once all functionality is agreed upon, your instructor will sign and email it back to you. Once signed by both parties, commit and push this contract to your project repository. If needed, note that various programs can open and edit PDF files, including: Microsoft Word, Google Drive, and many free online editors. If necessary, you can also screenshot, print, type / hand write, scan / capture the contract to edit it. Only the contract portion of this document is required to be filled out and returned. (b) Minimum Requirements Your term project program must include: • Something you are interested in doing personally, professionally, or academically • The use of a database system (RDBMS or NoSQL) • A software interface/client that communicates w/ the database to retrieve information • Data that is loaded to the database ONLY ONCE either before or the first time the application starts up. And then successive runs of the application connects to the existing database and uses it. Thus, the database must persist after the application is shut down and it cannot be reloaded each time the application runs • Complexity greater than that of a CSCI142 term project (c) Presentation A presentation is required for you to present your work. It will give you public speaking experience and highlight your accomplishments. All presentations will be held virtually online. Make sure you can share your screen over Zoom (practice if necessary). Given the number of students, you will be limited to 5-10 minutes of speaking time. Please speak quickly; do not present slides; do not show your code (we simply do not have enough time). Instead, run your program, demo all functionality, and talk about it. Cover these points: • Interact with the software client and tell us what works and what doesn’t work when communicating with your database • Show us some view of the data outside the application, for example show us your database in MySQL Workbench or phpMyAdmin or view into a NoSQL database from an online server Project [(c) Presentation] continued on next page. . . Page 2 of 4 • Show us the code queries that are passed to the database system when retrieving or modifying data. Project Ideas The goal of this project is to demonstrate that you understand how to create a database, fill it with data, and use it... however... the best projects come from developers who have an inherent interest or intrinsic motivation in completing them. Therefore, you are required to propose your own project idea to ensure you will be interested in it. Think of something (anything!) that you enjoy or have an interest in: hobby, topic, concept, idea, anime, dream, wish, career goal, curiosity, story, rumor, game, tool, phrase, activism, etc., and then propose your term project program around that. It can also be something you could leverage, such as a tool. Here are some generic examples of sufficiently complex programs. Do not propose these exact projects. They are simply examples of complexity. Propose one of your own project ideas with similaror more complexity. • A database-backed collection of some type of objects (e.g. students, clients, events, TODO tasks, inventory, reviews, destinations, etc.) readable and modifiable from a software client • A database-backed tool that can help or compliment some industry / process / game (e.g. traveling, shopping, cooking, exercise, retail, building, study, analytics, measurements and scientific and or engineering calculations, mass conversions, tax preparation, complex scientific calculator, etc.) • A database-backed system / tool that helps with some sort of philanthropy (e.g. pollution, climate change, animal rescue, adoption, navigation of resources, self reporting, scholarship, etc.) • A database for a software project you are developing now in another course • etc. (there are an infinite set of possibilities) Submission You will first email your proposed term project contract to your instructor by the contract due date. Once signed off on, you may begin developing your project immediately. You are encouraged to work onit as much as possible, including during class times during the month of April, up until the due date on this assignment and Canvas. After that date, you may called upon any time to present. Rubric Task General attempt at completing your project Minimum requirements implemented Presentation professionalism and thoroughness Total Percentage 50% 40% 10% 100% Page 3 of 4 Contract DEVELOPER name (printed clearly): DEVELOPER agrees to create a database, fill it with relevant data, integrate it into a software project, and then present it with the following functionality for the Term Project in this course. The database can be stored in an RDBMS and queried with SQL, or it can leverage online NoSQL database technology. Database technology that will be used (RDBMS w/ SQL, Mongo, Firebase, Dynamo, Redis): Proposed project functionality and software application: DEVELOPER signature: Instructor signature: Date: Page 4 of 4
Purchase answer to see full attachment