Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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. 

Answered Same Day Oct 08, 2019 COIT11237 Central Queensland University

Solution

David answered on Dec 28 2019
145 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, Sube
, State)
SalesOrder (SOID, Number, TotalPaid)
R2 (SOID, CID, FullPrice, FinalPrice)
Step 3 : Removing Transitive...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here