Like SSADM....

[suarve]

Hi,

Can someone recommend a program that is has all the functionality of SSADM, but is more use friendly.

Thanks

 

[Inquisitor]

SSADM isn't a program, it's a way of designing information systems

 

[suarve]

Well technically yes. But is there anything out there that is a tad more user friendly. I like all the features but it looks like something from windows 95

EDIT: see what you mean, its actually called "SELECT SSADM Pro". doh!

 

[Burnsy2023]

What does the program do exactly?

Burnsy

 

[whitecrook]

I have used it many moons ago, and it is quite specialised. MS Visio may do what you're wanting, but there is other software out there.

 

[suarve]

What does the program do exactly?

Burnsy

its a CASE tool mate.

 

[suarve]

I have used it many moons ago, and it is quite specialised. MS Visio may do what you're wanting, but there is other software out there.

Not too keen on Visio tbh. I need to create an ERM (showing entities, attributes, relationships etc) and then be able to generate some SQL stuff from it.

 

[whitecrook]

Visio will do that. The newest ones will.

 

[suarve]

Cheers.

Also while I'm in the mood i have another question

I'm designing a database for a rental shop and all is going fine so far. However, i have hit a wall at the minute. How can i restrict each member (each member has a member_id) to renting a maximum numbers of products (each product has a product_id). Can someone point me in the right direction?

Thanks

 

[whitecrook]

have a field for each customer table called 'currently_renting' (or something) This value get's 1 added when they rent a book, and one subtracted when a book comes back.

The total of this will be how many books are out by customer, and if a rental query goes ahead, then it must be only if 'currently_renting' < 4....

Just an idea

 

[suarve]

have a field for each customer table called 'currently_renting' (or something) This value get's 1 added when they rent a book, and one subtracted when a book comes back.

The total of this will be how many books are out by customer, and if a rental query goes ahead, then it must be only if 'currently_renting' < 4....

Just an idea

Good idea. I could do that in Access easily, but I'm using Oracle for the first time and imagine that would be a harder - as I'm currently finding most things in Oracle

 

[suarve]

Actually would i add some sort off constraint if doing your idea in Oracle?

 

[suarve]

"have a field for each customer table called 'currently_renting' (or something) This value get's 1 added when they rent a book, and one subtracted when a book comes back.

The total of this will be how many books are out by customer, and if a rental query goes ahead, then it must be only if 'currently_renting' < 4....

Just an idea"

Have been thinking how to pull that off Oracle for the last two days, but am at a loss. Can anyone help/point me in the right direction???

Thanks

 

[Eriedor]

Personally I would have table that details all rentals. rental_id, video_id, cust_id, date_out, date_in.

Select * FROM tblrentals WHERE cust_id = 'customersid' AND date_in = NULL

Will tell you how many rentals a customer has taken out. If > 3 no rental.

 

[davestar_delux]

Enterprise Architect is an alright program for Sys Dev stuff.

 

[AS_Platinum]

Personally I would have table that details all rentals. rental_id, video_id, cust_id, date_out, date_in.

Select * FROM tblrentals WHERE cust_id = 'customersid' AND date_in = NULL

Will tell you how many rentals a customer has taken out. If > 3 no rental.

Thats how I would do it too.

 

[suarve]

Personally I would have table that details all rentals. rental_id, video_id, cust_id, date_out, date_in.

Select * FROM tblrentals WHERE cust_id = 'customersid' AND date_in = NULL

Will tell you how many rentals a customer has taken out. If > 3 no rental.

Thats miles better than what i was thinking. Twas trying to make it more complicated than it needs to be. Cheers all.

Hehe, I have the same table structure too

 

[whitecrook]

yes thats' a better. I am database n00b.