Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are
spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the
password reset link.
Entire forum
➜ MUSHclient
➜ Lua
➜ PSQL random data
It is now over 60 days since the last post. This thread is closed.
Refresh page
| Posted by
| Kevnuke
USA (145 posts) Bio
|
| Date
| Tue 13 Nov 2018 08:26 AM (UTC) |
| Message
| I wasn't sure if this was the place to ask this but here goes.
I'm doing a project for my database class where we are creating a database for a fake business. My partner and I are doing a clothing store and need to fill our database with potentially hundreds of fake records for tables such as in-store sales, online orders, customers, employee schedules and clock-ins and clock-outs, etc. We're allowed to either write a program to generate this data or use websites that will do it for us. I'm just having trouble finding one that generates anything but customer records.
We're trying to make it just smart enough that it would only use an employee that's actually working according to the schedule to ring up a customer, or process an online order, for example.
I can upload what we have so far if it'll make understanding what we're trying to do easier, or I could list the relations and their attributes. We're still trying to get PostgreSQL (psql) to create the database itself, and then create the tables representing each Relation. Any help would be appreciated. | | Top |
|
| Posted by
| Fiendish
USA (2,533 posts) Bio
Global Moderator |
| Date
| Reply #1 on Tue 13 Nov 2018 08:06 PM (UTC) |
| Message
| | Generating reliable test data is always a pain. It's very easy to miss uncommon scenarios. I suppose if you list the relations and their attributes, I/we could offer some guidance. Though, since it's for a class project, I don't know how much implementation I'd actually share because that seems like it would be defeating some of the purpose of the project. |
https://github.com/fiendish/aardwolfclientpackage | | Top |
|
The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).
To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.
8,547 views.
It is now over 60 days since the last post. This thread is closed.
Refresh page
![[Go to top]](/images/gototop.gif)
top