 | | From: | HeshamEbrahimi | | Subject: | Merging users' views | | Date: | 19 Jan 2005 02:50:50 -0800 |
|
|
 | Hi
This semester I got database course, our lecturer thinks merging users'
views are very important, but unfortunately didn't teach this subject
carefully. I took a look at some database books but they didn't have
this subject and also google couldn't help me.
Do you know how can I learn this subject?
And do you think this subject(merging users' views method) is important
for a B.Sc. student(software engineering)?
Cheers,
Hesham
|
|
| | From: | HeshamEbrahimi | | Subject: | Re: Merging users' views | | Date: | 19 Jan 2005 07:45:57 -0800 |
|
|
| No,
I'm sorry, I didn't write a complete example. Let me write an exact
example:
1st user view)
Purchase Order Master (is a table)
----------------------------------
| Order#(key) | Supplier# | Supplier Name | Supplier Address | Delivery
Date | Order Date | Total |
Above table has one to many relation to below table (de facto 1st user
has this view):
Purchase Order Detail (is a table)
--------------------------------
| Part# | Part Name | Quantity ordered | Price |
2nd user view)
Parts In Stock (is a table)
---------------------
| Part# | Part Name | Quantity on hand |
Above table has one to many relation to below table (de facto 2nd user
has this view):
Order In Detail (is a table)
---------------------
| Order# | supplier Name | Quantity Ordered | Order Date | Delivery
Date |
|
|
| | From: | HeshamEbrahimi | | Subject: | Re: Merging users' views | | Date: | 19 Jan 2005 07:13:41 -0800 |
|
|
| I'm not sure about its name, Merging users' views, perhaps combining
users' views is correct.
Anyway I think an example clarifies.
1st user view (A,B,C and D are fields):
A(key) B C D
2nd user view (J,B,E and F are fields):
J(key) B E F
Now we want to design a relational database. How we can design a
database that satisfy all users. In this example we had 2 users but our
lecturer give us an example with 7 user views, and didn't solve it.
Cheers,
Hesham
|
|
| | From: | Ethan T | | Subject: | Re: Merging users' views | | Date: | Wed, 19 Jan 2005 10:22:30 -0500 |
|
|
| HeshamEbrahimi wrote:
> I'm not sure about its name, Merging users' views, perhaps combining
> users' views is correct.
> Anyway I think an example clarifies.
>
> 1st user view (A,B,C and D are fields):
> A(key) B C D
> 2nd user view (J,B,E and F are fields):
> J(key) B E F
That sounds like a JOIN of some sort - do some google research on SQL JOINs.
--
eth'nT
|
|
| | From: | Jerry Gitomer | | Subject: | Re: Merging users' views | | Date: | Wed, 19 Jan 2005 13:56:09 GMT |
|
|
| HeshamEbrahimi wrote:
> Hi
> This semester I got database course, our lecturer thinks merging users'
> views are very important, but unfortunately didn't teach this subject
> carefully. I took a look at some database books but they didn't have
> this subject and also google couldn't help me.
> Do you know how can I learn this subject?
> And do you think this subject(merging users' views method) is important
> for a B.Sc. student(software engineering)?
>
> Cheers,
> Hesham
>
Please clarify what you mean by "Merging user views". I suspect
that the reason you can't find the subject in either data base
books or with Google is that you misunderstood what your
instructor was trying to say.
|
|
