I am Greg Smith, a Sr. Systems Analyst, a Sr. Software Engineer. I have designed,
amended, and programed large in-house data bases on corporate and government IBM
mainframes for over 10 years. I have designed and updated data bases through
the internet since 2003.
A few of my web sites
|
|
My first web site
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
To provide a service or access data on line, you need an on-line database. If you
want your people "in the field" to have access to current data, you need an
on-line database. If you want your clients(?) to be able to work from home, to
be able to update something where ever they are, away from the office, you need
an on-line database. You are not talking about hireing a web designer, you are
talking about a Sr. Systems Analyst who, can also design a web site to display
and access it. That is what I do. I have Designed databases that other
programming 'houses' thought was not possilbe. It has been my profession for
years. I am the Sr. Systems Analyst who can design the database you need, and
put it on a site that is functional and make the data access be logical - easy to
work with. Give me a
call. Ask for Greg.
|
Search Engine Optimization
Part 1
A. good ranking excludes keyword spamming of the search engine
B. ranking results change week-to-week due to competition,
so maintaining a top ranking site requires constant keywords
monitoring and information rework. Search Engine Optimization
never rests, much like your competition.
C. Google's emphasis is on content and link popularity:
the popularity of the sites that link to your site,
the text in and around the links that point to your site, and
the popularity of the sites that you link to.
D. other links are of minimal importance - or in the case of spam
they can even be a penalty
NorthWind Corp. Accounting Database
July 1996 to Wed.eve. 5-6-1998
demo
the 7 days before today in 1997
The 7 Orders Shipped from 1997-06-26 up to 1997-07-03
| Order ID |
in order by Ship Date |
Ship Co. Name |
# of Prod's sold |
# of Items sold |
$Sale |
# of Prod's < $20 |
# of Prod's $20-40 |
# of Prod's >= $40 |
|
10545
|
1997-06-26
|
Lazy K Kountry Store
|
1
|
10
|
$ 221.92
|
0
|
1
|
0
|
|
10575
|
1997-06-30
|
Morgenstern Gesundkost
|
4
|
58
|
$ 2,274.74
|
1
|
1
|
2
|
|
10577
|
1997-06-30
|
Trail's Head Gourmet Provisioners
|
3
|
48
|
$ 594.41
|
3
|
0
|
0
|
|
10574
|
1997-06-30
|
Trail's Head Gourmet Provisioners
|
4
|
32
|
$ 801.90
|
2
|
1
|
1
|
|
10576
|
1997-06-30
|
Tortuga Restaurante
|
3
|
51
|
$ 857.01
|
3
|
0
|
0
|
|
10580
|
1997-07-01
|
Ottilies Käseladen
|
3
|
54
|
$ 1,089.63
|
1
|
2
|
0
|
|
10581
|
1997-07-02
|
Familia Arquibaldo
|
1
|
50
|
$ 313.01
|
1
|
0
|
0
|
|
Click on an Order ID to see it's details
|
Total:
|
$ 6,152.62
|
|
Each line of data above comes from 3 files (tables):
the orders file, the order-details file,
and the customer file. There are also files of
employees, products, suppliers, shippers, and more.
|
|
Welcome to
Fort Lauderdale
|
|
The safest web sites are viewed
best with trusted browsers
(not Internet Explorer)
|
Web surfing is not safe with Internet Explorer
PWSDB, C/O
Greg Smith, Pompano Beach, FLorida 33062
|