You are viewing our Forum Archives. To view or take place in current topics click here.
sql help with select commands
Posted:
sql help with select commandsPosted:
Status: Offline
Joined: Dec 23, 200915Year Member
Posts: 1,939
Reputation Power: 377
Status: Offline
Joined: Dec 23, 200915Year Member
Posts: 1,939
Reputation Power: 377
#2. Posted:
Status: Offline
Joined: Jan 23, 201113Year Member
Posts: 17,175
Reputation Power: 2037
Status: Offline
Joined: Jan 23, 201113Year Member
Posts: 17,175
Reputation Power: 2037
I'm assuming that you're working with some sort of DBMS here (Database Management System)
I did a bit of work with SQL last year so i may be able to help.
Are you provided with some sort of database/schema as reference?
I did a bit of work with SQL last year so i may be able to help.
Are you provided with some sort of database/schema as reference?
- 0useful
- 0not useful
#3. Posted:
Status: Offline
Joined: Dec 23, 200915Year Member
Posts: 1,939
Reputation Power: 377
Status: Offline
Joined: Dec 23, 200915Year Member
Posts: 1,939
Reputation Power: 377
#4. Posted:
Status: Offline
Joined: Aug 19, 201014Year Member
Posts: 5,243
Reputation Power: 532
Status: Offline
Joined: Aug 19, 201014Year Member
Posts: 5,243
Reputation Power: 532
By the schema, he means the names of all the different tables.
Ideally, you would have an entity-relationship diagram that will define each table and the attributes given for each one.
e.g.
Pet
- Species
- Breed
- Name
- Age
Appointment
- Date
- Vet_ID
- Job
- Pet
etc. with each table showing the relationship between other tables. (1-to-1 or 1-to-many)
Something like this:
[ Register or Signin to view external links. ]
To work out the total cost prescribed by each vet, I would create a new compound attribute that combined each unique vet with their total cost. Increment the value for each attribute depending on which vet had set the prescription.
Ideally, you would have an entity-relationship diagram that will define each table and the attributes given for each one.
e.g.
Pet
- Species
- Breed
- Name
- Age
Appointment
- Date
- Vet_ID
- Job
- Pet
etc. with each table showing the relationship between other tables. (1-to-1 or 1-to-many)
Something like this:
[ Register or Signin to view external links. ]
To work out the total cost prescribed by each vet, I would create a new compound attribute that combined each unique vet with their total cost. Increment the value for each attribute depending on which vet had set the prescription.
- 0useful
- 0not useful
You are viewing our Forum Archives. To view or take place in current topics click here.