Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help with some work

Author  Topic 

Catsmilk
Starting Member

4 Posts

Posted - 2009-08-06 : 11:22:29
not sure if this is the right forum, basically this is what i have to do and am unsure how to create the appointment making part

An optician’s business keeps contact details (name, date of birth, address, phone number, email) of its customers. It also keeps
an online list of appointments, showing which customer is due to see the optician, the reason for the appointment, the time and
duration of the appointment. The system must be able to allow staff to make new appointments, cancel appointments, show a
list of the appointments for any given day or week.

im unsure of what exactly i need, and how to do it

thanks for any help

Catsmilk
Starting Member

4 Posts

Posted - 2009-08-06 : 11:23:37
quote:
Originally posted by Catsmilk

not sure if this is the right forum, basically this is what i have to do and am unsure how to create the appointment making part

Construct a web-based application to provide a system for the following scenario. The system must be based on HTML with
Java servlets and a database (Postgres or MySQL).

An optician’s business keeps contact details (name, date of birth, address, phone number, email) of its customers. It also keeps
an online list of appointments, showing which customer is due to see the optician, the reason for the appointment, the time and
duration of the appointment. The system must be able to allow staff to make new appointments, cancel appointments, show a
list of the appointments for any given day or week.

im unsure of what exactly i need, and how to do it

thanks for any help

Go to Top of Page

rohitkumar
Constraint Violating Yak Guru

472 Posts

Posted - 2009-08-06 : 11:30:15
and what's your role here? are you the doctor?
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-08-06 : 11:32:35
quote:
Postgres or MySQL

You are in the wrong forum. This forum is for Microsoft SQL Server


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

rohitkumar
Constraint Violating Yak Guru

472 Posts

Posted - 2009-08-06 : 11:33:13
quote:
Originally posted by rohitkumar

and what's your role here? are you the doctor?



have you looked at Google Calendar yet?

http://www.google.com/calendar/
Go to Top of Page

Catsmilk
Starting Member

4 Posts

Posted - 2009-08-06 : 11:42:42
sorry ill try looking for another forum

any you would recommend?

the role is just to make the site, i am not the doctor/optician
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-08-06 : 11:50:40
What is your role in the organisation?

You need a front end application. This kind of job would normally be completed by a developer in whatever language you have decided to choose to use.

As far as storing the information, you will need a database, whether this would be SQL Server or not would again be up to the companys IT strategy and whoever deals with this.

There are loads of sites on the internet, but it is dificult to tell you which ones to try without knowing which technologies you are intending to use.
Go to Top of Page

Catsmilk
Starting Member

4 Posts

Posted - 2009-08-06 : 11:52:35
i just need to do this as basic as possible and in the easiest way possible

i was using netbeans to make the database but am stuck

thanks
Go to Top of Page
   

- Advertisement -