Reference no: EM131171463
A tour company provides packaged tours, scheduled to depart several times a year. After a tour is scheduled, the company opens the tour for booking and invites tour guides to lead the tours. A scheduled tour can be guided by one or more tour guides, and a tour guide can guide as many tour schedules as long as there is no clash in the dates. Passengers can book any number of tours that have been scheduled.
You are given the TourScheduleGuidePassenger table:
TourScheduleGuidePassenger (tourld, tourName, numDays, itenary, country, cost, departureDate, guideld, dateJoined, guideName, guideGender, guideContact, passengerld, passengerName, passengerGender, passengerAddresss, passengerContact)
Based on the table,
(a) formulate and list the functional and multi-valued dependencies.
(b) propose candidate key(s) for the table.
(c) normalise the table to BCNF and 4NF by applying the BCNF approach. Show how you apply the steps to arrive at the tables and at each iteration, explain whether each derived table is already in BCNF and 4NF (if applicable).
(d) assemble your 4NF tables and constraints clearly.
(i) Give each table in this form:
TABLE-NAME(col-namei, col-name2, col-names)
indicating (PK) against the primary key and indicating (FK) against the foreign keys, if any.
(ii) State the referential integrity constraint(s), if any, together with the correct table in this form:
TABLE-NAMEx.col-name., ...col-name. must exist in
TABLE-NAMEy.col-namey,...col-names„
|
Calculate the specific steam consumption
: Compare the efficiencies and specific steam consumption obtained from Problems 8.1, 8.2, 8.3, and 8.4. Compare also the wetness of the steam leaving the turbines in each
|
|
Describe visual information processing
: Explain two conditions that impair visual information processing. Discuss current trends in the research of visual information processing and how they advance understanding of visual information processing.
|
|
Write an application that simulates coin tossing
: Write an application that simulates coin tossing. Let the program toss a coin each time the user chooses the "Toss Coin" menu option. Count the number of times each side of the coin appears.
|
|
Discuss the concept of first-come
: Discuss the concept of first-come, first served scheduling. Discuss the concept of Shortest-job first scheduling. Discuss the concept of Priority scheduling.
|
|
Formulate and list functional and multi-valued dependencies
: Formulate and list the functional and multi-valued dependencies. Show how you apply the steps to arrive at the tables and at each iteration, explain whether each derived table is already in BCNF and 4NF (if applicable).
|
|
What issues of transference are displayed by the client
: Is it possible that countertransference played a part in how the consultant acted? If so, how? What are the other pitfalls facing consultants in the mental health profession?
|
|
Calculate the maximum continuous rating of the boiler
: For preliminary calculations it is assumed that the actual cycle will have an efficiency ratio of 70% and that the generator mechanical and electrical efficiency is 95%. Calculate the maximum continuous rating of the boiler in kilograms per hour.
|
|
Operation on a class of design
: Provide the definition of what a unary operator is, and describe an application where it would be beneficial to provide an overloaded definition of it for operation on a class of your design.
|
|
Calculate the cycle efficiency of the plant
: The resulting water which is at saturation temperature is then pumped to the boiler. For the ideal cycle calculate. neglecting feed-pump work.
|