|
Home > Archive > microsoft.public.cert.mcdba > June 2002 > 70-229 Question??
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Thomas Mundt 2002-06-23, 6:15 am |
| Hi,
i´m preparing for the 70-229 Exam.
Who can explane me why answer C and E for this question should be the right
one?
1. You are designing a database that will contain
customer orders. Customers will be able to order
multiple products each time they place an order. You
review the database design, which is show below:
Customers Orders Products
CustomerID OrderID ProductID
CompanyName ProductID Description
Address OrderDate UnitPrice
City Quantity
State CustomerID
You want to promote quick response times for queries
and minimize redundant data. What should you do? (Each
correct answer presents part of the solution. Choose
two)
A. Create a new order table named OrdersDetail. Add
OrderID, ProductID, and Quantity columns to this
table.
B. Create a composite PRIMARY KEY constraint on the
OrderID and ProductID columns of the Orders table
C. Remove the ProductID and Quantity columns from the
Orders table
D. Create a UNIQUE constraint on the OrderID column of
the Orders table.
E. Move the UnitPrice column from the Products table
to the Orders table.
Ans: CE
| |
| Danut Prisacaru 2002-06-23, 6:15 am |
| I would say A and a kind of E meaning that you move the UnitPrice column
from the Products table to the OrderDetail table. Let's call it F
You do A to normalize the database and you do F because the price for the
same product can change for different orders.
Danut
"Thomas Mundt" <lux_mundt@t-online.de> wrote in message
news:aarkc4$14p$06$1@news.t-online.com...
> Hi,
>
> i´m preparing for the 70-229 Exam.
> Who can explane me why answer C and E for this question should be the
right
> one?
>
>
> 1. You are designing a database that will contain
> customer orders. Customers will be able to order
> multiple products each time they place an order. You
> review the database design, which is show below:
>
> Customers Orders Products
> CustomerID OrderID ProductID
> CompanyName ProductID Description
> Address OrderDate UnitPrice
> City Quantity
> State CustomerID
>
> You want to promote quick response times for queries
> and minimize redundant data. What should you do? (Each
> correct answer presents part of the solution. Choose
> two)
>
> A. Create a new order table named OrdersDetail. Add
> OrderID, ProductID, and Quantity columns to this
> table.
> B. Create a composite PRIMARY KEY constraint on the
> OrderID and ProductID columns of the Orders table
> C. Remove the ProductID and Quantity columns from the
> Orders table
> D. Create a UNIQUE constraint on the OrderID column of
> the Orders table.
> E. Move the UnitPrice column from the Products table
> to the Orders table.
>
> Ans: CE
>
>
>
| |
| Tom Jones 2002-06-23, 6:15 am |
| But if you do E/F you will probably increase redundant data - as unit prices
probably don't change that often ...
Answer C complements answer A (takes out the columns from Order that you
have put into OrderDetail)
I think my answer would be A & C
tom.
"Danut Prisacaru" <danutzp@hotmail.com> wrote in message
news:ukia1cg8BHA.2540@tkmsftngp07...
> I would say A and a kind of E meaning that you move the UnitPrice column
> from the Products table to the OrderDetail table. Let's call it F
>
> You do A to normalize the database and you do F because the price for the
> same product can change for different orders.
>
> Danut
>
> "Thomas Mundt" <lux_mundt@t-online.de> wrote in message
> news:aarkc4$14p$06$1@news.t-online.com...
> > Hi,
> >
> > i´m preparing for the 70-229 Exam.
> > Who can explane me why answer C and E for this question should be the
> right
> > one?
> >
> >
> > 1. You are designing a database that will contain
> > customer orders. Customers will be able to order
> > multiple products each time they place an order. You
> > review the database design, which is show below:
> >
> > Customers Orders Products
> > CustomerID OrderID ProductID
> > CompanyName ProductID Description
> > Address OrderDate UnitPrice
> > City Quantity
> > State CustomerID
> >
> > You want to promote quick response times for queries
> > and minimize redundant data. What should you do? (Each
> > correct answer presents part of the solution. Choose
> > two)
> >
> > A. Create a new order table named OrdersDetail. Add
> > OrderID, ProductID, and Quantity columns to this
> > table.
> > B. Create a composite PRIMARY KEY constraint on the
> > OrderID and ProductID columns of the Orders table
> > C. Remove the ProductID and Quantity columns from the
> > Orders table
> > D. Create a UNIQUE constraint on the OrderID column of
> > the Orders table.
> > E. Move the UnitPrice column from the Products table
> > to the Orders table.
> >
> > Ans: CE
> >
> >
> >
>
>
| |
| Greg Linwood 2002-06-23, 6:15 am |
| Hi Tom..
Obviously, the person who wrote this qn can't even pluralise properly. IMHO,
any professional would be naming the new table OrderDetails rather than
OrderDetail to be consistent with the existing naming convention.
That aside, C <<could>> be considered less efficient if orders with only one
detail line were to be kept in the Orders table. But this is the only thing
I can think of.
I do agree with F though - this will certainly speed up various queries, and
it also might not even be considered denormalisation in the case where
prices change...
HTH
Cheers,
Greg Linwood
"Tom Jones" <tom_jones8@hotmail.com> wrote in message
news:OZnG2dr8BHA.2080@tkmsftngp04...
> But if you do E/F you will probably increase redundant data - as unit
prices
> probably don't change that often ...
>
> Answer C complements answer A (takes out the columns from Order that you
> have put into OrderDetail)
>
> I think my answer would be A & C
>
>
> tom.
>
>
> "Danut Prisacaru" <danutzp@hotmail.com> wrote in message
> news:ukia1cg8BHA.2540@tkmsftngp07...
> > I would say A and a kind of E meaning that you move the UnitPrice column
> > from the Products table to the OrderDetail table. Let's call it F
> >
> > You do A to normalize the database and you do F because the price for
the
> > same product can change for different orders.
> >
> > Danut
> >
> > "Thomas Mundt" <lux_mundt@t-online.de> wrote in message
> > news:aarkc4$14p$06$1@news.t-online.com...
> > > Hi,
> > >
> > > i´m preparing for the 70-229 Exam.
> > > Who can explane me why answer C and E for this question should be the
> > right
> > > one?
> > >
> > >
> > > 1. You are designing a database that will contain
> > > customer orders. Customers will be able to order
> > > multiple products each time they place an order. You
> > > review the database design, which is show below:
> > >
> > > Customers Orders Products
> > > CustomerID OrderID ProductID
> > > CompanyName ProductID Description
> > > Address OrderDate UnitPrice
> > > City Quantity
> > > State CustomerID
> > >
> > > You want to promote quick response times for queries
> > > and minimize redundant data. What should you do? (Each
> > > correct answer presents part of the solution. Choose
> > > two)
> > >
> > > A. Create a new order table named OrdersDetail. Add
> > > OrderID, ProductID, and Quantity columns to this
> > > table.
> > > B. Create a composite PRIMARY KEY constraint on the
> > > OrderID and ProductID columns of the Orders table
> > > C. Remove the ProductID and Quantity columns from the
> > > Orders table
> > > D. Create a UNIQUE constraint on the OrderID column of
> > > the Orders table.
> > > E. Move the UnitPrice column from the Products table
> > > to the Orders table.
> > >
> > > Ans: CE
> > >
> > >
> > >
> >
> >
>
>
| |
|
| Hello guys,
I dont know if i am right but heres my idea.
--'A' would be correct.
--and 'C'... ( remove ProductId and Quantity) and ADD TotalCost...(?)
since OrderDetails (in A) will exist.. we dont need ProductId and
Quantity in Orders table. and to make Orders table useful we add
TotalCost(per Order) column. get it?
and "I think" you cant move UnitPrice to Orders table because its a
"UNIT" price .. meaning the price of one Product... so it must remain
in Products table.
anyway tell me if I am wrong. I'll be glad to hear your explanation.
| |
| Ali Moeen 2002-06-23, 6:15 am |
|
I would say the right answer is AC
If you have just Orders table and customer wnats to order 5 item, then you
have 5 time redundant CustomerID, OrderDate.It is not 3rd normal form.
TIP: Whenever you see any thing related to composit PK in MS Exams, just
ignore that option.
"Thomas Mundt" <lux_mundt@t-online.de> wrote in message
news:aarkc4$14p$06$1@news.t-online.com...
> Hi,
>
> i´m preparing for the 70-229 Exam.
> Who can explane me why answer C and E for this question should be the
right
> one?
>
>
> 1. You are designing a database that will contain
> customer orders. Customers will be able to order
> multiple products each time they place an order. You
> review the database design, which is show below:
>
> Customers Orders Products
> CustomerID OrderID ProductID
> CompanyName ProductID Description
> Address OrderDate UnitPrice
> City Quantity
> State CustomerID
>
> You want to promote quick response times for queries
> and minimize redundant data. What should you do? (Each
> correct answer presents part of the solution. Choose
> two)
>
> A. Create a new order table named OrdersDetail. Add
> OrderID, ProductID, and Quantity columns to this
> table.
> B. Create a composite PRIMARY KEY constraint on the
> OrderID and ProductID columns of the Orders table
> C. Remove the ProductID and Quantity columns from the
> Orders table
> D. Create a UNIQUE constraint on the OrderID column of
> the Orders table.
> E. Move the UnitPrice column from the Products table
> to the Orders table.
>
> Ans: CE
>
>
>
| |
| Chris Stevenson 2002-06-23, 6:15 am |
| I agree with your assertion but that is not part of the question. Most of
the MS questions in my experience are targeting the question for a
particular topic. In this question I think, based on the available answers
you need to select the ones that are the best based on the requirements of
the question. (Not nec. real world good practices. We don't want to read
too much into it.)
So, my opinions are below...
Customers will be able to order
multiple products each time they place an order.
>> A
You want to promote quick response times for queries
>>B
and minimize redundant data.
>> C
I guess you need to decide on the two BEST ones. I go A and C as the best
of the possible answers since we are designing the database and these are
the most important at this point. Query response is also very important but
the indexes you create will be based on the queries and the columns queried
that you use most. But an F: would be good too!
A. Create a new order table named OrdersDetail. Add
OrderID, ProductID, and Quantity columns to this
table.
>> Okay let's normalize, we are designing, right
B. Create a composite PRIMARY KEY constraint on the OrderID and ProductID
columns of the Orders table
>> This does create an index for faster query response times. If we do this
we won't be able to have multiple products per order unless we do "A" also
C. Remove the ProductID and Quantity columns from the
Orders table
>>If we chose A: then we would do this to minimize redundant data
D. Create a UNIQUE constraint on the OrderID column of the Orders table.
>>I like it if you don't use A:
E. Move the UnitPrice column from the Products table
to the Orders table.
>> Not necessary as you can use this in an order details query with a join
to products on ProdID, right.
My $.02
Regards,
Chris Stevenson, MCT, MCSE
"Danut Prisacaru" <danutzp@hotmail.com> wrote in message
news:ukia1cg8BHA.2540@tkmsftngp07...
> I would say A and a kind of E meaning that you move the UnitPrice column
> from the Products table to the OrderDetail table. Let's call it F
>
> You do A to normalize the database and you do F because the price for the
> same product can change for different orders.
>
> Danut
>
> "Thomas Mundt" <lux_mundt@t-online.de> wrote in message
> news:aarkc4$14p$06$1@news.t-online.com...
> > Hi,
> >
> > i´m preparing for the 70-229 Exam.
> > Who can explane me why answer C and E for this question should be the
> right
> > one?
> >
> >
> > 1. You are designing a database that will contain
> > customer orders. Customers will be able to order
> > multiple products each time they place an order. You
> > review the database design, which is show below:
> >
> > Customers Orders Products
> > CustomerID OrderID ProductID
> > CompanyName ProductID Description
> > Address OrderDate UnitPrice
> > City Quantity
> > State CustomerID
> >
> > You want to promote quick response times for queries
> > and minimize redundant data. What should you do? (Each
> > correct answer presents part of the solution. Choose
> > two)
> >
> > A. Create a new order table named OrdersDetail. Add
> > OrderID, ProductID, and Quantity columns to this
> > table.
> > B. Create a composite PRIMARY KEY constraint on the
> > OrderID and ProductID columns of the Orders table
> > C. Remove the ProductID and Quantity columns from the
> > Orders table
> > D. Create a UNIQUE constraint on the OrderID column of
> > the Orders table.
> > E. Move the UnitPrice column from the Products table
> > to the Orders table.
> >
> > Ans: CE
> >
> >
> >
>
>
| |
| Ali Khan 2002-06-23, 6:15 am |
| The answer is AC. E is not correct because you want to associate a Unit
Price to a product so it is
properly placed in the DB Schema. Transcender has this question as well.
--
Ali Khan
http://www.aquaticscape.com
"Thomas Mundt" <lux_mundt@t-online.de> wrote in message
news:aarkc4$14p$06$1@news.t-online.com...
> Hi,
>
> i´m preparing for the 70-229 Exam.
> Who can explane me why answer C and E for this question should be the
right
> one?
>
>
> 1. You are designing a database that will contain
> customer orders. Customers will be able to order
> multiple products each time they place an order. You
> review the database design, which is show below:
>
> Customers Orders Products
> CustomerID OrderID ProductID
> CompanyName ProductID Description
> Address OrderDate UnitPrice
> City Quantity
> State CustomerID
>
> You want to promote quick response times for queries
> and minimize redundant data. What should you do? (Each
> correct answer presents part of the solution. Choose
> two)
>
> A. Create a new order table named OrdersDetail. Add
> OrderID, ProductID, and Quantity columns to this
> table.
> B. Create a composite PRIMARY KEY constraint on the
> OrderID and ProductID columns of the Orders table
> C. Remove the ProductID and Quantity columns from the
> Orders table
> D. Create a UNIQUE constraint on the OrderID column of
> the Orders table.
> E. Move the UnitPrice column from the Products table
> to the Orders table.
>
> Ans: CE
>
>
>
| |
| Greg Linwood 2002-06-23, 6:15 am |
| If you leave Unit Price in the Product table, then all orders for any given
product will always have the same price - put another way, the price of
products cannot be changed. I don't know of any retailers who would be happy
with that.. (-;
The question really isn't about the suitability of the schema to any given
business rules - it's about performance and eliminating redundancy. E would
assist query performance by eliminating the need to join Product into any
given query, but only if that query doesn't need description from Query.
IMHO, this is a poorly worded question, as it states "You want to promote
quick response times for queries" without giving ANY indication about what
those queries might be. In some cases E WOULD improve response times and in
others it might not (given prices don't change for products).
"Ali Khan" <alikhanweb@hotmail.com> wrote in message
news:kCSE8.3188$KO1.2328876069@twister1.starband.net...
> The answer is AC. E is not correct because you want to associate a Unit
> Price to a product so it is
> properly placed in the DB Schema. Transcender has this question as well.
>
> --
> Ali Khan
> http://www.aquaticscape.com
> "Thomas Mundt" <lux_mundt@t-online.de> wrote in message
> news:aarkc4$14p$06$1@news.t-online.com...
> > Hi,
> >
> > i´m preparing for the 70-229 Exam.
> > Who can explane me why answer C and E for this question should be the
> right
> > one?
> >
> >
> > 1. You are designing a database that will contain
> > customer orders. Customers will be able to order
> > multiple products each time they place an order. You
> > review the database design, which is show below:
> >
> > Customers Orders Products
> > CustomerID OrderID ProductID
> > CompanyName ProductID Description
> > Address OrderDate UnitPrice
> > City Quantity
> > State CustomerID
> >
> > You want to promote quick response times for queries
> > and minimize redundant data. What should you do? (Each
> > correct answer presents part of the solution. Choose
> > two)
> >
> > A. Create a new order table named OrdersDetail. Add
> > OrderID, ProductID, and Quantity columns to this
> > table.
> > B. Create a composite PRIMARY KEY constraint on the
> > OrderID and ProductID columns of the Orders table
> > C. Remove the ProductID and Quantity columns from the
> > Orders table
> > D. Create a UNIQUE constraint on the OrderID column of
> > the Orders table.
> > E. Move the UnitPrice column from the Products table
> > to the Orders table.
> >
> > Ans: CE
> >
> >
> >
>
>
|
|
|
|
|