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.
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.