Created ER model in draw.io including all entities, attributes, and relationship
Group member(s): Toan Cao and Grigoriy Filkov
Part 2 – EER Model and Physical Database Design
Tasks completed:
Made EER model that extended from ER model
Converted EER model to physical database design following 9-step process
Group member(s): Nhan Cao, Joshua Parisien, Grigoriy Filkov, and Toan Cao
Part 3 – Normalization of Tables, SQL, and Website
Tasks completed:
Filled in tables with at least four rows of data and added normalized tables to phpMyAdmin
Normalized tables to 3NF and in SQL using phpMyAdmin
Created a SQL file with all commands used in phpMyAdmin
Used Notepad++/BBEdit to create a website using HTML/ CSS/JavaScript for users to access our database
Group member(s): Nhan Cao, Toan Cao, and Grigoriy Filkov
Part 4 – Final Project
Tasks completed:
Created a login/registration system with different permissions for the administrator, registered user,
guest, etc…
Added two pages to allow users to create records in the database (Add a record to Order table and Product
table)
Added two pages to allow users to view specific records in the database (View the Customer table and
Restaurant table)
Added two pages to allow users to update records in the database (Update the Registration table and Product
table)
Added two pages to allow users to delete specific records in the database (Delete the Restaurant table and
Product table)
Added two pages to show two tables joined together in the database (Join the Customer table with Customer
Address table and Product table with the ProductName table)
Included a page to allow users to upload multimedia to the database
Included a page to allow users to view multimedia from the database
Group member(s): Nhan Cao, Joshua Parisien, Grigoriy Filkov, Stuart Simpson,and Toan Cao
Project Document and Presentation
Tasks completed:
Wrote the project description, project reason and conclusion.
Created the cover page and table of contents
Created a SQL file with all commands used in phpMyAdmin
Added entities and attributes to the report
Updated the report accordingly in the document and presentation
Group member(s): Nhan Cao, Toan Cao, Stuart Simpson, Joshua Parisien, and Grigoriy Filkov