My apologies. One of the applications is a casino ban form that will
be shared among seven casino sites. It has to use a browser UI and I
have MS SQL 2005 Enterprise as the backend database.
I suppose my biggest problem with that is establi****ng the necessary
security so that only certain users can create and update bans and
other users can only view the bans and perform searches using criteria
available on the ban form. The criteria would be items such as the
date of the ban, casino location, type of ban, etc.
The other application is a little too complex to explain in one
posting and I do not plan to start on it until I finish the ban form.
Unfortunately, there is no DBA or senior developer here. The
combination of those two positions is what I am being migrated toward.
I know that there is a lot to learn but I will gradually get to where
I can create professional databases.
On Mon, 30 Jun 2008 05:29:52 -0700 (PDT), Ed Prochak
<edprochak@[EMAIL PROTECTED]
> wrote:
>On Jun 28, 8:51 pm, "news.usenetserver.com" <charle...@[EMAIL PROTECTED]
> wrote:
>> My boss has decided that I should be moved toward more
>> development-oriented job functions. For about ten years I have
performed
>> system administration work but lately I have been performing IT
technician
>> duties. My initial migration toward development work involves creating
>> two applications that will have SQL databases containing data that will
be
>> shared among seven geographically-separated sites. I have been given
the
>> requirement that these databases be accessible through web-based submit
>> and receive forms.
>>
>> Does anyone have some suggestions about good resources that could help
>> guide me in designing the structure of the databases?
>>
>> --
>> Using Opera's revolutionary e-mail client:http://www.opera.com/mail/
>
>You say nothing about the requirements for the applications, so we
>cannot comment about the database design specifically.
>
> I would suggest that you learn data modeling. Take a course or two at
>your community college on databases. Or find a senior developer at
>your company to mentor you. Also, talk to the DBA about your database
>design. Try to learn both the practical aspects of the DBMS you are
>using and the theory of Relational databases.
>
>HTH,
> ed
|
