Homework Soursecreate ten details examples of quries from this data I used
create ten details examples of quries from this data ... I used MySQL..
insert into `Ledger` (`LedgerKey`, `LedgerBookName`)
values (1000000000, \'quarter one\');
insert into `Ledger` (`LedgerKey`, `LedgerBookName`)
values (1000000001, \'quarter two\');
insert into `Ledger` (`LedgerKey`, `LedgerBookName`)
values (1000000002, \'quarter three\');
insert into `Ledger` (`LedgerKey`, `LedgerBookName`)
values (1000000003, \'quarter four\');
insert into `Organization` (`OrganizationKey`,`CostCenterName`,`CostCenterNumber`,`DepartmentName`,`DepartmentNumber`,`DivisionName`,`BusinessUnitName`,`CompanyName`)
values (1234567890,\'water\',1111111111,\'HR\',0000000000,\'dayton\',\'developing\',\'P&G\');
insert into `Organization` (`OrganizationKey`,`CostCenterName`,`CostCenterNumber`,`DepartmentName`,`DepartmentNumber`,`DivisionName`,`BusinessUnitName`,`CompanyName`)
values (1234567891,\'gas\',1111111112,\'IT\',0000000001,\'vandalia\',\'computer science\',\'UD\');
insert into `Organization` (`OrganizationKey`,`CostCenterName`,`CostCenterNumber`,`DepartmentName`,`DepartmentNumber`,`DivisionName`,`BusinessUnitName`,`CompanyName`)
values (1234567892,\'electricity\',1111111113,\'hiring\',0000000003,\'kettering\',\'developing\',\'GE\');
insert into `Organization` (`OrganizationKey`,`CostCenterName`,`CostCenterNumber`,`DepartmentName`,`DepartmentNumber`,`DivisionName`,`BusinessUnitName`,`CompanyName`)
values (1234567894,\'water\',1111111111,\'HR\',0000000000,\'beavercreek\',\'developing\',\'P&G\');
insert into `Account` (`AccountKey`,`AccountName`,`AccountCategory`,`AccountType`)
values (1111111111,\'Michael Jordan\', \'development\', \'credit\');
insert into `Account` (`AccountKey`,`AccountName`,`AccountCategory`,`AccountType`)
values (1111111112,\'Justin George\', \'internet cost\', \'credit\');
insert into `Account` (`AccountKey`,`AccountName`,`AccountCategory`,`AccountType`)
values (1111111113,\'Carson Mary\', \'investment\', \'debt\');
insert into `Account` (`AccountKey`,`AccountName`,`AccountCategory`,`AccountType`)
values (1111111114,\'Linda Jackson\', \'saving\', \'debit\');
insert into `Account` (`AccountKey`,`AccountName`,`AccountCategory`,`AccountType`)
values (1111111110,\'John Larry\', \'investment\', \'credit\');
insert into `AccountingPeriod` (`AccountingPeriodKey`, `AccountingPeriodNumber`, `AccountingPeriodDescription`, `AccountingPeriodFiscalYear`,`AccountDimension_AccountKey`)
values (1111111111,1111111111,\'for investment\',\'2014\',1111111111);
insert into `AccountingPeriod` (`AccountingPeriodKey`, `AccountingPeriodNumber`, `AccountingPeriodDescription`, `AccountingPeriodFiscalYear`,`AccountDimension_AccountKey`)
values (1111111112,1111111112,\'for technology development\',\'2014\',1111111112);
insert into `AccountingPeriod` (`AccountingPeriodKey`, `AccountingPeriodNumber`, `AccountingPeriodDescription`, `AccountingPeriodFiscalYear`,`AccountDimension_AccountKey`)
values (1111111113,1111111113,\'employee salary\',\'2013\',1111111113);
insert into `AccountingPeriod` (`AccountingPeriodKey`, `AccountingPeriodNumber`, `AccountingPeriodDescription`, `AccountingPeriodFiscalYear`,`AccountDimension_AccountKey`)
values (1111111114,1111111114,\'paying last period debt\',\'2014\',1111111115);
insert into `AccountingPeriod` (`AccountingPeriodKey`, `AccountingPeriodNumber`, `AccountingPeriodDescription`, `AccountingPeriodFiscalYear`,`AccountDimension_AccountKey`)
values (1111111115,1111111115,\'for investment\',\'2013\',1111111111);
insert into `MONTHDim` (`monthKey`)
value (\'2013-04-05\');
insert into `MONTHDim` (`monthKey`)
value (\'2013-04-06\');
insert into `MONTHDim` (`monthKey`)
value (\'2013-06-19\');
insert into `MONTHDim` (`monthKey`)
value (\'2012-09-09\');
insert into `MONTHDim` (`monthKey`)
value (\'2014-10-12\');
insert into `MONTHDim` (`monthKey`)
value (\'2015-12-11\');
insert into `COMMITMENT` (`commitmentKey`,`commitmentDescription`,`commitmentParty`)
values (0000000000,\'$9000000\',\'GE\');
insert into `COMMITMENT` (`commitmentKey`,`commitmentDescription`,`commitmentParty`)
values (0000000001,\'$150000\',\'GMC\');
insert into `COMMITMENT` (`commitmentKey`,`commitmentDescription`,`commitmentParty`)
values (0000000003,\'$60000\',\'UD\');
insert into `COMMITMENT` (`commitmentKey`,`commitmentDescription`,`commitmentParty`)
values (0000000004,\'$1000000000\',\'P&G\');
insert into `BUDGET` (`budgetKey`,`budgetName`,`budgetVision`,`budgetApprovalDate`)
values (1111111111, \'maintenance\',\'enough budget for maintenance in lobby\', \'2014-09-11\');
insert into `BUDGET` (`budgetKey`,`budgetName`,`budgetVision`,`budgetApprovalDate`)
values (1111111112, \'technologe development\',\'budget for the next period\', \'2013-11-22\');
insert into `BUDGET` (`budgetKey`,`budgetName`,`budgetVision`,`budgetApprovalDate`)
values (1111111114, \'salary\',\'paycheck for the parttime emloyees\', \'2015-01-01\');
insert into `BUDGET` (`budgetKey`,`budgetName`,`budgetVision`,`budgetApprovalDate`)
values (1111111116, \'investment\',\'investment in stock\', \'2014-09-20\');
insert into `BUDGET` (`budgetKey`,`budgetName`,`budgetVision`,`budgetApprovalDate`)
values (1111111133, \'maintenance\',\'maintenance fee for computers\', \'2013-09-18\');
insert into `PAYMENT` (`paymentKey`,`paymentDescription`,`paymentParty`)
values (9999999999,\'dividends\',\'all stockholders\');
insert into `PAYMENT` (`paymentKey`,`paymentDescription`,`paymentParty`)
values (9999999996,\'catering fee\',\'catering company\');
insert into `PAYMENT` (`paymentKey`,`paymentDescription`,`paymentParty`)
values (9999999994,\'computer hardware\',\'comupter hardware suppliers\');
insert into `PAYMENT` (`paymentKey`,`paymentDescription`,`paymentParty`)
values (9999999997,\'payment of electricity\',\'electricity power company\');
insert into `PAYMENT` (`paymentKey`,`paymentDescription`,`paymentParty`)
values (9999999988,\'payment of utility\',\'utility company\');
Solution
select * from Ledger
select * from Organization
select * from Account
select * from AccountingPeriod
select * from MONTHDim
select * from BUDGET
select * from PAYMENT
select paymentKey,paymentParty where paymentDescription=\"payment of utility\"
select budgetKey,budgetName,budgetVision where budgetKey >=1111111112
select commitmentKey,commitmentDescription where commitmentParty=\"GMC\"
