EECS 484: P1 - FakeBook Database

Languages & Tools Used: SQL*Plus

• Designed and implemented a comprehensive ER diagram for Fakebook, a Facebook clone, encompassing key entities such as users, messages, photos, events, and more, to provide a clear and efficient data structure.
• Developed a robust database schema in SQL*Plus, defining tables for users, cities, friendships, messages, events, photos, and user education, ensuring data integrity and scalability for the application.
• Automated the population of the database by creating a script to insert user data from a public database, integrating additional details like education and cities, resulting in a seamless migration of external data.
• Replicated the structure of the public database by crafting SQL views to mirror the original schema using custom tables, improving the data retrieval process and ensuring consistency across platforms.