Created
September 25, 2016 12:24
-
-
Save ntjn/6894669eeb10fbaf8c3b1cb5275a2905 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
group: bank example | |
description[[ the data for this dataset was generated using <http://www.generatedata.com/> | |
* the relation _Customers_ contains basic information about the customers of the bank. | |
* the relation _Accounts_ contains the basic information of a single account. Note that a customer can have any number of accounts. | |
* the relation _PremiumCustomers_ contains the customer-ids of all customers with a total balance over 1000 | |
]] | |
Customers = { cid firstname lastname | |
1 Dexter Simpson | |
2 Kaseem Gallagher | |
3 Kuame Hamilton | |
4 Robert Thompson | |
5 Rhiannon Valentine | |
6 Calvin Mays | |
} | |
Accounts = { | |
aid, cid, balance:number | |
1, 1, 66 | |
2, 1, -304 | |
3, 2, 272 | |
4, 3, 3472 | |
5, 4, 975.7 | |
6, 4, 93 | |
7, 5, 534 | |
8, 5, -75.5 | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment