I. "ATLANTIS ISLAND FLIGHTS"


"Atlantis Island Flights", CASE*Designer Oracle. - , , . , , , - .

CASE*Dictionary : ,,, .

- , CASE*Designer'.

CASE. CASE*Designer' - Oracle.

, , (.. ), . , , , , . , , ..

------------------------------------------------------------ -+---------------------------------------------------------- -+---------------------------------------------------------- -+---------------------------------------------------------- -+---------------------------------------------------------- Date: 01-AUG-89 ORACLE: CASE*Dictionary Page: 1 DETAILED ENTITY DEFINITION Entity Name: TICKET Application: ATBS Version : 1 Sub-type of: Reference : TICKET Synonyms : GROUP TICKET Initial Volume: Average Volume: 60000 Maximum Volume: Annual Growth%: 15 --- DESCRIPTION - HAS SIGNIFICANCE AS ------------------- A means of acquiring the right to fly with an airline as a passenger. # A contractual document between an airline and a person, which may be exchanged, cashed in, or its constituent cou- pons exchanged for a journey with this or another airline. --- ATTRIBUTES ------------------------------------------ Name : CURRENCY Domain : CHAR CODE Opt : N Format : CHAR Length : 3 Name : DATE OF ISSUE Domain : Opt : N Format : DATE Length : Name : DISCOUNT GIVEN Domain : Opt : N Format : MONEY Length : 6.2 Name : FULL FARE Domain : Opt : N Format : MONEY Length : 6.2 Name : NUMBER Domain : Opt : N Format : INTEGER Length : 9 * Name : STAFF INDICATOR Domain : Opt : N Format : CHAR Length : 1 Name : TIME OF ISSUE Domain : Opt : N Format : TIME Length : * - Attributes in primary unique identifier --- RELATIONSHIPS --------------------------------------- EACH OCCURRENCE OF THIS ENTITY : MUST BE made up of ONE OR MORE COUPONS MUST BE issued by ONE AND ONLY ONE ORGANIZATION UNIT MUST BE for ONE AND ONLY ONE PERSON +- * - Relationships in primary unique identifier +- +- --- NOTES AND REMARKS ----------------------------------- +- L------------------------------------------------------------ ------------------------------------------------------------ -+---------------------------------------------------------- -+---------------------------------------------------------- -+---------------------------------------------------------- -+---------------------------------------------------------- : 01-AUG-89 ORACLE: CASE*Dictionary .: 1 Ƞ : Ҡ : ATBS : 1  : ࠠ : : Ҡ : 젠 : 60000 .: %: 15 --- - --------------------------- , - , . # , - , , - . --- -------------------------------------------- : ۠ : CHAR CODE .: N : CHAR : 3 : Ƞ : .: N : DATE : : : .: N : MONEY : 6.2 : ܠ : .: N : MONEY : 6.2 : Р : .: N : INTEGER : 9 * : ߠ : .: N : CHAR : 1 : Ƞ : .: N : TIME : * - --- ----------------------------------------------- : 砠 Š   ɠ ɠ +- ɠ Ƞ +- * - +- --- ------------------------------------------- +- L------------------------------------------------------------ ------------------------------------------------------------ -+---------------------------------------------------------- -+---------------------------------------------------------- -+---------------------------------------------------------- Date: 01-AUG-89 ORACLE: CASE*Dictionary Page: 2 DETAILED ENTITY DEFINITION Entity Name: COUPON Application: ATBS Version : 1 Sub-type of: Reference : COUPON Synonyms : Initial Volume: Average Volume: 90000 Maximum Volume: Annual Growth%: --- DESCRIPTION - HAS SIGNIFICANCE AS ------------------- The part of a ticket which entitles the named passenger to travel on a specified flight of an aircraft, assuming there is an available seat. The passenger would normally have an (implicitly) associ- ated booking and subsequent boarding pass for the same flight. --- ATTRIBUTES ------------------------------------------ Name : CHECK-IN TIME Domain : Opt : Y Format : TIME Length : 4 Name : COMMENT Domain : Opt : Y Format : CHAR Length : 20 Name : CONFIRMED INDICATOR Domain : INDICATOR Opt : Y Format : CHAR Length : 1 Name : FINAL CHECK-IN TIME Domain : Opt : Y Format : TIME Length : 4 Name : STATUS Domain : Opt : Y Format : CHAR Length : 1 * - Attributes in primary unique identifier --- RELATIONSHIPS --------------------------------------- EACH OCCURRENCE OF THIS ENTITY : MUST BE for ONE AND ONLY ONE SEAT CLASS MUST BE on ONE AND ONLY ONE TICKET * MUST BE open for ONE AND ONLY ONE AIRLINE ROUTE * OR MUST BE for ONE AND ONLY ONE FLIGHT * * - Relationships in primary unique identifier +- +- --- NOTES AND REMARKS ----------------------------------- +- L------------------------------------------------------------ ------------------------------------------------------------ -+---------------------------------------------------------- -+---------------------------------------------------------- -+---------------------------------------------------------- : 01-AUG-89 ORACLE: CASE*Dictionary .: 2 Ƞ : ͠ : ATBS : 1  : ࠠ : : : 젠 : 90000 .: %: --- - --------------------------- , - , . . --- -------------------------------------------- : ߠ : .: Y : TIME : 4 : Ƞ : .: Y : CHAR : 20 : ߠ : INDICATOR .: Y : CHAR : 1 : .