{"id":9,"date":"2025-02-28T16:31:15","date_gmt":"2025-03-01T00:31:15","guid":{"rendered":"https:\/\/community.cob.sjsu.edu\/jonathanlau\/points\/sql-project-proddna\/"},"modified":"2025-02-28T16:31:15","modified_gmt":"2025-03-01T00:31:15","slug":"sql-project-proddna","status":"publish","type":"points","link":"https:\/\/community.cob.sjsu.edu\/jonathanlau\/points\/sql-project-proddna\/","title":{"rendered":"SQL Project &#8211; ProdDNA"},"content":{"rendered":"<p>In this project, I collaborated with four other members on a database project for ProdDNA, designing and implementing a functional database from an ERD draft in Google Docs to MySQL Workbench. The goal was to create a database capable of handling queries and providing valuable business insights. The result was a functional database that demonstrated solving an issue in the real world and\u00a0 SQL capabilities. My team and I presented our work in an interview-style format, explaining our design process, key findings, and the impact of our queries. Through this project, I strengthened my skills in database design and SQL and saw how SQL impacts the real world. In addition, I\u00a0 also improved my teamwork, communication, and presentation abilities.<\/p>\n<p>URL: https:\/\/www.canva.com\/design\/DAGYQ8ROuRU\/TlDrMd-f7RpOShUe-u8XvQ\/edit?utm_content=DAGYQ8ROuRU&amp;utm_campaign=designshare&amp;utm_medium=link2&amp;utm_source=sharebutton<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"author":2550,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-9","points","type-points","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/community.cob.sjsu.edu\/jonathanlau\/wp-json\/wp\/v2\/points\/9","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.cob.sjsu.edu\/jonathanlau\/wp-json\/wp\/v2\/points"}],"about":[{"href":"https:\/\/community.cob.sjsu.edu\/jonathanlau\/wp-json\/wp\/v2\/types\/points"}],"author":[{"embeddable":true,"href":"https:\/\/community.cob.sjsu.edu\/jonathanlau\/wp-json\/wp\/v2\/users\/2550"}],"replies":[{"embeddable":true,"href":"https:\/\/community.cob.sjsu.edu\/jonathanlau\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":0,"href":"https:\/\/community.cob.sjsu.edu\/jonathanlau\/wp-json\/wp\/v2\/points\/9\/revisions"}],"wp:attachment":[{"href":"https:\/\/community.cob.sjsu.edu\/jonathanlau\/wp-json\/wp\/v2\/media?parent=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}