Database Systems Project in Tallahassee, Florida: Building Web-based Information System

1 / 14

Embed Share

"Join a team of 1-4 students to design a relational database for a real-world application accessible over the web. Milestones include group formation, detailed application description, development plan, and final demo. Choose a realistic project topic, have fun, and aim for usefulness. Explore project ideas from academics, entertainment, productivity, healthcare, and social media sectors."

bass_ane Follow

Uploaded on Apr 04, 2025 | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.

Download Presentation

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.

E N D

Presentation Transcript

COP4710 Database Systems Project Overview Tallahassee, Florida Tallahassee, Florida

Building a Database-driven, Web-based Information System Project page: https://www.cs.fsu.edu/~zhao/cop4710/project.html Team work A group of 1 to 4 students (but no more) Goal: Identify an application domain that requires a relational database Is accessible over the web (via SQL APIs) Design the database & define application functionalities Implement Demo & report Milestone in 4 stages 1

Multi-stage Task Stage 1: Group formation (group member info) Stage 2: A detailed description of your real-world application and the Entity-Relationship diagram Stage 3: Development plan and relation definitions Stage 4: Demo and final report Every stage has deliverables and must be approved by TAs to proceed to the next stage 2

Grading Project : 30 points You can choose to do a simpler project (25 points) without Web programming and interfaces, with 5 points deduction Stage 1: 0% Stage 2: 15% A one- or two-page report with the ER diagram of your application, plus descriptions and assumptions you make Stage 3: 15% A one- or two-page report for development plan with schema definitions Stage 4: 70% Final demo (55%) 4- to 8-page report (15%) 3

How to choose a good project topic? Your application must be useful Will there be people using your application? Why should they use your application? Your application must be realistic Your data are supposed to be real Where do you get your data? Amount of data in database must be reasonable Tens or hundreds of tuples in each table You should have fun Find an application you like to do and have fun with it Remember that your application could be the next startup! 4

Some Interesting Project Idea Academics: Course material search, project partner search , Entertainment: Book recommendation, music/playlist sharing, fantasy football analysis, . Productivity systems: Task management, human resource management, Healthcare: Physician recommendation, medical record maintenance, Social Media: Facebook/Twitter mashup , What is your crazy idea? 5

Project Requirements At least THREE entities and THREE relationships Basic functions: 1. Insert records to the database 2. Search the database and print returned results Must demo several interesting queries SELECT-FROM-WHERE-GROUPBY-HAVING Aggregate queries At least one query must involve join of multiple tables 3. Show how to update records 4. Show how to delete records 6

Project Requirements Advanced Functions: Should be relevant and useful for your application Don t exist or aren t efficiently supported in equivalent web sites/applications Go beyond the basic functions Should be technically challenging Examples: Creative use of Google Map or multiple social media Data analytics using data mining or machine learning NOT: User-friendly interface or I code the site with AJAX 7

How to Do Programming Pick one of your favorite relational databases MySQL/MariaDB PostgreSQL SQLite3, DuckDB Oracle, DB2, MS SQL Server Pick one of your favorite programming languages PHP, Python Java, C# Ruby, Perl, Rust C/C++ Platform LAMP (XAMPP, AMPPS)/Python Flask 8

Project Tips Read Project page on the course website to get started Start early! Form groups now! Unexpected issues Have a questions? All programming related questions should be routed to our TA, Ashwati Nair (nair@cs.fsu.edu) Academic integrity Work closely with your group-mate, copy/plagiarism among groups are prohibited If you consult open-source projects on the Web, cite them properly in your project 9

Sample Projects 1. Ultimate Dining http://www.youtube.com/watch?v=L_Wp_Y5yKoM 2. Social Cal http://www.youtube.com/watch?v=0-E35guOuNw 3. Global Energy http://www.youtube.com/watch?v=CimxRS7Bpsg 10

How to Implement a Web-based DB App? Access the web app Example: Chrome, Firefox, Edge, Interface Client Renders information, generates webpages Example: HTML, DHTML, XML, Javascript, CSS, Flash Presentation Internet Manage data access, performs calculations, makes logical decisions Example: PHP, Python, Java, C/C++, Ruby, Logic Server Stores and manages data Example: MySQL, Oracle Data 11