Skip to main content

ER diagram

1. Prepare an E-R diagram for a real estate firm that lists property for sale. The following describes the organization:
• The firm has a number of sales offices in several states.
• Each sales office is assigned one or more employees. An employee must be assigned to only one sales office.
• For each sales office, there is always one employee assigned to manage that office. An employee may manage only one sales office to which he/she is assigned.
• The firm (sales office) lists property for sale.
• Each unit of property must be listed with one (and only one) of the sales offices. A sales office may have any number of properties listed, or may have no properties listed.
• Each unit of property has one or more owners. An owner may have one or more units of property.

Comments

Post a Comment

Popular posts from this blog

FOR MY BLOG READER'S

It is not for me but for my readers. 'One' resolution fROM taday: I want to look like Aamir khan (without 8 packs) Bike or Car (and why): Car, I’ve three reasons for it 1. It’s safer than bike 2. I’ve always dreamt of going on a long drive with my soul-mate in a car. 3. While driving a car you can look into the eyes of.......... obviously you can guess?? J A chance to fly or a chance to be invisible (and why): Invisible, I suffer from Acrophobia (an extreme or irrational fear of heights). I would love to love: My parents, they deserve my love more than anyone in this world. Most recent Dream I had: I’m a kid again. Teacher in the school asks to describe a word and I was struggling L If I were to marry today, I would: If the girl is pretty, I would be delighted. If the girl is not so ..., I wouldn’t marry and convince everybody that I’m underage (I’m actually 20 years old). My Dream Girl is/would be: SHEEEE Best F...
3 comments
Read more

100+ Sweet Things to Say to Your Girlfriend

Sweet Things to Say to Your Girlfriend : You know what is the basic reason of splitting up of many couples? It does not happen because they do not love each other enough now, but it happens because they forget to show their love to each other. In a relationship, mostly girls demand some attention and affection from their partners. And all you guys can give it to them with the help of sweet things to say to your girlfriend. Don’t let your ego ever comes between you two. Love has more power than any other thing in the world. Use this power to overcome all the problems in your relationship. These sweet things to say to your girlfriend are nothing when you are not feeling them. These are not just the lines but the feelings you hold in your heart for her but could not display all this while. 100+ Sweet Things to Say to Your Girlfriend To help you more on this, I have compiled a list comprising of more than 100 sweet things to say to your girlfriend. These are simpl...
1 comment
Read more

Interview Question for 3-6 Year experience in .Net Technologies-PART -I

Hai Friends, With lot of encouragement and support, I am posting the Part II of the questions and answers for 3-6 years experienced people. These questions will be helpful for those who are preparing for the interview or attending the interviews. This will be helpful for the last minute preparation in quickest way. If anyone has better answer, please reply to this post and I will include them. C# / ASP.net/ .Net framework / other .Net related questions: 1. What is the difference between IEnumerable and IQueryable? Ans.  IEnumerable and IQueryable are used to query data from  collections and  database.  The IEnumerable is basically inherited from IQueryable, so it’s having all the features of the IQueryable in addition to its having additional own features. S.No IEnumerable IQueryable 1. Exists in System.Collections Namespace Exists in System.Linq Namespace 2. Can move to forward only in the collection. Can move to forward, backward or in betwe...
Post a Comment
Read more