General DB Help Needed

:eek: I am not going to lie, I am taking a DB course and am finding it extremely difficult to understand. :o

We are doing Relational DB & ER modeling as well as table normalization.

I only have 1 hour to take an upcoming and know I will score poor on my own.

Anyone want to help me out with my quiz?

I can post the Q's here.

Thanks muchyou can post the questions here,
whether you will get sensible accurate and correct answers is another thing.
you may get entirely correct answers, but not neccessarily the answers you or you teacher require.

have you read and understood the references (rudy [r937.com]) has a good section by paul litwin

if you must post your questions, then I'd suggest you also post your answers so that you can make an attempt to understand where your areas of weaknesss are.

however I wouldn't hold your breath....|||If you post the questions and your answers, we may give you some good tips and critiques.

If you post just the questions and expect us to help you cheat, well, then the fun begins...|||Here is an example of some of the questions. They are multiple choice.

The final outcome of a natural JOIN yields a table that provides only the copies of the unmatched pairs.

True or False. I said False

Functional dependence can be defined most easily as the attribute A is functionally dependent on B if A determines B.
True or Flase. I said False

In the context of a database table, the statement "A determines B" indicates that:
1) knowing the value of Attribute A, you can look up the value of attribute B
2) knowing the value of Attribute B, you can look up the value of attribute A
I choose 1.

Attributes ar types of entities. True or False. I said False

(_______) expresses the specific number of entity occurrences associated with an occurrence of a related entity.
1. Cardinality
2. Optionality
3. Mandatory
4. Unary

Consider a schema R = (A, B, C, D, E).
and the following set F of functional dependencies:
A->BC
CD->E
B->D
E->A

Is CD a superkey?
Is AB a candidate key?
Is E->B in F+?
Is the following decompostion R1 = (A, B, C) and R2 = (C, D, E) a lossless-join decomposition?
Is the following decompostion R1 = (A, B, C) and R2 = (A, D, E) a lossless-join decomposition?

Thanks

This stuff seems like anything but basic to me|||Well, I'll tell you that the ones you answered appear to be correct.

The ones you did not answer appear to simply require an understanding of the terms mentioned.

Google and your textbook are your friends.

"lossless-join decomposition"? I don't know what the heck that is.|||Thanks. Yeah and those are just a sample of the questions. The book could be written in Chinese as far as my understanding of it goes. The basic terms and definitions are easy it it the graphical interpretations and relationship information I just can't seem to get.|||The book could be written in Chinese as far as my understanding of it goes.Really? Is our vernacular nomenclature that recondite?|||If by 'our' you mean DB people, then, yes your terminology can be difficult to understand at times. I was not meaning that towards you or anyone on this board, but rather to the author text I am reading.|||So does anyone want to seriously help me out?|||So does anyone want to seriously help me out?I guess that I assumed that Blindman already had helped you out... What more did you want?

-PatP|||That was my assumption too....|||What I posted was an example of some questions.
I was asking if I posted some similar questions (don't have them yet) if anyone was familiar enough with the material to offer some help.|||It is rather unlikely that we'll be able to help in the one-hour timeframe of your exam. Most of us have jobs and only offer to help here on a "time available" basis.

You seem to have a good understanding of the topics that you've mentioned, and while you might be a bit put-off by the presentation (or lack thereof) of the material from your class, you also seem to have a good command of what you've taken the time to read.

I really don't think you need someone to be "on deck". A little bit of time spent covering the material should be all that you need. If you have questions about points in the material, I'm sure that we'd be glad to help explain or conjour examples, but I don't really think that you'll even need that.

-PatP|||Short answer: No.|||Thanks, I will post up if I get stuck.|||[Fake and derogatory quote made up by tjm deleted]

huh? what the f is that about?|||This thread has been censored and copied back to the SQL Server forums for its humor value. The thread is now closed.