Data Dictionary Entries The Pacific Holiday Company arranges cruise vacations of
ID: 3683742 • Letter: D
Question
Data Dictionary Entries The Pacific Holiday Company arranges cruise vacations of varying lengths at several locations. When customers call to check on the availability of a cruise, a CRUISE AVAILABILITY INQUIRY, illustrated in Figure below, is used to supply them with information.
1) Create the data dictionary structure for the CRUISE AVAILABILITY INQUIRY.
2)List the master files that would be necessary to implement the CRUISE AVAILABILITY INQUIRY
CRUISE AVAILABILITY HH:MM ENTER STARTING DATE 29-ZzZ-9999 CRUISE INFORMATION: CRUISE SHIP LOCATION STARTING DATE NUMBER OF DAYS COST DISCOUNTS ACCEPTED OPENINGS REMAINING zzzz9 xxxxococxxxxxxxxx ENDING DATE 29-Zzz-9999 z9-Zzz-9999 779 OCOXXXXXXXXXExplanation / Answer
Single master is sufficient with the following Data Entities:
1) Total no of Openings (N)
2) No of openings filled (F)
3) No of openings Remaining= (Balance = N-F)
4) MRPCOST
5) DISCOUNT
6) COST= MRPCOST - DISCOUNT
7) SHIP starting DATE
8) SHIP ENDING DATE
9) SOURCE LOCATION of ship
10) CURRENT LOCATION of ship
11) DESTINATION LOCATION of ship
12) DESTINATIONS for Arrival/pending
13) SHIP ID
14) SHIP NAME
15) CURRENT DATE and TIME
16) Total travel of ship in miles
17) Total travel of ship in days
18) Total travel of customer in days or hours
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.