create queries and dml commands and captures the output including sql commands output and rows retrieved

Each member creates CREAT TABLE commands and INSERT commands of assigned tables. Note that data to be inserted must be agreed in advance among members due to the consistency between PKs and FKs.

• A member collects them in one file and test them to see whether they all work fine. Then, the member shares the DDL and INSERT among members.

• Once the complete DDL and INSERT works, then members get together and decides what queries and what DML commands to create for each member. The queries should be meaningful and complex enough ones that contain at least two of the following a) multi-table joins, b) aggregate functions; c) several WHERE conditions on date or string fields, etc.

• Each member creates the whole database in each member’s account. • Each member can create their own queries and DML commands and captures the output, including SQL commands, output, and #rows retrieved.

• Each member displays all the data of assigned tables using SELECT * command. • A member collects all the SQL and DML outputs.


My team member gitHub: https://github.com/sahithip99/Multimedia/blob/master/main.sql


 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.