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...

1 answer below »

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.

unifolks_636430680621845555_113215_2.jpg unifolks_636430680621845555_113215_3.jpg
Answered Same DayOct 08, 2019COIT11237Central Queensland University

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

David answered on Dec 28 2019
146 Votes
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 : Removing Transitive...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?