db-flywithsigma

Database Final Project (2110322)

Members

1. Mr. Khanapong Kamchoom (Mark)
2. Mr. Chatrin Yoonchalard (Chat)
3. Miss Chanatda Konchom (Fai)
4. Mr. Chayaphon Kultanon (Parm)
5. Mr. Chayut Archamongkol (Faith)
6. Miss Yada Vasinonta (Fah)
7. Miss Nantaporn Phuaphanbun (Fei)
8. Mr. Punyapat Kijvorachai (Mew)
9. Mr. Suvijak Jintanaphan (Nice)

Project Structure

\er-diagram

\exec-path

• Code for comparing each query.

\flysigma-csv

• Mock data via .csv file.

\indexing

• Created indices
• Provided mock test for indexing.

\init-code

• Provide copy .csv data instruction into your database.
• DRAFT of DDL command.

\insert-delete-update

• Given example codes for INSERT, DELETE and UPDATE.

\MongoDB

• Code for using in MOngoDB
• CAUTION ! some data in this code might be changed from being use in localhost. This might be effected on some queries.

\stored-function

• Code for creating & testing stored function

\stored-proc

• Code for creating & testing stored procedures

\trigger-function

• Code for creating & testing trigger function

FYI: report-flysigma.pdf is our final report of this porject