Recent content by silviadana

Yes, but I asked only for help to understand how it works,and I think the best way to learn is when somebody is telling you were you are wrong. We were told that is recommended to reduce relationships (associations) to binary (not ternary or higher) And I can't figure out how to do this when...

I need help with Conceptual Data Model for Hotel Reservation. Yes, I looked at databaseanswer but my problem is not the same. My problem sounds like this The hotel reservation company wishes to realize a system for managing hotel bookings. After hotel affiliation, it will be registered in the...

thanks a lot.

I have problems with subquerys, in fact I don't know how to avoid using the same condition in the query and subquery. For example, i have the table cars(Carnumber,DateofAcquisition) I need to find out in which of the last five years were purchased the most cars?? SELECT...

I would give myself an answer. If you know another methods please post them For the first problem Select top 1 s.[telephone_number] + 1 from telephone as s where not exists (Select 1 from telephone as s2 where s2.[telephone_number]= s.[telephone_number]+ 1) For the second one SELECT...

I think you have to format the result you want format(expresion,"hh:mm")

Hello I need help with two problems in Access. I believe that they are similar but I don't know how it works I problem: I have a table TELEPHONE(telephone_number) where telephone number is the only field. I have to find the first number that is missing For example: suppose that I have the...