Question 1 The following entity relationship diagram shows the relationship between order and part....

Question

Question 1 The following entity relationship diagram shows the relationship between order and part. However, the cardinalities have been mentioned incorrectly in that diagram and it does not show the fact that each order must contain atleast one part and a part may appear in more than one order.
Question 12 The following tour table contains sample data related to tours and tour guide. Each tour is accompanied by one guide only. Tour ID is the pimary key of Tour table.

David · Accepted Answer

Part B. Question 1. A.
The determinants of Station table are composite attributes. The attributes that are determinants are as follows.
· StationID
· FuelType
The attributes that are determined by determinants StationID, and FuelType are as follows.
· Name
· PostCode
· State
· Price
The functional dependencies  are as follows.
StationID  Name
StationID  PostCode
StationID  State
FuelType  Price
Part B. Question 1. B.
Satisfying BCNF
Step 1 : Removing repeating group to make in 1NF
The table has no repeating group so, it is in 1NF
Step 2 : Removing Partial Dependency to get table in 2NF
Customer (CID, Name, Email)
R1 ( PostCode, Street, Suberb, State)
SalesOrder (SOID, Number, TotalPaid)
R2 (SOID, CID, FullPrice, FinalPrice)
Step 3 :

Question 1 The following entity relationship diagram shows the relationship between order and part. However, the cardinalities have been mentioned incorrectly in that diagram and it does not show the...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment