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 ¦¦¦¦ ¦ Èìÿ : ÎÊÎÍ×ÀÒÅËÜÍÎÅ ÊÎÍÒÐÎËÜÍ.
ÂÐÅÌß Äîìåí : ¦¦¦¦ ¦ Íåîáÿçàòåëüí.: Y Ôîðìàò : TIME Äëèíà : 4 ¦¦¦¦ ¦ Èìÿ : ÑÒÀÒÓÑ Äîìåí : ¦¦¦¦ ¦ Íåîáÿçàòåëüí.: Y Ôîðìàò : CHAR Äëèíà : 1 ¦¦¦¦ ¦ ¦¦¦¦ ¦ * - Àòðèáóòû â ïåðâè÷íîì óíèêàëüíîì èäåíòèôèêàòîðå ¦¦¦¦ ¦ ¦¦¦¦ ¦ --- ÑÂßÇÈ ----------------------------------------------- ¦¦¦¦ ¦ ¦¦¦¦ ¦ ÊÀÆÄÎÅ ÂÕÎÆÄÅÍÈÅ ÝÒÎÉ ÑÓÙÍÎÑÒÈ : ¦¦¦¦ ¦ ¦¦¦¦ ¦ ÄÎËÆÍÎ áûòü äëÿ ÎÄÍÎÃÎ È ÒÎËÜÊÎ ÎÄÍÎÃÎ ÊËÀÑÑÀ ÌÅÑÒ ¦¦¦¦ ¦ ÄÎËÆÍÎ âõîäèòü â ÎÄÈÍ È ÒÎËÜÊÎ ÎÄÈÍ ÁÈËÅÒ * ¦¦¦¦ ¦ ÄÎËÆÍÎ áûòü îòêðûòî ÎÄÍÎÃÎ È ÒÎËÜÊÎ ÎÄÍÎÃÎ ¦¦¦¦ ¦ äëÿ ÀÂÈÀÌÀÐØÐÓÒÀ * ¦¦¦¦ ¦ ÈËÈ ¦¦¦¦ ¦ ÄÎËÆÍÎ áûòü äëÿ ÎÄÍÎÃÎ È ÒÎËÜÊÎ ÎÄÍÎÃÎ ÐÅÉÑÀ * ¦¦¦¦ ¦ ¦¦¦¦ ¦ * - Ñâÿçè â ïåðâè÷íîì óíèêàëüíîì èäåíòèôèêàòîðå ¦¦+- ¦ ¦+- ¦ --- ÇÀÌÅ×ÀÍÈß ------------------------------------------- +- L------------------------------------------------------------ ------------------------------------------------------------¬ -+----------------------------------------------------------¬¦ -+----------------------------------------------------------¬¦¦ ¦ Date: 29-SEP-89 ORACLE: CASE*Dictionary Page: 3 ¦¦¦ ¦ ¦¦¦ ¦ DETAILED ENTITY DEFINITION ¦¦¦ ¦ ¦¦¦ ¦ Entity Name: AIRLINE ROUTE Application: ATBS ¦¦¦ ¦ Version : 1 ¦¦¦ ¦ ¦¦¦ ¦ Sub-type of: Reference : ROUTE ¦¦¦ ¦ ¦¦¦ ¦ Synonyms : Initial Volume: ¦¦¦ ¦ Average Volume: 50 ¦¦¦ ¦ Maximum Volume: ¦¦¦ ¦ Annual Growth%: 5 ¦¦¦ ¦ ¦¦¦ ¦ --- DESCRIPTION - HAS SIGNIFICANCE AS ------------------- ¦¦¦ ¦ ¦¦¦ ¦ A standard route flown by an airline on an approved ¦¦¦ ¦ schedule. ¦¦¦ ¦ ¦¦¦ ¦ --- ATTRIBUTES ------------------------------------------ ¦¦¦ ¦ ¦¦¦ ¦ Name : BOOKABLE SEATS INDICATOR Domain : INDICATOR ¦¦¦ ¦ Opt : N Format : CHAR Length : 1 ¦¦¦ ¦ Name : FLIGHT NUMBER Domain : ¦¦¦ ¦ Opt : N Format : CHAR Length : 6 ¦¦¦ ¦ Name : STANDARD FARE Domain : ¦¦¦ ¦ Opt : N Format : MONEY Length : 6.2 ¦¦¦ ¦ Name : STANDARD FARE CURRENCY Domain : CHAR CODE ¦¦¦ ¦ Opt : N Format : CHAR Length : 3 ¦¦¦ ¦ Name : DEPARTURE DAY Domain : ¦¦¦ ¦ Opt : Y Format : CHAR Length : 12 ¦¦¦ ¦ Name : REFRESHMENT TYPE Domain : CHAR CODE ¦¦¦ ¦ Opt : Y Format : CHAR Length : 3 ¦¦¦ ¦ Name : SCHEDULED ARRIVAL TIME Domain : ¦¦¦ ¦ Opt : Y Format : TIME Length : 4 ¦¦¦ ¦ Name : SCHEDULED DEPARTURE TIME Domain : ¦¦¦ ¦ Opt : Y Format : TIME Length : 4 ¦¦¦ ¦ ¦¦¦ ¦ * - Attributes in primary unique identifier ¦¦¦ ¦ ¦¦¦ ¦ --- RELATIONSHIPS --------------------------------------- ¦¦¦ ¦ ¦¦¦ ¦ EACH OCCURRENCE OF THIS ENTITY : ¦¦¦ ¦ ¦¦¦ ¦ MUST BE operated by ONE AND ONLY ONE AIRLINE * ¦¦¦ ¦ MUST BE to ONE AND ONLY ONE AIRPORT ¦¦¦ ¦ MUST BE from ONE AND ONLY ONE AIRPORT ¦¦¦ ¦ MUST BE specific to ONE AND ONLY ONE PERIOD ¦¦¦ ¦ MAY BE normally ONE AND ONLY ONE AIRCRAFT TYPE ¦¦¦ ¦ serviced by ¦¦¦ ¦ MAY BE referenced on ONE OR MORE COUPONS ¦+- ¦ +- L------------------------------------------------------------ ------------------------------------------------------------¬ -+----------------------------------------------------------¬¦ -+----------------------------------------------------------¬¦¦ ¦ Äàòà: 28-SEP-89 ORACLE: CASE*Dictionary Ñòð.: 3 ¦¦¦ ¦ ¦¦¦ ¦ ÄÅÒÀËÈÇÈÐÎÂÀÍÍÎÅ ÎÏÐÅÄÅËÅÍÈÅ ÑÓÙÍÎÑÒÈ ¦¦¦ ¦ ¦¦¦ ¦ Èìÿ ñóùíîñòè: ÀÂÈÀÌÀÐØÐÓÒ Ïðèêëàäíàÿ ñèñòåìà: ATBS ¦¦¦ ¦ Âåðñèÿ : 1 ¦¦¦ ¦ ¦¦¦ ¦ Ñóïåðòèï : Ññûëêà : ÌÀÐØÐÓÒ ¦¦¦ ¦ ¦¦¦ ¦ Ñèíîíèìû : Íà÷àëüíûé îáúåì : ¦¦¦ ¦ Ñðåäíèé îáúåì : 50 ¦¦¦ ¦ Ìàêñèìàëüí.îáúåì: ¦¦¦ ¦ Ãîäîâîé ïðèðîñò%: 5 ¦¦¦ ¦ ¦¦¦ ¦ --- ÎÏÈÑÀÍÈÅ - ÈÌÅÅÒ ÇÍÀ×ÅÍÈÅ --------------------------- ¦¦¦ ¦ ¦¦¦ ¦ Ñòàíäàðòíîãî ìàðøðóòà, âûïîëíÿåìîãî àâèàëèíèåé ïî óòâåðæ- ¦¦¦ ¦ äåííîìó ðàñïèñàíèþ. ¦¦¦ ¦ ¦¦¦ ¦ --- ÀÒÐÈÁÓÒÛ -------------------------------------------- ¦¦¦ ¦ ¦¦¦ ¦ Èìÿ : ÈÍÄÈÊÀÒÎÐ ÍÀËÈ×Èß ÌÅÑÒ Äîìåí : INDICATOR ¦¦¦ ¦ Íåîáÿçàòåëüí.: N Ôîðìàò : CHAR Äëèíà : 1 ¦¦¦ ¦ Èìÿ : ÍÎÌÅÐ ÐÅÉÑÀ Äîìåí : ¦¦¦ ¦ Íåîáÿçàòåëüí.: N Ôîðìàò : CHAR Äëèíà : 6 ¦¦¦ ¦ Èìÿ : ÑÒÀÍÄÀÐÒÍÀß ÑÒÎÈÌÎÑÒÜ Äîìåí : ¦¦¦ ¦ Íåîáÿçàòåëüí.: N Ôîðìàò : MONEY Äëèíà : 6.2 ¦¦¦ ¦ Èìÿ : ÂÈÄ ÂÀËÞÒÛ Äîìåí : CHAR CODE ¦¦¦ ¦ Íåîáÿçàòåëüí.: N Ôîðìàò : CHAR Äëèíà : 3 ¦¦¦ ¦ Èìÿ : ÄÅÍÜ ÎÒÏÐÀÂËÅÍÈß Äîìåí : ¦¦¦ ¦ Íåîáÿçàòåëüí.: Y Ôîðìàò : CHAR Äëèíà : 12 ¦¦¦ ¦ Èìÿ : ÒÈÏ ÎÁÑËÓÆÈÂÀÍÈß Äîìåí : CHAR CODE ¦¦¦ ¦ Íåîáÿçàòåëüí.: Y Ôîðìàò : CHAR Äëèíà : 3 ¦¦¦ ¦ Èìÿ : ÂÐÅÌß ÏÐÈÁÛÒÈß ÏÎ ÐÀÑÏÈÑÀÍÈÞ Äîìåí : ¦¦¦ ¦ Íåîáÿçàòåëüí.: Y Ôîðìàò : TIME Äëèíà : 4 ¦¦¦ ¦ Èìÿ : ÂÐÅÌß ÎÒÏÐÀÂËÅÍÈß ÏÎ ÐÀÑÏÈÑÀÍ.
Äîìåí : ¦¦¦ ¦ Íåîáÿçàòåëüí.: Y Ôîðìàò : TIME Äëèíà : 4 ¦¦¦ ¦ ¦¦¦ ¦ * - Àòðèáóòû â ïåðâè÷íîì óíèêàëüíîì èäåíòèôèêàòîðå ¦¦¦ ¦ ¦¦¦ ¦ --- ÑÂßÇÈ ----------------------------------------------- ¦¦¦ ¦ ¦¦¦ ¦ ÊÀÆÄÎÅ ÂÕÎÆÄÅÍÈÅ ÝÒÎÉ ÑÓÙÍÎÑÒÈ : ¦¦¦ ¦ ¦¦¦ ¦ ÄÎËÆÍÎ îáñëóæèâàòüñÿ ÎÄÍÎÉ È ÒÎËÜÊÎ ÎÄÍÎÉ ÀÂÈÀËÈÍÈÅÉ * ¦¦¦ ¦ ÄÎËÆÍÎ áûòü â ÎÄÈÍ È ÒÎËÜÊÎ ÎÄÈÍ ÀÝÐÎÏÎÐÒ ¦¦¦ ¦ ÄÎËÆÍÎ áûòü èç ÎÄÍÎÃÎ È ÒÎËÜÊÎ ÎÄÍÎÃÎ ÀÝÐÎÏÎÐÒÀ ¦¦¦ ¦ ÄÎËÆÍÎ áûòü ñâÿçàíî ñ ÎÄÍÈÌ È ÒÎËÜÊÎ ÎÄÍÈÌ ÏÅÐÈÎÄÎÌ ¦¦¦ ¦ ÌÎÆÅÒ îáû÷íî ÎÄÍÈÌ È ÒÎËÜÊÎ ÎÄÍÈÌ ÒÈÏÎÌ ÑÀÌÎËÅÒÀ ¦¦¦ ¦ îáñëóæèâàòüñÿ ¦¦¦ ¦ ÌÎÆÅÒ óêàçûâàòüñÿ íà ÎÄÍÎÌ È ÁÎËÅÅ ÊÓÏÎÍÀÕ ¦+- ¦ +- L------------------------------------------------------------ ------------------------------------------------------------¬ -+----------------------------------------------------------¬¦ ¦ Date: 29-SEP-89 ORACLE: CASE*Dictionary Page: 4 ¦¦ ¦ ¦¦ ¦ DETAILED ENTITY DEFINITION ¦¦ ¦ (CONTINUATION) ¦¦ ¦ Entity Name: AIRLINE ROUTE Application: ATBS ¦¦ ¦ Version : 1 ¦¦ ¦ ¦¦ ¦ Sub-type of: Reference : ROUTE ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ --- RELATIONSHIPS --------------------------------------- ¦¦ ¦ ¦¦ ¦ EACH OCCURRENCE OF THIS ENTITY : ¦¦ ¦ ¦¦ ¦ MAY BE covered by ONE OR MORE NORMAL CREW ¦¦ ¦ MEMBERSHIPS ¦¦ ¦ MAY BE scheduled as ONE OR MORE SCHEDULED FLIGHTS ¦¦ ¦ MAY BE additionally ONE OR MORE STANDARD CREW ¦¦ ¦ serviced by MEMBERSHIPS ¦¦ ¦ MAY BE normally serviced by ONE AND ONLY ONE ¦¦ ¦ ¦¦ ¦ * - Relationships in primary unique identifier ¦¦ ¦ ¦¦ ¦ --- NOTES AND REMARKS ----------------------------------- ¦¦ ¦ ¦¦ ¦ --------------------------------------------------------- ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ +- L------------------------------------------------------------ ------------------------------------------------------------¬ -+----------------------------------------------------------¬¦ ¦ Äàòà: 28-SEP-89 ORACLE: CASE*Dictionary Ñòð.: 4 ¦¦ ¦ ¦¦ ¦ ÄÅÒÀËÈÇÈÐÎÂÀÍÍÎÅ ÎÏÐÅÄÅËÅÍÈÅ ÑÓÙÍÎÑÒÈ ¦¦ ¦ (ÏÐÎÄÎËÆÅÍÈÅ) ¦¦ ¦ Èìÿ ñóùíîñòè: ÀÂÈÀÌÀÐØÐÓÒ Ïðèêëàäíàÿ ñèñòåìà: ATBS ¦¦ ¦ Âåðñèÿ : 1 ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ --- ÑÂßÇÈ ----------------------------------------------- ¦¦ ¦ ¦¦ ¦ ÊÀÆÄÎÅ ÂÕÎÆÄÅÍÈÅ ÝÒÎÉ ÑÓÙÍÎÑÒÈ : ¦¦ ¦ ¦¦ ¦ ÌÎÆÅÒ îáñëóæèâàòüñÿ ÎÄÍÎÉ È ÁÎËÅÅ ÄÎËÆÍÎÑÒßÌÈ Â ¦¦ ¦ ÎÁÛ×ÍÎÌ ÝÊÈÏÀÆÅ ¦¦ ¦ ÌÎÆÅÒ ïëàíèðîâàòüñÿ ÎÄÈÍ È ÁÎËÅÅ ÐÅÉÑΠ¦¦ ¦ êàê ¦¦ ¦ ÌÎÆÅÒ äîïîëíèòåëüíî ÎÄÍÓ È ÁÎËÅÅ ÄÎËÆÍÎÑÒÅÉ Â ¦¦ ¦ îïðåäåëÿòü ÑÒÀÍÄÀÐÒÍÎÌ ÝÊÈÏÀÆŦ¦ ¦ ¦¦ ¦ * - Ñâÿçè â ïåðâè÷íîì óíèêàëüíîì èäåíòèôèêàòîðå ¦¦ ¦ ¦¦ ¦ --- ÇÀÌÅ×ÀÍÈß ------------------------------------------- ¦¦ ¦ ¦¦ ¦ --------------------------------------------------------- ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ ¦¦ ¦ +- L------------------------------------------------------------ ------------------------------------------------------------¬ ¦ Date: 29-SEP-89 ORACLE: CASE*Dictionary Page: 5 ¦ ¦ ¦ ¦ DETAILED ENTITY DEFINITION ¦ ¦ ¦ ¦ Entity Name: CREW ASSIGNMENT Application: ATBS ¦ ¦ Version : 1 ¦ ¦ ¦ ¦ Sub-type of: Reference : CREW ASS¦ ¦ ¦ ¦ Synonyms : Initial Volume: ¦ ¦ Average Volume: 85000 ¦ ¦ Maximum Volume: ¦ ¦ Annual Growth%: ¦ ¦ ¦ ¦ ¦ ¦ --- DESCRIPTION - HAS SIGNIFICANCE AS ------------------- ¦ ¦ ¦ ¦ An allocation of a person, who must be an existing member ¦ ¦ of a crew, to either a complete flight or a component of ¦ ¦ a flight.
Each assignment is within the context of a ¦ ¦ specific crew role, which may differ from their normal ¦ ¦ crew role. Eg A captain acting as a second pilot. ¦ ¦ ¦ ¦ --- ATTRIBUTES ------------------------------------------ ¦ ¦ ¦ ¦ Name : DATE CANCELLED Domain : ¦ ¦ Opt : Y Format : DATE Length : ¦ ¦ Name : DATE MADE Domain : ¦ ¦ Opt : Y Format : DATE Length : ¦ ¦ Name : SPECIAL DUTY Domain : ¦ ¦ Opt : Y Format : CHAR Length : 80 ¦ ¦ ¦ ¦ * - Attributes in primary unique identifier ¦ ¦ ¦ ¦ --- RELATIONSHIPS --------------------------------------- ¦ ¦ ¦ ¦ EACH OCCURRENCE OF THIS ENTITY : ¦ ¦ ¦ ¦ MUST BE in ONE AND ONLY ONE CREW ROLE ¦ ¦ MUST BE of ONE AND ONLY ONE PERSON * ¦ ¦ ¦ ¦ MUST BE to ONE AND ONLY ONE FLIGHT * ¦ ¦ OR ¦ ¦ MUST BE to ONE AND ONLY ONE FLIGHT COMPONENT * ¦ ¦ ¦ ¦ * - Relationships in primary unique identifier ¦ ¦ ¦ ¦ --- NOTES AND REMARKS ----------------------------------- ¦ ¦ ¦ ¦ --------------------------------------------------------- ¦ ¦ ¦ L------------------------------------------------------------ ------------------------------------------------------------¬ ¦ Äàòà: 01-AUG-89 ORACLE: CASE*Dictionary Ñòð.: 5 ¦ ¦ ¦ ¦ ÄÅÒÀËÈÇÈÐÎÂÀÍÍÎÅ ÎÏÐÅÄÅËÅÍÈÅ ÑÓÙÍÎÑÒÈ ¦ ¦ ¦ ¦ Èìÿ ñóùíîñòè: ÍÀÇÍÀ×ÅÍÈÅ Â Ïðèêëàäíàÿ ñèñòåìà: ATBS ¦ ¦ ÝÊÈÏÀÆ Âåðñèÿ : 1 ¦ ¦ ¦ ¦ Ñóïåðòèï : Ññûëêà : ÝÊÈÏÀÆ ¦ ¦ ¦ ¦ Ñèíîíèìû : Íà÷àëüíûé îáúåì : ¦ ¦ Ñðåäíèé îáúåì : 85000 ¦ ¦ Ìàêñèìàëüí.îáúåì: ¦ ¦ Ãîäîâîé ïðèðîñò%: ¦ ¦ ¦ ¦ ¦ ¦ --- ÎÏÈÑÀÍÈÅ - ÈÌÅÅÒ ÇÍÀ×ÅÍÈÅ --------------------------- ¦ ¦ ¦ ¦ Íàçíà÷åíèÿ ëè÷íîñòè, ÿâëÿþùåéñÿ ÷ëåíîì ýêèïàæà, ëèáî íà ¦ ¦ âåñü ðåéñ, ëèáî íà åãî ÷àñòü.
Êàæäîå íàçíà÷åíèå ïðîèçâî- ¦ ¦ äèòñÿ â êîíòåêñòå êîíêðåòíîé ðîëè, âûïîëíÿåìîé â ýêèïàæå, ¦ ¦ êîòîðàÿ ìîæåò îòëè÷àòüñÿ îò îáû÷íîé ðîëè ÷ëåíà ýêèïàæà. ¦ ¦ Òàê, íàïðèìåð, êîìàíäèð ìîæåò äåéñòâîâàòü â êà÷åñòâå âòî- ¦ ¦ ðîãî ïèëîòà. ¦ ¦ ¦ ¦ --- ÀÒÐÈÁÓÒÛ -------------------------------------------- ¦ ¦ ¦ ¦ Èìÿ : ÄÀÒÀ ÎÒÌÅÍÛ Äîìåí : ¦ ¦ Íåîáÿçàòåëüí.: Y Ôîðìàò : DATE Äëèíà : ¦ ¦ Èìÿ : ÄÀÒÀ ÏÐÎÈÇÂÎÄÑÒÂÀ Äîìåí : ¦ ¦ Íåîáÿçàòåëüí.: Y Ôîðìàò : DATE Äëèíà : ¦ ¦ Èìÿ : ÎÑÎÁÀß ÎÁßÇÀÍÍÎÑÒÜ Äîìåí : ¦ ¦ Íåîáÿçàòåëüí.: Y Ôîðìàò : CHAR Äëèíà : 80 ¦ ¦ ¦ ¦ * - Àòðèáóòû â ïåðâè÷íîì óíèêàëüíîì èäåíòèôèêàòîðå ¦ ¦ ¦ ¦ --- ÑÂßÇÈ ----------------------------------------------- ¦ ¦ ¦ ¦ ÊÀÆÄÎÅ ÂÕÎÆÄÅÍÈÅ ÝÒÎÉ ÑÓÙÍÎÑÒÈ : ¦ ¦ ¦ ¦ ÄÎËÆÍÎ áûòü íà ÎÄÍÓ È ÒÎËÜÊÎ ÎÄÍÓ ÐÎËÜ Â ÝÊÈÏÀÆÅ ¦ ¦ ÄÎËÆÍÎ áûòü äëÿ ÎÄÍÎÉ È ÒÎËÜÊÎ ÎÄÍÎÉ ËÈ×ÍÎÑÒÈ * ¦ ¦ ¦ ¦ ÄÎËÆÍÎ ïðîèçâîäèòüñÿ ÎÄÍÎÃÎ È ÒÎËÜÊÎ ÎÄÍÎÃÎ ÐÅÉÑÀ * ¦ ¦ äëÿ ¦ ¦ ÈËÈ ¦ ¦ ÄÎËÆÍÎ ïðîèçâîäèòüñÿ ÎÄÍÎÉ È ÒÎËÜÊÎ ÎÄÍÎÉ ×ÀÑÒÈ ÐÅÉÑÀ * ¦ ¦ äëÿ ¦ ¦ ¦ ¦ * - Ñâÿçè â ïåðâè÷íîì óíèêàëüíîì èäåíòèôèêàòîðå ¦ ¦ ¦ ¦ --- ÇÀÌÅ×ÀÍÈß ------------------------------------------- ¦ ¦ ¦ ¦ --------------------------------------------------------- ¦ ¦ ¦ L------------------------------------------------------------
