473,701 Members | 2,628 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MS Access: a true RDBMS

Is MS Access a true RDBMS?
Jan 1 '06 #1
43 2896
What's your definition of a "true RDBMS"? I don't believe any DBMS exists
that implements all of the rules.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"sinister" <si******@nospa m.invalid> wrote in message
news:Mf******** ************@co mcast.com...
Is MS Access a true RDBMS?

Jan 1 '06 #2
Why does jello have a smell when you add the powder in the water, but
when it "gels" the scent virtually disappears?
Can an unborn baby fart or burp?
If a baseball player hits a home run over the fence, but then dies
before he can run around the bases, does the home run count?
If a General is a higher ranking officer than a Major, then why is a
major illness worse than a general illness?
Why don't they make Root Beer flavored ice cream? Wouldn't it be better
than root beer floats?
Why is there never a full English dinner or tea but there is always a
full English breakfast?
What is the point in saying "may I ask" and then follow it up with a
question?
Is it possible to be allergic to water?
When an atheist swears on a Bible before they testify in court do they
have to tell the whole truth and nothing but the truth since they don't
believe in God?
Why do cats like to dig their paws into something before they lay down
on it?
If a pack of gum says that each piece is 10 calories, is that amount
just chewing the gum, or also for swallowing it?
Why is there a little countdown (like 8, 7, 6, 5, 4) near the bottom of
the copyright info page in the beginning of many books?
Why does the Easter bunny carry eggs? Rabbits don't lay eggs.
How come only your fingers and toes get wrinkly in the shower and
nothing else does?
Isn't it weird that all year round your parents tell you not to play
with fire, but on Independence Day they hand you a package of
explosives, a lighter, and say have fun?
Are tomatoes fruits or vegetables?
How come lotion is colored, but when you put it on, it doesn't turn
your skin that color?
Doesn't a lightning rod on top of church show a lack of faith?
Are there pink lemons that make pink lemonade?
Why do we say "heads up" when we actually duck?
What's a question with no answer called?
How do "do not walk on grass" signs get there?
When a store has double doors why do they only let you use one of them?
If there was a crumb on the table and you cut it in half, would you
have two crumbs or two halves of a crumb?
"What was Captain Hook's name before he had a hook for a hand?"
Do the actors on Unsolved Mysteries ever get arrested because they look
just like the criminal they are playing?
Do bald people get dandruff?
Why doesn't baking soda freeze?
What if you were to ask a genie to grant you more than three wishes for
one of you wishes?
If you made biscuits with chocolate milk instead of regular milk, would
they taste chocolaty?
If you rented a movie and were late returning it and then you died
would someone you knew or a family member have to pay the late fee?
Can a person with no ears wear glasses?
Do the actors in the re-enactments on Americas most wanted, ever get
arrested (because they were seen on TV portraying the criminal)?
Are people who are allergic to nuts allergic to coconuts too?
If someone's peeing and halfway through they die, would they keep
pissing or stop?
How come French fries are not considered vegetables, since they are
just deep fried potatoes?
Can you still say "Put it where the sun doesn't shine" on a nude
beach?
Do Jewish vampires avoid crosses or Stars of David?
Why is it that when adults have multiple personalities it's
schizophrenia, but when a child has imaginary friends it's cute?
If you swallow a burp does it turn into a fart?
Can you put a gay man in a straight jacket?
Do they have burglar alarms at Christian bookstores?
Why do bullies always ask "what's your problem" when they're
obviously not going to solve it?
Do stairs go up or down?
When people say, "I'm so tired it's not even funny" or "my head hurts
so much it's not even funny", why would it even be funny in the first
place?
Why is there a top line on lined paper if we never use it?
Do coffins have lifetime guarantees?
Why do the numbers on phones go down while the numbers on calculators
go up?
If Hooters were to become a door-to-door service would they have to
change
their name to Knockers?
If the sky is the limit, then what is space, over the limit?
Are children who act in rated 'R' movies allowed to see them?
Can you make a candle out of your earwax?
When French people swear do they say pardon my English?
Aren't the 'good things that come to those who wait' just the leftovers
from the people that got there first?
If the swat team breaks down your door do they have to replace it
later?
Can a fire truck park in the fire lane?
Can it be cloudy and foggy at the same time?
"Cute as a button" Is that supposed to be a compliment? Since when are
buttons cute?
Can you breathe out of your nose and mouth at the same time?
Are marbles made of marble?
Why does the last piece of ice always stick to the bottom of the cup?
If you pay for a vacation and your plane crashes on the way there, do
you get you money back? (Granted you lived)
Why did Yankee Doodle name the feather in his hat Macaroni?
Who was the first person to look at a cow and say, "I think I'll
squeeze these dangly things here and drink what comes out"?
Who was the first person to say, "See that chicken over there ... I'm
gonna eat the first thing that comes out if its butt"?
Isn't Disney World just a people trap operated by a mouse?
If electricity comes from electrons, does morality come from morons?
Do illiterate people get the full effect of Alphabet soup?
Can you get cornered in a round room?
Why don't the hairs on your arms get split ends?
If an atheist has to go to court, do they make him swear on the Bible?
Why is it illegal to park in a handicapped parking space but its ok to
use a handicapped toilet?
In that song, she'll be coming around the mountain, who is she?
How come we say 'It's colder than hell outside' when isn't it
realistically always colder than hell since hell is supposed to be fire
and brimstone?
Why is it that if something says, "do not eat" on the packaging it
becomes extra tempting to eat?
Why are people so scared of mice, yet we all love Mickey Mouse?
Wouldn't it be smart to make the sticky stuff on envelopes taste like
chocolate?
Why are the commercials for cable companies on cable but not on regular
television? Don't they want the people without cable to buy the cable?
"Have you ever noticed that if you rearranged the letters in mother in
law, they come out to Woman Hitler?"
Isn't it funny how the word 'politics' is made up of the words 'poli'
meaning 'many' in Latin, and 'tics' as in 'bloodsucking creatures'?
Why is it that when things get wet they get darker, even though water
is clear??
Why is it that when you get out of a swimming pool, your urine is
hotter when you use the restroom?
Can mute people burp?
What happens if you put this side up face down while popping microwave
popcorn?
Why is chopsticks one of the easiest songs to play on the piano, but
the hardest thing to eat with?
How come you play at a recital, but recite at a play?
If a fork were made of gold would it still be considered silverware?
If heat rises, then shouldn't hell be cold?
Why is there that little space inside strawberries, as if it was meant
for a pit, and then the seeds are on the outside?
Why isn't chocolate considered a vegetable, if chocolate comes from
cocoa beans, and all beans are a vegetable?
Do they have girl's bathrooms in gay bars?
Why is toilet bowl cleaning liquid only blue?
Why is it when we talk to God we are praying, but when God talks to us
we are put into the loony bin?
Why do you go "back and forth" to town if you really must go forth
before you go back?
Why does shaped macaroni taste better than the normal kind?
Why vanilla ice cream white when vanilla extract is is brown?
Why can't you get a tan on your palms?
If your sick for one week and on one of those days they had to cancel
school because of snow, do you have to make up that day in June?
Why do dogs sniff other dog's bottoms to say hello, why don't they
just bark in their face or something?
Why do companies offer you "free gifts?" Since when has a gift NOT been
free?
If something "goes without saying," why do people still say it?
You know the expression, "Don't quit your day job?" Well what do you
say to people that work nights?

Jan 1 '06 #3
"Lyle Fairfield" <ly***********@ aim.com> wrote:

How come only your fingers and toes get wrinkly in the shower and
nothing else does?
In a really cold shower, something else does ...

If there was a crumb on the table and you cut it in half, would you
have two crumbs or two halves of a crumb?
Two crumbs, which are infiinitely divisible.

Do Jewish vampires avoid crosses or Stars of David?
Not possible. Eating people is not Kosher.

Can you make a candle out of your earwax?
I'll get back to you on this one in a week or so ...

Why is there that little space inside strawberries, as if it was meant
for a pit, and then the seeds are on the outside?


It's actually for the milk and sugar.
--
Darryl Kerkeslager
Jan 1 '06 #4
rkc
sinister wrote:
Is MS Access a true RDBMS?


Is it O.K. to use a checkbox for my answer?
Jan 1 '06 #5

"rkc" <rk*@rochester. yabba.dabba.do. rr.bomb> wrote in message
news:Dj******** ***********@twi ster.nyroc.rr.c om...
sinister wrote:
Is MS Access a true RDBMS?


Is it O.K. to use a checkbox for my answer?

You mean so that you can indicate whether it is a male rdbms or a female
rdbms?

Jan 1 '06 #6

"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:en******** ******@tk2msftn gp13.phx.gbl...
What's your definition of a "true RDBMS"? I don't believe any DBMS exists
that implements all of the rules.
Well, for one, is there a DB server that maintains the DB?
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"sinister" <si******@nospa m.invalid> wrote in message
news:Mf******** ************@co mcast.com...
Is MS Access a true RDBMS?


Jan 1 '06 #7
"sinister" <si******@nospa m.invalid> wrote in
news:7N******** ************@co mcast.com:
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in
message news:en******** ******@tk2msftn gp13.phx.gbl...
What's your definition of a "true RDBMS"? I don't believe any
DBMS exists that implements all of the rules.


Well, for one, is there a DB server that maintains the DB?


That's not part of any definition of RDBMS, which is a mathematical
concept.

Implementation is irrelevant to status as a true RDBMS.

I suspect you're just a troll, since anyone with the capability to
frame the question in this regard knows the answer to the question
of whether there's a Jet server.

<PLONK>

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jan 1 '06 #8
"Lyle Fairfield" <ly***********@ aim.com> wrote in
news:11******** **************@ g44g2000cwa.goo glegroups.com:
Why is there a little countdown (like 8, 7, 6, 5, 4) near the
bottom of the copyright info page in the beginning of many books?


I can actually answer that one. It's so that they can indicate which
printing it is. It's easier to put all the numbers on the initial
films from which the plates for printing are created (or however it
works) and then to remove one number at a time for each printing
than it would be to add in a number that wasn't there originally.

So, the original printing had:

10 9 8 7 6 5 4 3 2 1

The next one:

10 9 8 7 6 5 4 3 2

The next:

10 9 8 7 6 5 4 3

And so forth.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jan 1 '06 #9
sinister wrote:
Is MS Access a true RDBMS?


Sounds like a homework assignment. 8) ;)

The answer lies in finding (the late) E.F.COdd's rules for a truly
relational database. Google these terms.

Jet doesn't meet some of Codd's rules, but then again, there are
database theorists who claim there is NOTHING out there that fully meets
Codd's definition, though Jet misses a number of them.

But so what? There's two things to consider - is a database system
truly relational _and_ is the designer using appropriate relational
database principles?

In my mind, the latter question is by far the most important.

I've seen *lots* of Oracle database systems which many database
theorists classify as a true RDBMS (and some also claim is not, because
of their interpretation of Codd's rules) that are absolutely pathetic
imitations of anything relational. Try the infamous "Banner" financial
system for size - among other things, the absolute worst GUI I have ever
seen - I'd much rather be using something banged out by a 12 year old on
a Tandy in the early 80s. But there are lots of other examples I've
seen local Oracle developers produce. ON the same token, I've seen lots
of Jet applications which are quite faithful to principles of relational
design.

So your homework question is moot. 8)

Please be honest and include my full name in your bibliography if you
decide to use any of the above in your assignment - I'll just pop in my
work sig followed by my usual newsgroup sig, thanks. ;)

Tim Marshall 709 737-2662
Manager, Work Control
Facilities Management, Memorial University
St John's, NL, Canada
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Jan 1 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
6260
by: Arijit Chatterjee | last post by:
I heard that MS Access is not at all a RDBMS.But why? Only the security feature in Access is low.We can't create multiple logins or... Other than that everything is available.So why not a RDBMS.Please explain me. Regards Arijit Chatterjee
2
1482
by: Steven | last post by:
A dump question: for project using access as front-end and RDBMS server (such as sqlsvr) as backend, do we create db in backend first before linking front-end with, or vice versa? Any comment is appreciated.
0
8736
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
8649
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9229
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9083
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8977
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
5904
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4410
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4662
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2035
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.